LinkBack URL
About LinkBacks
i need a formula to count and restart counting when other element comes
example
1 1 1 2 2 2 2 2 1 2 1 1 1 1 1
1 2 3 1 2 3 4 5 1 1 1 2 3 4 5
if first 1 is at A1 which is the formula at A2?
i need a formula to count and restart counting when other element comes
example
1 1 1 2 2 2 2 2 1 2 1 1 1 1 1
1 2 3 1 2 3 4 5 1 1 1 2 3 4 5
if first 1 is at A1 which is the formula at A2?
Try this in D7 and copy across;
Formula:
Please Login or Register to view this content.
In D7 then dragged across.
=IF(D5=C5,C7+1,1)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks