Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SyrHoop
 
Posts: n/a
Default Fastest Way to Filter/Delete

I am trying to filter or delete rows based on a set critera, there are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the criteria (but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?



  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
maybe try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SyrHoop" schrieb im Newsbeitrag
...
I am trying to filter or delete rows based on a set critera, there

are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the criteria

(but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?




  #3   Report Post  
SyrHoop
 
Posts: n/a
Default

The Addin has been removed.


"Frank Kabel" wrote in message
...
Hi
maybe try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SyrHoop" schrieb im Newsbeitrag
...
I am trying to filter or delete rows based on a set critera, there

are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the criteria

(but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?






  #4   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi SyrHoop

I will upload a new version this evening to the page.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frank Kabel" wrote in message ...
Hi
maybe try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SyrHoop" schrieb im Newsbeitrag
...
I am trying to filter or delete rows based on a set critera, there

are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the criteria

(but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?






  #5   Report Post  
Ron de Bruin
 
Posts: n/a
Default

I upload it two minutes ago

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SyrHoop" wrote in message ...
The Addin has been removed.


"Frank Kabel" wrote in message
...
Hi
maybe try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SyrHoop" schrieb im Newsbeitrag
...
I am trying to filter or delete rows based on a set critera, there

are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the criteria

(but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?










  #6   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you also got my test report by now <vbg

--
Regards
Frank Kabel
Frankfurt, Germany

"Ron de Bruin" schrieb im Newsbeitrag
...
I upload it two minutes ago

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SyrHoop" wrote in message

...
The Addin has been removed.


"Frank Kabel" wrote in message
...
Hi
maybe try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SyrHoop" schrieb im Newsbeitrag
...
I am trying to filter or delete rows based on a set critera,

there
are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the

criteria
(but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?









  #7   Report Post  
Ron de Bruin
 
Posts: n/a
Default

LOL

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frank Kabel" wrote in message ...
Hi
you also got my test report by now <vbg

--
Regards
Frank Kabel
Frankfurt, Germany

"Ron de Bruin" schrieb im Newsbeitrag
...
I upload it two minutes ago

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SyrHoop" wrote in message

...
The Addin has been removed.


"Frank Kabel" wrote in message
...
Hi
maybe try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SyrHoop" schrieb im Newsbeitrag
...
I am trying to filter or delete rows based on a set critera,

there
are 27
different criteria (states).
I have tried to do this by deleting the row if it meets the

criteria
(but it
is very slow), there are over 12,000 entries.

Pivot table is not an option.

Is there a filter option for multiple criteria?











Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"