Extract the unique data from column B:B in to Column F:F or one sheet to another.

[abuharvey]

I have a drawing data base in sheet1, col A:A is SLNO. Col B:B Drawing number Col C:C Drawing Description Col D:D Received Date, many drawings will revise many times. I want unique list of received drawings list in another column automatically when it is added in to A:D

 

[FormR]

Hi, you can try like this.

=UNIQUE(Sheet1!B:.B)

 

[abuharvey]

Hi, you can try like this.

=UNIQUE(Sheet1!B:.B)

I'm using 2007 Ver

 

[kvsrinivasamurthy]

Pl upload a sample data with expected result in XL2BB format.

 

[Peter_SSs]

I'm using 2007 Ver

Does that mean you need to change your profile information?

If not, then in future if you need a solution for a version different to what is shown in your profile, you need to clearly state that in your first post so helpers don't waste their time on a solution that will be no good.