Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Now that you've clarified your scenario better, try this on a spare copy
1. First, switch the calc mode* to manual (you've got 28k rows) 2. Put this in say, D2: =IF(COUNTA(A2:C2)<3,"",SUMPRODUCT((A$2:A2=A2)*(B$2 :B2=B2)*(C$2:C2=C2))1) Copy D2 down to the last row of source data in cols A to C. Press F9 to calc. Select col D, kill the formulas with an in-place: copy n paste special as values. Switch the calc mode back to automatic. 3. Apply n autofilter D1 for: TRUE 4. Copy the filtered rows paste special as values/formats into another sheet 5. Post a closure feedback here. Also, click the "Yes" button from where you're reading this response. *Click Tools Options Calculation tab (options to switch calc mode are there) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "dk" wrote in message ... ex: column a: is filename b:date modified c:type only when all 3 matches the exact same please note this is only example this is a listing of 28,000 rows of data .. also if we don't want to delete only copy the filtered to other location |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to remove duplicates? | Excel Discussion (Misc queries) | |||
Merge and remove duplicates? | Excel Worksheet Functions | |||
how to remove duplicates ONLY within the same category | Excel Discussion (Misc queries) | |||
Compare columns remove duplicates | Excel Discussion (Misc queries) | |||
Remove duplicates | Excel Discussion (Misc queries) |