|
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? |
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? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com