Hello all,
i have around 1,70,000 rows of data, i was using autofilter code for column number 6 to delete rows based on a condition(which works fine).the problem is that row no 5 has data to be deleted on 62 conditions or so and i read that autofilters can only be passed two conditions.http://social.msdn.microsoft.com/Forums/en-US/b…ltiple-criteria
now can somebody guide me to achieve the same using arrays?i know how to do them using a for loop but it will take a lot of time.the following are the conditions if found in the cell i wish to remove them entirely
[TABLE="width: 123"]
BENIN-00001
[/td][/tr][tr][td]BENIN-00002
[/td][/tr][tr][td]BENTB-0001
[/td][/tr][tr][td]BENTB-0002
[/td][/tr][tr][td]BENTB-0003
[/td][/tr][tr][td]BENTB-0004
[/td][/tr][tr][td]BENTB-0005
[/td][/tr][tr][td]BENTB-0006
[/td][/tr][tr][td]BENTB-0007
[/td][/tr][tr][td]BENTB-0008
[/td][/tr][tr][td]BENTH-00001
[/td][/tr][tr][td]CRPTB-00002
[/td][/tr][tr][td]GDSGL-00001
[/td][/tr][tr][td]GDSIN-00001
[/td][/tr][tr][td]GDSIN-00002
[/td][/tr][tr][td]GDSIN-00003
[/td][/tr][tr][td]LSIED-00001
[/td][/tr][tr][td]LSIES-00001
[/td][/tr][tr][td]PRSGS-00001
[/td][/tr][tr][td]PRSGS-00002
[/td][/tr][tr][td]PRSGS-00003
[/td][/tr][tr][td]PRSGS-00006
[/td][/tr][tr][td]PRSGS-00007
[/td][/tr][tr][td]PRSGS-00008
[/td][/tr][tr][td]PRSPS-00001
[/td][/tr][tr][td]PRSPS-00002
[/td][/tr][tr][td]PRSTB-0001
[/td][/tr][tr][td]PRSTB-0002
[/td][/tr][tr][td]PRSTB-0003
[/td][/tr][tr][td]PRSTB-0004
[/td][/tr][tr][td]PRSTB-0005
[/td][/tr][tr][td]PRSTB-0006
[/td][/tr][tr][td]PRSTB-0007
[/td][/tr][tr][td]SNMIN-00001
[/td][/tr][tr][td]SNMIN-00002
[/td][/tr][tr][td]TRGIN-00001
[/td][/tr][tr][td]TRGIN-00002
[/td][/tr][tr][td]TRGTH-00001
[/td][/tr][tr][td]BENEU-00002
[/td][/tr][tr][td]BENEU-00003
[/td][/tr][tr][td]GDSEU-00002
[/td][/tr][tr][td]GDSEU-00003
[/td][/tr][tr][td]GDSEU-00004
[/td][/tr][tr][td]PRSGS-00005
[/td][/tr][tr][td]PRSGS-00061
[/td][/tr][tr][td]PRSPS-00004
[/td][/tr][tr][td]PRSPS-00005
[/td][/tr][tr][td]TRGEU-00002
[/td][/tr][tr][td]TRGGB-00001
[/td][/tr][tr][td]BENMX-00001
[/td][/tr][tr][td]BENUS-00001
[/td][/tr][tr][td]BENUS-00002
[/td][/tr][tr][td]GDSCA-00001
[/td][/tr][tr][td]GDSGL-00002
[/td][/tr][tr][td]GDSMX-00001
[/td][/tr][tr][td]GDSUS-00001
[/td][/tr][tr][td]GDSUS-00002
[/td][/tr][tr][td]LSIPP-00001
[/td][/tr][tr][td]PRSGS-00004
[/td][/tr][tr][td]PRSPS-00003
[/td][/tr][tr][td]TRGMX-00001
[/td][/tr][tr][td]TRGUS-00001[TABLE="width: 123"]
[tr][td]BENIN-00001
[/td][/tr][tr][td]BENIN-00002
[/td][/tr][tr][td]BENTB-0001
[/td][/tr][tr][td]BENTB-0002
[/td][/tr][tr][td]BENTB-0003
[/td][/tr][tr][td]BENTB-0004
[/td][/tr][tr][td]BENTB-0005
[/td][/tr][tr][td]BENTB-0006
[/td][/tr][tr][td]BENTB-0007
[/td][/tr][tr][td]BENTB-0008
[/td][/tr][tr][td]BENTH-00001
[/td][/tr][tr][td]CRPTB-00002
[/td][/tr][tr][td]GDSGL-00001
[/td][/tr][tr][td]GDSIN-00001
[/td][/tr][tr][td]GDSIN-00002
[/td][/tr][tr][td]GDSIN-00003
[/td][/tr][tr][td]LSIED-00001
[/td][/tr][tr][td]LSIES-00001
[/td][/tr][tr][td]PRSGS-00001
[/td][/tr][tr][td]PRSGS-00002
[/td][/tr][tr][td]PRSGS-00003
[/td][/tr][tr][td]PRSGS-00006
[/td][/tr][tr][td]PRSGS-00007
[/td][/tr][tr][td]PRSGS-00008
[/td][/tr][tr][td]PRSPS-00001
[/td][/tr][tr][td]PRSPS-00002
[/td][/tr][tr][td]PRSTB-0001
[/td][/tr][tr][td]PRSTB-0002
[/td][/tr][tr][td]PRSTB-0003
[/td][/tr][tr][td]PRSTB-0004
[/td][/tr][tr][td]PRSTB-0005
[/td][/tr][tr][td]PRSTB-0006
[/td][/tr][tr][td]PRSTB-0007
[/td][/tr][tr][td]SNMIN-00001
[/td][/tr][tr][td]SNMIN-00002
[/td][/tr][tr][td]TRGIN-00001
[/td][/tr][tr][td]TRGIN-00002
[/td][/tr][tr][td]TRGTH-00001
[/td][/tr][tr][td]BENEU-00002
[/td][/tr][tr][td]BENEU-00003
[/td][/tr][tr][td]GDSEU-00002
[/td][/tr][tr][td]GDSEU-00003
[/td][/tr][tr][td]GDSEU-00004
[/td][/tr][tr][td]PRSGS-00005
[/td][/tr][tr][td]PRSGS-00061
[/td][/tr][tr][td]PRSPS-00004
[/td][/tr][tr][td]PRSPS-00005
[/td][/tr][tr][td]TRGEU-00002
[/td][/tr][tr][td]TRGGB-00001
[/td][/tr][tr][td]BENMX-00001
[/td][/tr][tr][td]BENUS-00001
[/td][/tr][tr][td]BENUS-00002
[/td][/tr][tr][td]GDSCA-00001
[/td][/tr][tr][td]GDSGL-00002
[/td][/tr][tr][td]GDSMX-00001
[/td][/tr][tr][td]GDSUS-00001
[/td][/tr][tr][td]GDSUS-00002
[/td][/tr][tr][td]LSIPP-00001
[/td][/tr][tr][td]PRSGS-00004
[/td][/tr][tr][td]PRSPS-00003
[/td][/tr][tr][td]TRGMX-00001
[/td][/tr][tr][td]TRGUS-00001
[/td][/tr]
[/TABLE]
[/TABLE]