Extracting only Unique Data From a list

[Hammey]

I have run into a bit of a snag working with a worksheet.

This worksheet is designed to fill in data into a printable form and allows the user to build upon the worksheet line by line.

What I need is a way to extract only the unique values in a column and to place the much shorter list in another column.




If possible it would be best to work as a formula instead of a macro due to the fluidity of the worksheet, I'm trying to keep the macros to a minimum if possible. I thought I had it working at one point using index/match functions but I must not have done it right since it didn't quite work as it should have.

Any help would be appreciated, thanks in advance.

[Dulanic]

Use advanced filter. Copy unique values only. Should work for what you need.

[Hammey]

I need to have this working in the background in real time, I'm trying to automate this as much as possible.

The data which is being extracted will end up being run through a concatenate to mesh it together.

[Dulanic]

Adjust range of A as needed. This is an array formula and will need to be entered with CTRL + SHIFT + ENTER

Start with B2...

=IF(ISERROR(INDEX(A1:A10,MATCH(0,COUNTIF($B$1:B1,A1:A10),0))),"",INDEX(A1:A10,MATCH(0,COUNTIF($B$1:B1,A1:A10),0)))

Be warned, array formulas can be slow. The more cells it needs to evaluate and the more cells that have this formula... the slower the sheet gets after every time a value is entered.