ExcelBanter - deleting dupes/certain values

With headers in row 1 and your data sorted nicely (by columns A, B, and G)

Use a helper column of cells:

Start in row 3 (row 2 is the one kept):
=and(a2=a3,b2=b3,g2=g3)
drag down the column.

copy that column|paste special values

The ones that show True should be deleted (if you eyeball them and see a
problem, don't delete them!)

Sort by that column and delete those True's.

(or apply data|filter|autofilter and show the True's and delete them that way.)

If you have lots of duplicates, sorting first should be quicker.

===
If it's a single column that contain Secretary.

Data|filter|autofilter by that column
Custom filter
contains secretary

delete those visible rows.

====
if secretary is in any old cell:

add a helper column of cells:
=countif(a2:x2,"secretary")
or
=countif(a2:x2,"*secretary*")
If the cell contains more words than Secretary.

then filter by 0.
Delete those visible rows.

slliks wrote:

I would appreciate any help given. Thank you ahead of time.

i have a workbook with about 15,000 rows.

I've merged 2 other workbooks and imported serveral databases from act.
all the columns etc are all lined up. any how, i need to erase
duplicates. and its a real tedious task just sitting here. and going
thru and checking columns a, b and g to see if they all match. and then
deleting them. PLEASE HELP :) any how. the 2nd thing i need to do is
delete rows that contain certain words like secretary, or CFO etc.

again. any help would be great appreciated. thank you.

charlton

--
slliks
------------------------------------------------------------------------
slliks's Profile: http://www.excelforum.com/member.php...o&userid=15575
View this thread: http://www.excelforum.com/showthread...hreadid=271331

--

Dave Peterson