Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "richzip" wrote in message ... 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" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "richzip" wrote in message ... 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing two Non- Identical Columns of Data | Excel Discussion (Misc queries) | |||
search and filter | Excel Worksheet Functions | |||
compiling data with non-identical subjects | Excel Discussion (Misc queries) | |||
Excel 2002: Can Vlookup search for identical references ? | Excel Discussion (Misc queries) | |||
COMPARE IDENTICAL DATA | New Users to Excel |