Countif to create sequence number
I hopoing to use this formula as a column formula (to auto fill as rows are added), but if using absolute references it can not be used as a column formula.
Does anyone have any work arounds?
=COUNTIF($[TW Job number]$1:[TW Job number]@row, [TW Job number]@row)
Help Article Resources
Check out the Formula Handbook template!