How to collect unique value from Excel

Asked By 0 points N/A Posted on -
qa-featured

I have an Excel worksheet. I want to separate only unique value from that Excel worksheet. I need only formula not macro or other thing. As for example, I have 6 values in column A. I need to collect unique value from A1 to column B.

Anyone familiar with this? If possible, please help me.

SHARE
Best Answer by seamus
Best Answer
Best Answer
Answered By 0 points N/A #115630

How to collect unique value from Excel

qa-featured

Yes, it is very easy to collect unique data. There are several ways which I will describe below.

  1. First of all, select the cell from which you want the data.
  2. Double click on the cell and then select the part of data you want to copy.
  3. If you want to copy the whole cell then click and hold the lower right corner of the cell and drag the cell to b1. This will copy the contents of A1 into B1. Note that dates and number will increment themselves when you do this.
  4. Another way is to select the cell and press CTRL+C. It will copy the contents of the cell. Now select the cell where you want to copy the data and press CTRL+V to paste the selected data.

Hope this helps.

Answered By 0 points N/A #115631

How to collect unique value from Excel

qa-featured
  1. Select cell B1.
  2. Write the following formula:
  3.  =IF(COUNTIF(A:A,A1)=1,A1,"")

Login/Register to Answer

Related Questions