How people,
I have a question. How can automatic numbering in list F10:F34 if in same rows in column H contains data. But, sometimes all rows having data, sometimes only 2-5 random rows contains data.
I want only automatic numbering the rows who having data.
The is.
Nick
I hope i got you correct
in H10 =IF(ISTEXT(F10),1,"")
in H11 =IF(ISTEXT(F11),MAX($H$10:H10)+1,"")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
As long as F9 doesn't contain a number ( or contains zero), then you can use this formula in F10:
=IF(H10<>"",MAX(F$9:F9)+1,"")
then copy down into F11:F34.
Hope this helps.
Pete
So, thanks for your answers, but i've make a big mistake. I forgot to tell that all rows in column H contains formulas to give some sums and every time acording to the firstname data in column H not the same. So, the is formulas returns automatic numbering in any way.
Sory for my english..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks