Excel experts.

[Dracata]

So.

I have two excel columns, like this;

01/04/2011 David
02/04/2011 Alex
03/04/2011 Jonny
04/04/2011 David
05/04/2011 Alex
06/04/2011 Jonny

In a separate worksheet, I would like to list all of the dates to the immediate left of "David".

Any idea how I might do this?

 

[Daveangle]

You can do this with a Pivot Table, assuming you have the following

Date Name
01/04/2011 David
02/04/2011 Alex
03/04/2011 Jonny
04/04/2011 David
05/04/2011 Alex
06/04/2011 Jonny

With Date and Name as column heading you can create a Pivot Table and filter on David and have Date as a Row reference.

 

[Dracata]

Cheers Pete, I just came back to say that I'd done it with.. a pivot table!

I'd half written a macro when one of our developers pointed it out.

 

[Daveangle]

NP matey