EXTRACT ALL RECORDS BETWEEN TWO DATES IN EXCEL : using the Index Match Formulas

Подписаться 1,7 тыс.

Просмотров 14 тыс.

50% 1

LOOKUP & EXTRACT ALL values between two dates
Formula used in this tutorial:
In the formula below replace (SMALLERTHAN) with the "smaller than angled bracket" and (GREATERTHAN) with the "greater than angled bracket" in MS Excel (Sorry...those symbols could not be inputted within the description box) :
=IFERROR(INDEX($A$6:$C$43,SMALL(IF(($A$6:$A$43(SMALLERTHAN)$B$3)*($A$6:$A$43(GREATERTHAN)$B$2),MATCH(ROW($A$6:$A$43),ROW($A$6:$A$43)),""),ROW(A1)),COLUMN(A1)),"")
#exceltips
#excel
#indexmatch

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@realmehranvahedi 6 месяцев назад

Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!

@aaronhawkins6938 5 месяцев назад

This is amazing and helped me greatly.

@realmehranvahedi 5 месяцев назад

Thank you so much for your kind words! I'm thrilled to hear that you found the video amazing and that it was of great help to you. Your support encourages me to create more helpful and interesting videos. Looking forward to sharing more with you. Stay tuned!

@lookin4ward1 7 месяцев назад

Awesome job, I want to do this to an entire spreadsheet with multiple pages

@realmehranvahedi 7 месяцев назад

Thank you so much for your kind words! I'm thrilled to hear that you enjoyed the content and found it useful. If you have any suggestions for future videos or topics you'd like to see, feel free to let me know. Thanks again for watching!

@waleedibrahim4558 Год назад

Thank you for your informative videos. I have a particular case in excel in which I couldn’t find any solution to it and I hope you can help me with it. If I have various numbers in column B, and I need these numbers to be (increased/decreased): • By 0.5 either to make it 20.5 or 19.5 • Or by 1 to make it either 21 or 19 • Or 2 to make it 22 or 18 …etc. • The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example: • The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5 • The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12 • The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is. I hope you can find time to answer this very soon. Thanks again.

@realmehranvahedi Год назад

Hello Waleed, thank you very much for leaving a comment. I appreciate it. I think what you are trying to do could be acheived using two drop down menus and then a conditional IF statement. For example, if the first drop down selected is "decrease" and the second drop down is "1" the If statement will decrease the value by 1 and same principal applies if the value in drop boxes are anything else (e.g "increase" and any of the other numbers). I hope this answers your question.

@waleedibrahim4558 Год назад

@@realmehranvahedi Thank you very much for your reply.

@fatemehsamimi2205 Год назад

Grt video. Thanks

@realmehranvahedi Год назад

Hi Fatemeh, many thanks for the comment. I'm glad you liked it. Make sure you turn on notification as I have a lot of new cool videos coming up in the upcoming weekes.

@CCAFO Год назад

This is so good!

@realmehranvahedi Год назад

You're very welcome. I'm glad you found it useful.

@kerushannaidoo2862 2 месяца назад

Hi, when watching these videos I like to duplicate the sheet exactly and workout the formula, but I cant get it to work.? Weird

@realmehranvahedi 2 месяца назад

Hi @kerushannaidoo2862, Thanks for following along with the video! When you try to replicate the formula, what exactly happens? Understanding the issue better will help me assist you more effectively. Here are a few quick tips to check: 1. Double-check for any typos in the formula and cell references. 2. Ensure the date cells are formatted properly as 'Date'. 3. If it's an array formula, remember to enter it with "Ctrl+Shift+Enter" (for older Excel versions). If you could provide more details about the issue or share a screenshot of your formula and the error message, if any, I would be more than happy to help you troubleshoot further! In the meantime, here’s a simple checklist to follow: > Ensure all ranges in the formula match those used in the video. > Verify that all data used in conditions (like dates) is consistent in formatting. > Confirm that you are entering array formulas correctly if needed. Let’s get this solved so you can use Excel to its fullest!

@user-oj7yo3wy2p 5 месяцев назад

Did not take the time to explain the formula, which is the most important part

@realmehranvahedi 5 месяцев назад

Hello, Thank you for your valuable feedback. I'm committed to improving and will ensure to dedicate more time to explaining the formulas in more detail as suggested in future videos. Could you please specify which part of the formula in the video was unclear or required further explanation? Your insights will help me tailor the content more effectively.