Hi all! Was so happy with my result here yesterday, here's another one!
Below, I have a list of numbers. Some occur once, twice etc... In Column B I want to insert a formula which identifies the value in A as 1) the first occurrence 2) the last occurrence 3) a middle occurrence or 4) the only occurrence. I've drafted the desired output in red for this example. Any idea what formula combination I could use?
Below, I have a list of numbers. Some occur once, twice etc... In Column B I want to insert a formula which identifies the value in A as 1) the first occurrence 2) the last occurrence 3) a middle occurrence or 4) the only occurrence. I've drafted the desired output in red for this example. Any idea what formula combination I could use?