Formula works in Excel 2013, but not in Excel 2016

I am not getting an error using this in Excel 2019. I suspect there is something else going on in your sheet, like the contents of the cells you are referencing indirectly. Difficult to say without seeing your file. And the error is almost certainly due to something else that changed besides just the upgrade to 2016. Built-in names are generally backward compatible.

ETR: brain fart

That formula works for me.

But try this alternative in D6 then move it to the cell you need it in. Fill down or fill right

=IF(INDIRECT($E6)=INDIRECT($E5),INDIRECT($D5)+1,1)

Make sure that your data is in column A starting at A2

Open the name manager
Create a new name "List" and in ther erefers to box use this formula =INDIRECT("A2:A" & MATCH(9^99,Sheet1!$A:$A))

Enter this formula in B2 using Ctrl Shift Enter =IFERROR(INDEX(List,MATCH(0,COUNTIF($B$1:B1,List),0)),"")

Enter this formula in C2 using enter =IF(B3="","",COUNTIF(A:A,B3))


Select B2 and C2 and fill down until all you get are blanks.