Thread: Excel Help
View Single Post
Old 22-04-2005, 09:25   #1
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 46
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Excel Help
Hi All,

A quick bit of Excel help please. I have a sheet that contains data shown below....

11/09/2000 A0052 0.0105
29/09/2000 A0052 0.0205
13/10/2000 A0052 0.0314
20/09/2002 A0347 1.0389
29/09/2002 A0347 1.0455
13/10/2002 A0347 2.0214

What I want to be able to do is fliter the sheet in someway so that it only keeps the latest date by each "A" number. So the sheet above would become...

13/10/2000 A0052 0.0314
13/10/2002 A0347 2.0214

Anyone any ideas, or will I need to write some code to do it? (I would prefer not too!)

Thanks

Gareth
gazzae is offline   Reply With Quote