Hello all. I have the following formula:
That formula is pasted in cell E4, and copied down to E1003. I want to replace that with a single array formula in E4. I'm having issues doing it; either the counter won't increment at all or I get circular dependencies. Can anyone assist?
Thanks in advance!
Excel Formula:
=mid($C4,16,2)&"."&text(((countif(E$3:E3,mid(mid($C4,16,2)&".",1,FIND("@",SUBSTITUTE(mid($C4,16,2)&".",".","@",LEN(mid($C4,16,2)&".")-LEN(SUBSTITUTE(mid($C4,16,2)&".",".",""))),1))&"*"))*10)+10,"0000")
Thanks in advance!