working w/ filters

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
846
Office Version
  1. 2013
Platform
  1. Windows
this is going to be a bit hard to explain, lets see if i succeed :)

OK so I'm working with about 100K lines of data. In the artist column not all of these entries are unique. Lets say each artist is mention 10-100 times. This means when I goto the filters so I can choose only one artist the list is still pretty long. I'd like to be able to type in, say, Pitbull, and tick that checkbox, and have only his rows show up. However when I do that for some reason all the other checkboxes stay ticked. My unchecking them before typing this name doesnt change that. If I click 'add to selection' that doesnt change anything either.

help!
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top