View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dlh dlh is offline
external usenet poster
 
Posts: 2
Default Show which entries in Search Table duplicates or triplicets

We have a parking problem. We write down license numbers of cars in the lot
at various times on various days. There are hundreds of entries. Now we
sort by license and see which cars have been here before, or which have NEVER
moved. I need a report of JUST the duplicate, triplicate or multiple
occurrences. IOW, if the entry is there more than once, I need to extract
that entry as a DOUBLE or a TRIPLE or worse. THen we target those worse
offenders
How can I do this with a defined range of date-time-license no-lot (we have
several lots). Thanks.