creating a top 10 list

[ali]

Hi folks,

i've posted this in ...excel.worksheet.functions, but had no reponse and
really need some help...

a worksheet contains:

column a: staff payroll number
column b: first date of absence
column c last date of absence
column d: number of days absent (as some staff are part-time)

the 4 pieces of data are added succesively when staff return to work
folowing a period of absence (staff can appear multiple times).

I need to:

a) find the top 10 staff who're most frequently absent (i.e. the count of
most frequent payroll numbers), and
b) find the top 10 staff who've racked up the most days absence (sum of days
absent, remember that the same payroll number appears multiple times)

I'd need to produce these rankings within the date parameters, e.g for April
1st to June 30th.

vba is not an option. it must be done using w/sheet formulae.


thanks in advance
paul

 

[Herbert Seidenberg]

Excel 2007 PivotTable
No VBA, easy formula.
http://www.mediafire.com/file/i2knmdkjzzg/06_27_09a.xlsx

 

[ali]

herbert

thanks. i should have stated i'm using xl 2003 (and worse still, Star Office
at home), so will need to have a look at this in the next couple of days).

cheers
Paul