Forum Discussion
Combining Columns, Removing Duplicates, Sorting
Hello - I'm trying to combine two columns of data into one using a formula, showing only unique values and preferably sorting from smallest to largest.
I know this can be achieved outside of a formula using excels functions, but wanted to know if something more agile exists to support? Thank you for any help or guidance!
Below example of data (output being the desired result):
- Sadly this doesn't work. It works perfectly for excel online once embed. However once I open the file via the desktop app- it breaks the link.
Which version of Excel do you have on the desktop?
