I am trying to write a formula that only uses a single column to looks at the column to the left and creates the string plus the number of occurrences. The attached spread sheet makes it easier to understand. Thanks for any help.
I am trying to write a formula that only uses a single column to looks at the column to the left and creates the string plus the number of occurrences. The attached spread sheet makes it easier to understand. Thanks for any help.
Last edited by BRISBANEBOB; 09-15-2016 at 12:02 AM.
e f g 5a a1 f5: =e5 & countif(e$5:e5, e5) 6b b1 7c c1 8d d1 9a a2 10b b2 11d d2 12a a3 13d d3
Entia non sunt multiplicanda sine necessitate
Thank you - can't believe everything I tried fell in a heap.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks