Forum Discussion
compare 4 columns and insert unique values under 1st column
Hello,
I want to:
1. Compare columns to the 1st column and find unique values in each column
2. Add unique values under column 1
3. Highlight added values
Please advise how I can do it? Conditional formatting it's the easiest way but when I try sort by color it sorts only highlighted cells from the chosen column.
2 Replies
It depends on which Excel version you are. In general with formulae you may create new column which has values from first column and unique values from other columns. Again, depends on Excel version.
If to expand existing (1st one) column that's VBA or Office Script programming.
- Hi, Is not totally clear points 1 and 2. Could you please provide an example?
