First two column selected compare both column any unique value find in second column that value only copy and paste below of second column and no need first column unique value, First three column selected compare those three column any unique value find in third column that value copy and paste below of third column and no need first and second column unique value, and so on....
Answers
It seems like you want to find unique values in specific columns of your table and paste them below those columns. You can achieve this using Excel formulas. Here's a step-by-step guide to accomplish this:
-
Find Unique Values in the Second Column and Paste Below:
- Assuming your data starts from cell A1, you can use the formula
=UNIQUE(B:B)
in cell D1 to find unique values from column B and paste them below column B.
- Assuming your data starts from cell A1, you can use the formula
-
Find Unique Values in the Third Column and Paste Below:
- Assuming your data starts from cell A1, and you have already pasted unique values below column B, you can use the formula
=UNIQUE(C:C)
in cell E1 to find unique values from column C and paste them below column C.
- Assuming your data starts from cell A1, and you have already pasted unique values below column B, you can use the formula
-
Repeat for More Columns:
- You can repeat the process for additional columns by adjusting the column references in the
UNIQUE
formula.
- You can repeat the process for additional columns by adjusting the column references in the
Here's a breakdown of the process for finding unique values in columns B and C:
-
For Unique Values in Column B:
- In cell D1, enter the formula
=UNIQUE(B:B)
. - This formula will find unique values from column B and paste them starting from cell D2.
- In cell D1, enter the formula
-
For Unique Values in Column C:
- In cell E1, enter the formula
=UNIQUE(C:C)
. - This formula will find unique values from column C and paste them starting from cell E2.
- In cell E1, enter the formula
You can continue this pattern for additional columns by adjusting the formula accordingly.
Once you have entered the formulas, Excel will automatically update the unique values whenever there are changes in the source data. This way, you'll always have the latest unique values below each respective column.