how can you count the amount of filter options?

Question

I want the total filter options without having to count each individual one.

Thank you

Answer 1

Hi,

Thank you for reaching out. My name is Furkaan, a user just like you. I’d be happy to help you with your concerns. There isn't a universally applicable way to automatically count the number of filter options in an image without considering the context of the image. However, in the specific image you sent, which appears to be a screenshot of a filter menu from a business intelligence or data analysis software program, there are a couple of ways to estimate the total number of filter options:

Look for a scroll bar: If the filter menu has a scroll bar, it indicates that there are more options than can be displayed on the screen at once. In this case, you would need to scroll down to the bottom of the menu and count the number of visible options, then add however many options are hidden above the scroll bar to arrive at your total.

Look for a "Show All" option: Some filter menus have a "Show All" option that will expand the menu to show all available options. If this option is available, you can select it to see the total number of filters.

Unfortunately, the image you sent doesn't show either a scroll bar or a "Show All" option, so it's impossible to say for sure how many filter options there are in total. However, you can see that there are at least 18 filter options displayed on the screen, since the option labelled "180 INNOVATIONS" is the 18th option listed.

If you have any additional questions or concerns, please don’t hesitate to reach out. Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below. Best Regards, Furkaan

Answer 2

Hi Uri. I am an Excel user like you.

The filter options are a list of the unique entries in the column. You can use a formula to count these in a separate cell. In the screenshot the list is in my Column B, and I placed the formula in D2. Adjust the Column name in the formula to reflect the column you are counting. The -2 is to reduce the count because the UNIQUE function for the column will also include the header and a 0 for the blank cells in the column as unique entries.

=COUNTA(UNIQUE(B:B))-2

Answer 3

Thank you so much!

Exactly what I needed sometimes I count if there were smaller amounts say less than 20 but you saved me a lot of time as I had more than a 1000!!!

Answer 4

One question when it is counting the blanks is it only counting it once? So everytime I know there are blank entries that I do not want to count I put a ( -1 ) at the end?

Answer 5

Hi Uri!

I'm Shakiru and an Excel user like you.

Yes, that's correct. When you use the COUNTBLANK function in Excel, it counts each blank cell only once.

Yes.

I hope this helps! Please let me know if you need any other assistance and I will be more than happy to help further.

Thank you

Best Regards, Shakiru