A
azidrane
Hey guys,
We need to have a formula that will count all visible rows on a sheet
(well in a perticular array actually. What we have is a sheet that
looks something like this
Name Data1 Data2 Data3
john smith 11 21 33
john smith 12 22 31
john smith 23 333
john smith 14 24 33
john smith 15 25 34
john smith 26 35
john smith 17 3
john smith 18 28 33
john smith 19 29 33
And we have auto filtering enabled on the top row. We would like a
formula that can count the number of visable rows after they are
filtered. Either a formula or VBA would work.
Make sence?
We need to have a formula that will count all visible rows on a sheet
(well in a perticular array actually. What we have is a sheet that
looks something like this
Name Data1 Data2 Data3
john smith 11 21 33
john smith 12 22 31
john smith 23 333
john smith 14 24 33
john smith 15 25 34
john smith 26 35
john smith 17 3
john smith 18 28 33
john smith 19 29 33
And we have auto filtering enabled on the top row. We would like a
formula that can count the number of visable rows after they are
filtered. Either a formula or VBA would work.
Make sence?