NEHAD ULFAT is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET but switched gears, working as a content developer.  In this role, he creates techy content all about Excel and VBA. Later, he was promoted and worked as a project portfolio manager at ExcelDemy in SOFTEKO. You'll find him reading books, travelling, and watching documentaries outside work.

## Designation

Project Portfolio Manager at ExcelDemy in SOFTEKO.

## Education

B.Sc in Naval Architecture & Marine Engineering, BUET.

## Expertise

ABACUS, AutoCAD, Rhinoceros, Maxsurf, Hydromax, Excel, Word and PowerPoint

## Experience

• Technical Content Writing
• Team Management
• Project Management

## Summary

• He is currently working as Project Portfolio Manager at ExcelDemy in SOFTEKO.
• He started writing technical content for Excel & VBA for ExcelDemy in March 2021.
• He started working as a Team Leader at ExcelDemy.
• He was promoted to Project Manager at ExcelDemy in 2022.

## How to Use the AND Function in Excel – 7 Examples

This is an overview.   Introduction to the AND Function Function Objective: Checks all arguments and returns TRUE if all arguments ...

## How to Use NETWORKDAYS Function in Excel (6 Examples)

The image below illustrates the functionality of the Excel NETWORKDAYS function. Introduction to the NETWORKDAYS Function Function Objective: ...

## How to Use the DATEVALUE Function in Excel (6 Methods)

The screenshot below provides an overview of this article demonstrating the application of the DATEVALUE function in Excel. Introduction to ...

## Fix Excel Date Not Formatting Correctly (8 Quick Solutions)

Here's an overview of fixing the date format in Excel. You can use the Text to Columns feature to extract and format dates from cells. Fix 1 - ...

## Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

Example 1 - Advanced Filter for AND Criteria Below is our sample dataset. We’re going to extract data for all devices made in the USA and devices with prices ...

## How to Filter Multiple Rows in Excel: 11 Suitable Methods

Method 1 - Using Sort and Filter Command to Filter Multiple Rows Step 1: ➤ Select the headers of the table. ➤ Under the Home tab, select the Filter ...

## How to Sort Multiple Columns in Excel (5 Quick Methods)

We will use the sample dataset below for illustration. Watch Video – Sort Multiple Columns in Excel Method 1 - Using Sort & ...

## Using the OFFSET Function to Create and Use a Dynamic Range in Excel – 3 Examples

This is an overview:   The Excel OFFSET Function  Objective: Return a reference to a range that is a given number of rows and ...

## How to Add 30 Days to a Date in Excel – 7 Quick Methods

30 or any number of days can be added to a date, using different functions   Method 1 - Using an Algebraic Formula to Add 30 Days to a Date ...

## Sum with INDEX-MATCH Functions under Multiple Criteria in Excel

Dataset Overview The screenshot below provides an overview of the article, showcasing a dataset and an example of how you can evaluate sums in Excel across ...

## How to Find Top 5 Values and Names in Excel (14 Useful Ways)

In Excel 2019 or earlier versions, when using array formulas, press Ctrl + Shift + Enter instead of the Enter key and drag down the Fill Handle icon. For newer ...

## How to Use COUNTIF for Date Range in Excel (6 Suitable Approaches)

Here's an overview of the sample dataset and an example of the COUNTIF function to count data based on multiple criteria. The function is counting the ...

## SUMIF with INDEX and MATCH Functions in Excel

Here's an overview of the dataset and an example of the function to extract data by summing based on criteria. Introduction to SUMIF, INDEX, and ...

## How to Find Duplicates in Two Columns in Excel (6 Methods)

Dataset Overview The below screenshot is an overview the dataset & an example of the function to find duplicate values.   Method 1 - ...

## INDEX, MATCH and MAX with Multiple Criteria in Excel

Combining INDEX, MATCH, and MAX functions is one of the most comprehensive formulas which will let you extract maximum or largest values under multiple ...

1. Hi, Marian. All our Excel-related contents on this website have been made using Excel 365. I suggest you try the formulas in Excel 365 or Excel 2021 version. Thanks!

2. Hello, Kim! You can contact him through this email address:
[email protected]

3. Hello, Stefano! Can you please share your queries in English? Thanks!

