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? Conditi...
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.