P
Paul
I have a spreadsheet that I have activated a filter, I
need to count the number of rows that the filer returned
need to count the number of rows that the filer returned
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyeR
Subtotal() works well on filtered lists.
Try:
=SUBTOTAL(3,A1:A100)
Look in Help for all the other function options.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have a spreadsheet that I have activated a filter, I
need to count the number of rows that the filer returned
Try:
=SUBTOTAL(3,A1:A100)
Look in Help for all the other function options.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have a spreadsheet that I have activated a filter, I
need to count the number of rows that the filer returned
D
Don Guillett
Have a look in HELP index for SUBTOTAL
D
DDM
Paul, assuming your UNfiltered data is in A1:A100, this will count the
number of rows a filter returns =SUBTOTAL(2,A1:A100).
The 2 tells the SUBTOTAL worksheet function to count the rows. When you have
time, search "SUBTOTAL Worksheet Function" in Excel help for your version.
Microsoft has introduced some enhancements to this function in Excel 2003.
number of rows a filter returns =SUBTOTAL(2,A1:A100).
The 2 tells the SUBTOTAL worksheet function to count the rows. When you have
time, search "SUBTOTAL Worksheet Function" in Excel help for your version.
Microsoft has introduced some enhancements to this function in Excel 2003.
F
Frank Kabel
Hi
try
=SUBTOTAL(3,A1:A1000)
try
=SUBTOTAL(3,A1:A1000)
D
DDM
....and I'm making the assumption that your column label (which you don't
want to count) is in A1.
want to count) is in A1.