help! formulas

C

cindyd

I have 2000 row shreadsheet of dates. Need to determine which date is
greater than 10/31/2005 and return to another worksheet.
Any guesses on least painful way to do?
 
M

Myrna Larson

You haven't said whether there is more than one date > 10/31/2005, but you can
try this array formula, entered with CTRL+SHIFT+ENTER:

=MAX(IF(B2:B2001>DATE(2005,10,31),B2:B2001))

If there is more than one such date, the above returns the latest one. If you
want the first one in the list,

=INDEX(B2:B2001,MIN(IF(B2:B2001>DATE(2005,10,31),ROW(B2:B2001)-1)))
 
C

cindyd

Thank you for your reply! Yes there are many dates in that column.
From 2003 to 2014.
I want only the dates greater than 10/31/2005 to return to the other
worksheet. ONLY if they meet the criteria of > 10/31/2005.
 
J

Jim May

I'de engage an Auto-filter on your total range;
then on the date column select the "greater than" - also
enter 10/31/2005 in box.
This should give you **ONLY** records of 10/31/05 and beynd.
Copy and Paste All these records to a new sheet.
HTH
 
Top