About Us

Yunus

In article <5839716.622.1333485454816.JavaMail.geo-discussion-
forums@ynlp6, says...

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

Not for the purpose I want it... but its been resolved, thanks.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
reverse lookup function, index/match usage?	Ambie	Excel Worksheet Functions	3	December 12th 08 02:22 AM
index(match) Wind Uplift Calculations (match four conditions)	JMeier	Excel Worksheet Functions	8	August 1st 08 01:45 AM
Reverse Index and Match Functions	karl	Excel Worksheet Functions	9	March 31st 08 12:10 AM
index match array function-returning only first match, need last.	Julie Olsen	Excel Worksheet Functions	3	December 29th 06 12:50 AM
Reverse MATCH Function	BillCPA	Excel Discussion (Misc queries)	2	March 9th 05 02:32 AM

Menu

About Us