Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Index Match
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Index Match
On Tuesday, April 3, 2012 10:26:27 AM UTC-5, Yunus wrote:
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 Can't you just use datafilterautofilter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Index Match
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reverse lookup function, index/match usage? | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
Reverse Index and Match Functions | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Reverse MATCH Function | Excel Discussion (Misc queries) |