Reverse Index Match

Y

Yunus

Hi I have a Table from A1 to BV140. Part of It showing below:
I have used Conditional Format to Highlight the Cells as follows, but
instead I would like to List the Names ad Courses for the Dates
Highlighted.
The Conditional Format I Used...
Cell Value <NOW(0) is Red
Cell Value <NOW(0) +14 is Yellow
Cell Value <NOW(0) + 42 is Orange
In Summary, I would like to Create a Separate Worksheet, Listing Names &
Courses whose:
Dates <Today
Dates <Today + 14
Dates <Today +42
And this is refreshed each Day, if the Table below is updated with new
dates.

Please not the Table Below is Synopsis:
Names are in Column A2 to A140
Courses are in ROW B2 to BVV2
And the Array is with Dates

Course 1 Course 2 Course 5 Course 6 Course 8
BAK, Andy 24/01/2012 27/01/2014 - 05/07/2012 -
ELV, Chris 08/06/2012 12/08/2013 15/07/2012 27/07/2012 -
LOE, Warren 01/02/2013 21/03/2015 11/11/2013 07/07/2012 -
MARTIN, Len 21/04/2012 10/05/2014 - 22/03/2012 -
SPEARMAN, Andy 29/06/2012 08/08/2013 - 27/06/2014 -
WALKER, Ryan 08/08/2012 01/09/2013 18/02/2012 22/08/2012
16/09/2012
TEBB, Benny 07/02/2013 07/02/2017 25/06/2012 29/08/2012 -
lETTIS, Roy 25/11/2012 03/11/2014 - 30/06/2012 -
SPENCE, Derren 21/07/2012 29/01/2014 23/05/2012 -
21/11/2013
ATKINSon, Steve 14/10/2013 - 29/06/2012 - -
FLaGG, David 09/10/2012 07/02/2014 - - -
KAr, Neville 31/08/2012 20/06/2013 22/01/2014 - 30/01/2014
TARRant, Lee 23/10/2012 28/03/2012 11/07/2012 - 19/04/2012
 
D

Don Guillett

Hi I have a Table from A1 to BV140. Part of It showing below:
I have used Conditional Format to Highlight the Cells as follows, but
instead I would like to List the Names ad Courses for the Dates
Highlighted.
The Conditional Format I Used...
Cell Value <NOW(0) is Red
Cell Value <NOW(0) +14 is Yellow
Cell Value <NOW(0) + 42 is Orange
In Summary, I would like to Create a Separate Worksheet, Listing Names &
Courses whose:
Dates <Today
Dates <Today + 14
Dates <Today +42
And this is refreshed each Day, if the Table below is updated with new
dates.

Please not the Table Below is Synopsis:
Names are in Column A2 to A140
Courses are in ROW B2 to BVV2
And the Array is with Dates

Course 1 Course 2 Course 5 Course 6 Course 8
BAK, Andy 24/01/2012 27/01/2014 - 05/07/2012 -
ELV, Chris 08/06/2012 12/08/2013 15/07/2012 27/07/2012 -
LOE, Warren 01/02/2013 21/03/2015 11/11/2013 07/07/2012 -
MARTIN, Len 21/04/2012 10/05/2014 - 22/03/2012 -
SPEARMAN, Andy 29/06/2012 08/08/2013 - 27/06/2014 -
WALKER, Ryan 08/08/2012 01/09/2013 18/02/2012 22/08/2012
16/09/2012
TEBB, Benny 07/02/2013 07/02/2017 25/06/2012 29/08/2012 -
lETTIS, Roy 25/11/2012 03/11/2014 - 30/06/2012 -
SPENCE, Derren 21/07/2012 29/01/2014 23/05/2012 -
21/11/2013
ATKINSon, Steve 14/10/2013 - 29/06/2012 - -
FLaGG, David 09/10/2012 07/02/2014 - - -
KAr, Neville 31/08/2012 20/06/2013 22/01/2014 - 30/01/2014
TARRant, Lee 23/10/2012 28/03/2012 11/07/2012 - 19/04/2012
Click to expand...

Can't you just use data>filter>autofilter>>>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Work Time 7
Calculating interest due on late loan payments 1
Check if a date comes before/after a range of dates 0
Find then highlight in yellow 6
Max-Min with specific criteria 1
How do I count the number of blank cells 0
15 minute data to daily data 1
Excel date formate doesn't change 0

Top