Greetings all,

I have a column in Excel from which I only want values under a certain number. I know how to achieve this by using filtering. However my issue is, when I try to use the count function with this filtered data, it keeps counting values without the filter. Is there any way for me to perhaps change this column permanently or any other way for me to apply functions to this new filtered data? thanks