number of rows in filtered excel table Solved

Question

Hello,

I have a table in the form of a list.
When I sort it by applying a column filter, it automatically hides certain rows... that's completely normal :)
However, I can no longer refer to the row numbers to know the total number of rows in my filtered list. How can I get the number of rows after applying one (or more) filters?
Over to you!

argixu · Accepted Answer

Hello Barts,
Hello Vaucluse :)

... or before filtering, you put at the end of the data in one column
=SUBTOTAL(3;A2:A800)… for example
You will have the number of filtered rows

--
Argitxu, a Basque feminine first name... is pronounced Argitchou... in French "little light"! :))

Vaucluse · Answer

Good evening
You can, with an intermediary column:
place the number 1 in a column for each row of the table
in a cell above the filtered field (so that it remains displayed), the formula:
=SUBTOTAL(9;Limits of the column of 1)
will give you the total of the 1s that remain displayed.
Best regards
--
Let’s ask ourselves if we are not alone in understanding what is being explained?

Vaucluse · Answer

Hi Argi
nice thing you did, I had never tried 3 with the subtotal function, I learned something
Thanks
Special kiss, tonight, you deserve it

--
Let's ask ourselves if we're not the only ones who understand what we're explaining?

barts · Answer

Well, well, well!! I was just trying to avoid adding a column! The "3" parameter for the subtotal function is great...what are the other parameters and their usefulness?...(bonus question :) )

argixu · Answer

Re Barts,

The variants: type subtotal in the functions and request "help on this function". Everything is well explained there.

--
Argitxu, a feminine Basque first name... pronounced Argitchou... in French "little light"! :))

barts · Answer

Case closed, thank you both.

oceane · Answer

Hello,

I'm like you, I've struggled and I just found an easy solution.
On your table, before filtering, you act as if you want to do an automatic sum, except that you look for "average" by clicking on the little black cursor of automatic sum and you get your number of rows after hitting "enter". You leave it there.
Then you apply your filter and the sum changes every time with the correct number of rows - I did several tests. IT'S GREAT.

Number of rows in filtered excel table

7 réponses

Texture issues in enshrouded

Big fish games are they worth it?

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress