Excel Help

Closed
Saran - Oct 13, 2009 at 09:29 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 13, 2009 at 08:49 PM
Hello,


I have an excel sheet (sheet 1) with following columns and values filled in .

ID Status Name Original Date % Complete Forecast Date Actual Date
1 Good ss 10/13/2009
2 BAD DD 10/14/2009
3 NEW QQ 10/07/2009

I have another excel sheet (sheet 2) with a date field

10/14/2009

what i need is , In an another excel sheet (sheet3) , i have to get the rows in sheet 1, where the original date is greater than the date in sheet 2

so the sheet 3 contains on the following two rows

ID Status Name Original Date % Complete Forecast Date Actual Date
1 Good ss 10/13/2009
2 BAD DD 10/14/2009

is it possible using an formula, please let me know.

Thanks
Saran
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 13, 2009 at 08:49 PM
how can 10/13/2009 be greater than (you mean later than) 10/14/2009?
0