User Posts: Nehad Ulfat
1
Find And Replace Multiple Values in Excel (6 Quick Methods)
0

In Microsoft Excel, it’s a usual scenario to find and replace multiple text or numeric values. You can use the Find and Replace command, apply different ...

0
How to Find External Links in Excel (6 Quick Methods)
0

While working with Microsoft Excel, it’s a common scenario to look for external links and references in the active workbook. In this article, you’ll get to ...

0
How to Use VLOOKUP to Return Multiple Columns in Excel?
0

In Microsoft Excel, there are several formulas available to VLOOKUP and return values from multiple columns. As the VLOOKUP function is not able to extract ...

0
Combine Text in Excel (8 Suitable Ways)
0

In Microsoft Excel, numerous methods are available to combine text with different criteria. In this article, you’ll get to learn all of those quick and simple ...

0
How to Concatenate Numbers in Excel (4 Quick Formulas)
0

In Microsoft Excel, there are numerous ways available to concatenate or join numbers to display in a single cell. The numbers can be of different formats and ...

0
How to Combine Date and Text in Excel (5 Ways)
0

There are numerous ways available in Microsoft Excel to combine date and time too easily. In this article, you’ll learn those simple and quick formulas to ...

0
How to Concatenate Date and Time in Excel (4 Formulas)
0

In Microsoft Excel, there are several simple and handy ways to concatenate date and time. You can also customize the formats of the date and time before ...

0
How to Combine Multiple Columns into One Column in Excel
0

In Microsoft Excel, there are several suitable methods to combine multiple columns into one column. In this article, you’ll learn how you can apply different ...

0
Opposite of Concatenate in Excel (4 Options)
0

In Microsoft Excel, there is no exact function that works as the opposite of concatenate function. But still, we have a number of suitable procedures and ...

0
VLOOKUP Example Between Two Sheets in Excel
0

In Microsoft Excel, the VLOOKUP function is generally used to look up a value in the leftmost column of a table and then return a value in the same row from a ...

0
How to Auto Populate from Another Worksheet in Excel
0

While working with multiple sheets in Excel, it’s very usual to feel the necessity to auto-populate data from another worksheet. There are a number of easy and ...

0
How to AutoFill Numbers in Excel (12 Ways)
0

There are several short and quick methods to autofill numbers in Microsoft Excel. In this article, you’ll learn how you can easily apply those useful ...

0
Excel Drop Down List Depending on Selection (5 Examples)
0

Drop down list can make tasks easy for users by giving them options to insert into a cell. Creating a drop-down list is way too easy with only a few quick ...

0
Create a Unique List in Excel Based on Criteria (9 Methods)
0

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove duplicates ...

0
Conditional Drop Down List in Excel (Create, Sort and Use)
0

In Microsoft Excel, the applications of the conditional or dependent drop-down list are immense in the field of data analysis. And creating this drop-down list ...

Browsing All Comments By: Nehad Ulfat
  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/

  6. Hello, Ali! Click here to autoscroll and you’ll find the download links for both pdf and xlsx formats.
    https://www.exceldemy.com/microsoft-excel-formulas-functions-cheat-sheet/#Download_Excel_Formulas_Cheat_Sheet_PDF

  7. Hello, James Garang! There’re two download links available just after the table of contents in this article. You can download pdf or xlsx version whatever you need!

  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!

  11. Glad to know it helped you, Kadiri!

  12. Glad to know it helped you!

  13. Glad to know it helped in your work!

  14. Hello, Missy! Please send us your problems here: [email protected]

  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/

  16. Hi Mohammad Sayed! Glad to know it helped you!

  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

 

 

ExcelDemy
Logo