A formular to look up data and return dates
Hi Louis,
To keep it simple you'd need to use the COUNTIF function.
e.g.
With dates in row 1 starting at column A and staff names in column A
starting at row 1.
Enter the formulae =COUNTIF(B2:D2,"H") into cell E2 and
=COUNTIF(B2:D2,"S") into F2.
Copy these formulas down for the other staff members.
Blank cells and any cells containing anything other the H or S are
ignored.
14/12 15/12 16/12 Holidays Sick Days
Rob h s s 1 2
Mary h h 2 0
Kevin 0 0
NB The range B2:D2 works only for this example and will need to be
expanded for your version.
Hope this helps.
JF.
louiscourtney wrote:
I keep a spread sheet running that has dates along the top for each month and
names of staff down the side, if they take a holiday or are sick we enter "H"
or "S"
What i would like to have is a summery sheet that will list actual days
taken as sick or Holiday. So i assume maybe some sort of Lookup at looks for
the Letter H or S and then checks the date and then the name and returns a
date.
Is this possible?
Many thanks in advance for any help
|