I have a set of data, which the value might be repeated and I am attempting to count and mark the counting in sequence.
I am currently trying to create a list using arrayformula (which is a must for my application for some reason), which the list will return the number of times the value is repeated, at the same time indicates the # of the occurrence of that row.
Some thing like the below is what i wish to acc
It is a must for me to use a arrayformula or something similar to achieve. Would appreciate any input. Thanks.