COUNTING NAMES IN DATA BASE
Posted by JACK on September 14, 2001 1:09 PM
I HAVE A DATA BASE IN EXCEL AND I'M USING
DATA, FILTER, AUTO FILTER TO SORT THE DATA BASE.
WHEN I SELECT A FIELD TO SORT AND THE DATE COMES UP IN THE ACTIVE SHEET. I NEED TO KNOW HOW MANY NAMES THAT ARE SELECTED. HOW CAN I COUNT THE NUMBER OF NAMES IN THE ACTIVE DATA BASE?
Posted by IML on September 14, 2001 1:37 PM
Not sure I exactly follow, but try
=SUBTOTAL(3,A:A)-1
for your count of visable items in column A
Good luck
