How to display values that occur multiple times

**fnb4321** · 07-03-2009, 03:19 PM

I've been asked to identify users have logged in to a report system three
or more times a day.

I can capture the logon info and put in a s/s. How would I filter the results to display only client names that appear in the data 3 or more times ?

**zbor** · 07-03-2009, 03:25 PM

Can you check my post here? Maybe this is what you looking for...
(I didn't solve his porblems but I might solve yours

)

http://www.excelforum.com/excel-gene...me-period.html

Also, check other solutions, you might find somenthing usefull...

**martindwilson** · 07-03-2009, 06:14 PM

if its only dates (not dates and times)
assuming header row is row 1 and dates in col a names in col b
in c2 put =SUMPRODUCT(--($A$1:$A$45=A2),--($B$1:$B$45=B2))>2
and drag down
you will get true/false
use auto filter on true