Hi All ..
I have this workbook which contains 2 sheets ..
In 'Results' sheet i want to list all the rows from 'Data' sheet that only has a "Due Date" higher than TODAY().
What is the appropriate function to use?!!
the 'Results' sheet has an example of how it will look like after extracting rows ...
Thanks in advance...
Use this array formula in Shhet 1 A2, copied across and down:
=IFERROR(INDEX(Architects!A:A,SMALL(IF(Architects!$F$2:$F$20>TODAY(),ROW(Architects!$F$2:$F$20)),ROWS($1:1))),"")
Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly braces yourself - it won't work...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
.. and adjust the $F$2:$F$20 range as needed.
Another way to do is to use PivotTable.
Glenn Kennedy
That did the trick ..
Thanks for your help ...
josephteh
Thanks man .. i'll consider using this also ...
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks