I have a column of data in excel, which contains both numbers and chars. now without any filter on the data I can easily count the no of rows present (as the row count is mentioned in the right most column)
I want to ask that how can I automatically count the rows when I apply filter on the data and select a particular entry

I hope that you understand my question, otherwise pls just ask for clarification