How to collect unique value from Excel

Asked By jameskerlin 0 points N/A Posted on - 08/16/2011

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.

• Status: Open
• Question Views: 1163
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by seamus

Go To Solution

Best Answer

Best Answer

Answered By seamus 0 points N/A #115630

How to collect unique value from Excel

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.

About seamus

Questions
2

Answers
13

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 08/16/2011
• Question Category: MS Excel

Answered By zicooo82 0 points N/A #115631

How to collect unique value from Excel

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

About zicooo82

Questions
0

Answers
11

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/17/2011
• Question Category: MS Excel