In this post I shall present a method for generating a unique, alphabetical list in a single column from data contained within a contiguous range comprising several columns.
For example, given the dataset below in A2:E5, we will return that list beginning in cell G1:
Given the list below in A1:A10, we may wish to create a list of unique, single words from that list, as per column B here.
We can do this with the following set-up: More…
Last week I set readers the challenge which can be found here.
This one turns out to be a good deal more complex than it at first appears, and so perhaps not surprisingly no correct results were received..
GreasySpot at first thought that Advanced Filter would be a viable solution, but quickly realised that it wasn’t actually appropriate here. Besides, as I mentioned, the idea of this (and of all these challenges in fact) is to try to achieve the results using worksheet formulas alone.
So how can we achieve our desired results?
EXCELXOR 