[Solved] Formula to return unique values from a column

[zivilyn99]

Hello,

I'm looking for a way to return a list of all the unique values from one column into another column.

So column A contains =
EGGS
EGGS
SAUSAGE
EGGS
BACON
BACON

Therefore column B returns =
EGGS
SAUSAGE
BACON

I've found a number of guides in Excel which show methods on how to do this (my preferred option being here- https://www.mrexcel.com/forum/excel-que ... -list.html - specifically post #8. I have this working in Excel but it doesn't seem to translate into OpenOffice.

Does anyone have any advice for how I can achieve this on OpenOffice Calc? It needs to be a formula, I can't use a filter.

Thanks and regards,

[JohnSUN-Pensioner]

What about Data - Filter - Standard Filter - More - No duplication?

(About formula what you are looking - see here)

[MrProgrammer]

I'm looking for a way to return a list of all the unique values from one column into another column. … Does anyone have any advice for how I can achieve this on OpenOffice Calc? It needs to be a formula, I can't use a filter.

I created this sample using the link in the previous post.

201708141411.ods

(7.96 KiB) Downloaded 2843 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

Edit: 2022-05-19: If you copy formulas from 201708141411.ods to your own spreadsheet, you must also copy the formulas in columns ZY and ZZ, since those columns are where important calculations are performed.

[zivilyn99]

All - thankyou for your inputs.

MrProgrammer - Many thanks for the example sheet. This satisfies my requirements perfectly.

Thanks and regards,