Does anyone have a formula to count line items only if a cell has contents? There can be a random number of blank rows between items. See attached clarification!
Thanks!
Does anyone have a formula to count line items only if a cell has contents? There can be a random number of blank rows between items. See attached clarification!
Thanks!
Put this in B3:
=IF(C3="","",MAX(B$2:B2)+1)
then copy down.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks