G
Guest
I have a basic spread sheet of contact information...thousands of
records. I use filtering to group the information based on various
criteria, but I would also like to count the number of rows (records)
after I filter the whole data set. The usual count functions don't
ignore the hidden rows...which is what filtering does...hide some
things. Consequently, all I get is the total number of rows and not
just those the filter displays.
I saw this counting done, so I know it is possible, but I no longer
know where the person is who knew how to do this. Is there a function
that will do this or did the person create a program for it?? I seem
to recall it was latter.
Any help would be appreciated.
Henry
records. I use filtering to group the information based on various
criteria, but I would also like to count the number of rows (records)
after I filter the whole data set. The usual count functions don't
ignore the hidden rows...which is what filtering does...hide some
things. Consequently, all I get is the total number of rows and not
just those the filter displays.
I saw this counting done, so I know it is possible, but I no longer
know where the person is who knew how to do this. Is there a function
that will do this or did the person create a program for it?? I seem
to recall it was latter.
Any help would be appreciated.
Henry