4. Thanks for mentioning, Ehsan! Pardon our mistake, we’re uploading it within next 24 hours!

5. Hello. Tabuaka! You can check out our practice problems which should help you to get familiar with Excel works!
https://www.exceldemy.com/topics/calculation-with-excel-formulas/

8. Hi, Bruce Ritch! Glad to know it helped you! 🙂

9. Great to know it helped you!

10. Hello, Barry! You can check your default path folder for browser downloads. And if you need any assistance with the Excel problems you can mail us!

12. Glad to know it helped you!

15. Hello, ABDELAZIZ SALIH ABDELLAH ADAM! You can check out the following link to get access to some of our learning resources related to MS Excel.
https://www.exceldemy.com/learn-excel/

17. Hello, Lalit Kansal! You can send us your attachment to this email: [email protected]

18. Hello, John! Can you please email us the Excel file containing the dataset with the problem? We’ll look into it & try to solve it asap.

19. Thanks for your feedback, Carol! Best regards.

20. Hello, TRYSTAN! Can you please email us your Excel file containing the dataset with the problem? Thanks.

21. Hello, OLUNIYI! Can you please email us your Excel file containing the dataset with the problem?

22. Hi, NOHEMI WEST-PHELPS! Can you please email us the Excel file containing the problem with the dataset?

23. Hello, ARIZONA AMBER! To enable Developer tab, you have to follow this procedure: Go to Excel Options > Customize Ribbon > Customize the Ribbon > Main Tabs > (Check) Developer tab.

24. Hello, MAUREEN E CLAYCOMB! You can mention the keywords or problem here, we’ll try to prepare & publish the article within 2-3 days.

25. Hello, SR! Thanks for your recommendation. We’ll cover this part & give you an update soon.

26. Hello, KRISHNAN V! Thanks for your feedback. Hope you’ll find our other articles useful as well when needed for your works!

27. Hello, OPIYO DENIS OCAYA! You can download our practice workbook and use it as a calculator which is quite similar to using an app instead!

28. Hello, Mary Visco! The downloadable file has been sent to your gmail address. If you can’t find the mail in inbox then please look for it in spam folder. Best regards!

29. Hello, GOKTUG! All of our contents were prepared based on Excel 365 version only. So, I recommend using the Excel 365 version instead of 2019. Hopefully it should fix your issues!

30. Hello, Sanooj Kumar! When this content was prepared, we used Excel 365 version. Could you please try out the similar version?

31. Hello, RUBAN! You can send your Excel Macro related problem to this email: [email protected]. We’ll start working on your problem as soon as we receive your mail! Thanks.

32. Hello, JUAN! Glad to know you’ve found the solutions finally from our article!

33. You’re welcome, RAAA1987! Best regards!

34. Hi, ETHAN! Hope, the solutions have worked for you!

35. Hello, PIET STRYDOM, you can check out this link to learn VBA programming step by step! Thanks!
https://www.exceldemy.com/excel-vba-macros/

36. You’re welcome, CHRIS! Best regards!

37. Thanks, SANDEEP! Best regards!

38. Hello, Nick! Right now we’re not working with Mac so unfortunately we’re unable to provide you with the exact solutions.

39. You’re welcome, ZAFER!

40. Thanks, AJAY!

41. You’re welcome, LAUREN! I hope, you’ll find more other solutions in our blog related to Excel problems in future!

42. Thanks, TODD! Good to hear from you!

43. Hello Jess, you’re most welcome! If you need any other solutions to more problems you can also email us.

44. You’re most welcome, Ovi! We’re always trying hard to deliver the best possible solutions to our readers.

45. I think your query should meet the requirements in methods 2.2 to 2.4. You can use any of them while dealing with similar numeric values. If it yet does not fulfill your criteria, then let me know. I’ll catch you up as soon as possible!

46. Hi Roberto,
If you write “=IF(A2“”,NOW(),””)” in Cell B2, then the timestamp in Cell B2 will update for each input name in the following cells(A3,A4,…….). To fix timestamp for each entry, you have to type “=IF(A2””,IF(B2=””,NOW(),B2),””)” in Cell B2.

Advanced Excel Exercises with Solutions PDF