Forum Discussion
Add Row To Table and Changes Row Above Column Formula
Hello, From the screenshots you can see that I'm trying to add an instance counter that displays 1 if it's the first subs in the table, a 2 if its the second sub and so on. The problem I'm h...
As variant that could be
with
=IF([@Sub]="subs",COUNTIF($C$7:INDEX([Sub],ROW()-ROW(Table1[[#Headers],[ID]]),1),"subs"),"")
SergeiBaklan I tweaked it to fit in my table, but that worked perfectly. Thanks
AndrewDavis , you are welcome