Find employee who worked more than "x" hours

[spiderlegs]

i have a list of employees and a column of each shift they worked and another column that shows the total number of hours they worked for that shift.

for example:

Tom Shift A 5 hrs
Jim Shift B 4 hrs
Kenny Shift C 9 hrs
Julie Shift A 4 hrs
Tom Shift B 4 hrs
Tom Shift A 5 hrs


If I want to find out which employee from my list of employees (not the list above, the ACTUAL, large list) has worked a total of more than 25 hours, how do i extract that data?

thanks

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Maybe if you look at the MAX Function

[spiderlegs]

ok here's a small example. it's not much different from what i explained above.

anyway i just needed a formula to gatther that statistic on how to find out at once which employee worked more than a certain number of hours.

[NBVC]

Select the entire range A1:D15 or whatever your last cell is...

Go to Format|Condtional formatting.

Select Formula Is from 1st drop down cell.

Then enter formula: =SUMIF($A$1:$A$15,$A7,$D$1:$D$15)>10

adjust the $15 to whatever last row in your selection is...

Click Format and choose from the Pattern tab.

This highlights the rows that have a name that has accumulated more than 10 hours.

[spiderlegs]

thank you
what does the A7 in the formula represent ?

[NBVC]

That should be A1:

=SUMIF($A$1:$A$15,$A1,$D$1:$D$15)>10