Using XL 2003


Goal: Find those employees charging gas more than once a day.

Fields - Date EmpID Amount

Output: Filtered XL sheet and/or
a printed list of only those employees
with more than one gas purchase in a single day

-OR-

Conditional Formating (cell Color) for those meeting
the above criteria

I am not sure of the smartest approach to solve quickly.
or even the formulas.

There are 54,000 purchases by 6500 employees

Thanks Dennis