Excel Help?

**CAL** · 02-15-2005, 01:49 AM

Hi All,

I need help with a formula in excel.

I have 2 worksheets. At the top of each column is a persons name and under each name there is dates. There is a bout 10 columns like this on each sheet.

I need a formula which will dispaly on a third sheet that shows:
The last 5 dates
Hows name that date is under.

For example:
Last 5 dates
Joe Blogs - 15/2/05
Joanne Blogs - 13/2/05
Barry Blogs - 11/2/05
Frank Blogs - 10/2/05
Sarah Blogs - 8/1/05

Any help is greatly appreciated!

Thanks

**Kyrnt** · 02-15-2005, 08:05 AM

Have you tried using the MAX() formula? I'm not sure if it works on dates, but it seems prudent that it would.

**CAL** · 02-15-2005, 08:48 AM

No, I hadnt. I will give it a try tomorrow at work.

Thanks & will let you know

**Spud In Disguise** · 02-15-2005, 02:14 PM

If you're still having trouble with that you could try the following site, I've found it very helpful! http://www.expertsexchange.com

(yes that's Experts Exchange, not Expert Sex Change)!!!!!!!!!

**QueenOfStarwars** · 02-25-2005, 08:57 PM

This is kind of a late delay, but you can use the "LARGE" function.

In your results worksheet, you might have:

cell A1: =LARGE(theRangeOfNumbers,1) to get the highest date
cell A2: =LARGE(theRangeOfNumbers,2) to get the second-highest date

The rangeOfNumbers is the range that you highlight which contains all of the dates.

etc...etc...

**CAL** · 02-25-2005, 10:00 PM

Thanks for your help

The MAX function seems to have done the job for me!