Forum Discussion
Finding the next value in list - nothing to match off of
Hi Everyone, Bit of a tricky one but I'll do my best to explain my issue. I have a list starting at B1 to B26. B1 is "A-A", B2 is "A-B", B3 is "A-C" etc. all the way to "A-Z". In A1 I want t...
What about =B1 then drag down the formula till A26?
I wish it was that simple. My actual list is jumbled and not in order with duplicates.