Is there a way to create a list of all 'available' values in a column?

Hi all,

I have 10 columns which contain various symbols/value.

I have created a second column where I find the combinations of these 10 columns. I create this second column with the formula

= Column 1 & Column 2 & ... & Column 10.

Mathematically/theoretically, I assume there would be 10 x 8 10 = 800 possible combinations, but I don't think I have that many in actuality.

It looks like this:

1.png

Would it be possible to export this list somehow?

The reason is that I want to create a frequency diagram/count of all possible combinations.

I seem to recall doing this in the past with another set of data, but can't seem to recall how.

Thanks in advance.

Elijah

in L2
=IFERROR(INDEX(_C,MATCH(,INDEX(COUNTIF($l$1:l1,_C),),)),"")
_C is the name of a column with = Column 1 & Column 2 & ... & Column 10
and pull down

Hi, Tim,

Thank you!

Sadly, I was not able to get that to work. It only returns a blank. I tried removing the IFERROR and then it simply says #NAME or something like that on all cells.

Best regards.

Originally Posted by Jacc

https://www.get-digital-help.com/200...om-one-column/

Hi, Jacc

That worked out beautifully!

It was as easy as selecting Data --> Advanced Filter and then 'copy unique values'.

Ha en fin dag! : )

Elijah