Thread
:
=counta() unless row is hidden
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Susan
external usenet poster
Posts: 1,117
=counta() unless row is hidden
hi all
in column A i have some text data. some of the rows have been
hidden. i want to count how many are left (visible). but any COUNT
functions count the hidden rows, too. any ideas?
thanks a lot in advance.
susan
Reply With Quote
Susan
View Public Profile
Find all posts by Susan