Notifications
Clear all
Topic starter
How can I number Column E so that the numbering follows sequentially after the "Break".
The user determines the position of the "Break" in A6 and A8. Should the position of the "Break" shift, then the numbering should adjust accordingly.
Columns G / H are examples of the desired outcome.
How can this be achieved without VBA?
Posted : 26/09/2020 9:01 am
I think thiis has the right concept, might need tweaking if you want the break before or after the number
=IF(D2=$C$5,$A$5,IF(D2=$C$7,$A$7,COUNTIFS($D$2:D2,"<>"&$C$5,$D$2:D2,"<>"&$C$7)))
Posted : 26/09/2020 1:00 pm
