Search/Filter for identical data

[richzip]

I have a large worksheet for employee data. Each employee ID (column A) has
1 row for every date (column E) of the month, activity performed on that date
(column K), and a job code (column P) for the activity on that date.

I want to filter rows that have identical dates (any date), idential
activity (any date) and a specific job code (LD).

 

[Ron de Bruin]

Hi richzip

Maybe this will give you a start
http://www.rondebruin.nl/copy5.htm

See the filter tips below the macro on the first page

 

[richzip]

Hi Ron,

Thanks for the input! I assume you meant the "easy filer" download. It
looks like the "Unique or Duplicate" option will work for what I need.
However, when I started that option, a new workbook did open, but nothing was
copied. I was also unable to re-select the original work book. When I do,
the Excel window just "flashes", but the new workbook stays as the active
window.

At first I thought it was just because my worksheet was very large
worksheet, so I deleted most of the rows (left with just 30 rows) to do a
test on a smaller scale.

 

[Ron de Bruin]

Hi richzip

If you want send me your small workbook private and I take a look,
you will find my mail address here
http://www.rondebruin.nl/



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm