Excel Excel 2003- how to pull out data matching the latest date for an item

[simo]

Hello

I have a report showing movement dates for items. I need to show the newest movement and give the details.

So this is column A ( item ID), B ( movement date) then the other details are from c onwards.
1054 16/07/2008
1054 11/07/2008
1057 22/10/2008
1057 09/06/2008

So how can I show the newest movements only ( the sheet has lots of different items on it)

Hope this makes sense!

 

[knight00779]

Hi

=B1 > DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

-- assumption "16/07/2008" is at cell B1 and others respectively
-- below will return "TRUE" if the date in B1 is greater than within 1 month back from Todays date.
-- Once you do this for all the records you will have out put in one column as TRUE or FALSE
-- This might not have been a complete end to end solution, however to start with you have now at least the dates which are changed within a month.

Hope this helps

Rgds

 

[simo]

thanks - useful but not quite what I need. Someone suggested writing SQL for this...

a b c
110511/02/2008 00:00PHD SWIRE AREA
110512/02/2008 00:00 PHD POCRA QUAY
11060101/06/2008 00:00AOB READY FOR USE
11068023/07/2008 00:00AOB CHECKING AREAAMC
101008/05/2008 00:00 PHD CHECKING AREAAMC
101009/05/2008 00:00 PHD READY FOR USE
So I would just want row 2,3,4,6 ( 1 and 5 are older )

 

[knight00779]

Hi, In excel too you can make up a query on the date column using MS query editor, To fetch all dates greater than wanted date