Hi,
I would like to know the formula to continue the serial after every unique values.
1 self
2 spouse
3 child
4 father
1 self
2 spouse
3 father
1 self
2 spouse
3 child
Hi,
I would like to know the formula to continue the serial after every unique values.
1 self
2 spouse
3 child
4 father
1 self
2 spouse
3 father
1 self
2 spouse
3 child
Not sure I follow. Would you simply like the numbering to start over every time "self" is entered?
If so, in A1, put 1, then in A2 and copied down, =IF(B2="self",1,IF(B2="","",A1+1)). If this is not what you want, could you please clarify?
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks