formula or code for unique values

[stephme55]

Hello. I have a list of customer ID's in column 1 and then 3 columns of values for each ID. Can I write code that only includes the first instance of each customer ID? So, you'd be adding three columns with values and blank rows for duplicates. Code or formulas are fine. Thanks!!

[pjwhitfield]

assuming columns A-D
in B2 use the formula
=IF($A2 = $A1,"",B2)

copy that across the 3 columns and then drag it all down.

[stephme55]

I don't think that works. Spreadsheet example attached. Thanks.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[stephme55]

@pjwhitfield. I think that works actually, if you sort so that values are grouped together.

[pjwhitfield]

@pjwhitfield. I think that works actually, if you sort so that values are grouped together.

Apologies yes, I forgot to mention that fact!

[stephme55]

@John. Thanks for your code. I didn't quite understand what it was doing though. I ran it on my spreadsheet and it deleted all values except for 1 in column A. Can you walk me through what each snippet is doing? Thanks.

[Crooza]

Stephme55,

If you just want a formula that isn't reliant on your data being sorted try this.

Please Login or Register  to view this content.