Extract unique data from multiple columns

[gak67]

I have data in 3 columns and I am wanting to extract the unique values. The values can change depending on other cells and I want the list of unique values to update as the data changes.

I have provided a simplified model sheet, although the data in it is static.

[humdingaling]

what is your expected outcome?

[gak67]

See updated attached file, with expected outcome included.

Cheers

[FDibbins]

Based on your sample file, try this ARRAY formula, courtesy of member benishiro and Link given by Pete_UK
http://www.get-digital-help.com/2009...rray-formulas/
......
=INDEX($B$2:$D$27,MIN(IF(COUNTIF(G$1:G1,$B$2:$D$27)=0,ROW($B$2:$D$27)-ROW($B$2)+1)),MATCH(0,COUNTIF(G$1:G1,INDEX($B$2:$D$27,MIN(IF(COUNTIF(G$1:G1,$B$2:$D$27)=0,ROW($B$2:$D$27)-ROW($B$2)+1)),)),0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

edit: This is based on your sample data starting in row 2

[FlameRetired]

Another way. Start with this helper column in F1 filled down until you get blanks.

Please Login or Register  to view this content.

Then in G1 array-enter this formula and fill down until you get blanks.

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Does this do what you want?

[FDibbins]

gak67 thanks for the rep point

However, you also commented that it did not quite work? As I mentioned in my edit, I started in row 2. When I adjusted the formula to start in row 1, it picked up the exact same answer as you did - just not sorted in any order