formula

  • Thread starter Thread starter Kirandeep Singh
  • Start date Start date
K

Kirandeep Singh

Hi,

I have about 3000 rows filled with 114 unique items. Out of these unique
items I want few of them only. How can I delete the rest without manually
deleting each one of them. Through Custom Autofilter I can use only two
conditions.

Any suggessions..

Thanks in advance.

Best Regards,

Kirandeep Singh
 
I don't know your data structure, but you might consider using a Helper
Column and putting some combination of a IF/OR/AND/CONCATENATION formula to
consolidate several cells at once for filtering them as a group.

hth
Vaya con Dios,
Chuck, CABGx3
 
how about a loop
for each c in selection
if c.offset(,1)<>"hi" and c.offset(,2)<>2 etc then
c.entirerow.delete
end if
next c
 
Back
Top