LinkBack URL
About LinkBacks
Hi
I am looking for a formula to do incremental numbering at variable intervals in column A based on data in Column B.Please find attached file as a sample. thanks
Hi
I am looking for a formula to do incremental numbering at variable intervals in column A based on data in Column B.Please find attached file as a sample. thanks
Last edited by tek9step; 03-18-2011 at 08:35 AM.
How about?
=COUNT($C$1:$C2) copied down
Last edited by NBVC; 03-18-2011 at 08:36 AM. Reason: made column C absolute in C2
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Re: Incremental numbering at variable intervals of rows
brilliant Thanks NBVC)
Another reading of the requirement, but less likely to be the one you are after, NBVC has provided that.
=IF(COUNTBLANK(B2:C2)=0,1,A1+1)
Drag/Fill Down.
Last edited by Marcol; 03-18-2011 at 08:54 AM. Reason: Apologies for spelling your handle incorrectly NBVC.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thank you Marcol that works great too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks