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

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

[realmehranvahedi]

🌟 Engage & Win! The most liked comment gets pinned. Like your favorites and get involved!


👍 Like, Share, and Subscribe for more Excel tips!

[aaronhawkins]

This is amazing and helped me greatly.

[lookinward]

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

[waleedibrahim]

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.

[kerushannaidoo]

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

[ojyowyp]

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