Re: New Column With Unique Values From Adjacent Column
royUK and jindon,
Thank you for the responses.
First I did not quite specify exactly how I wanted to perform the intended task. First I want the task to be automated. So based on input values it looks through the list of values and determines the first instance of each non-repeating value. The next step is it takes the first instance of each non-repeating value and copies to a new cell in an adjacent column.
I would like to perform this process without the use of code and only using formulas, if that is possible. If it is not possible without code, how exactly to I get the code to execute when a cell value (input cell) is changed within a set of cells. Note the input cells are not adjacent to one another.
Any further assistance is much appreciated.