CODEWITHSUNDEEP
excel-2010
Hats
Hats

Reputation: 25

how to create "" for a column containging duplicate values

So I have a worksheet with multiple columns and one of the columns contains description of the product.

I have multiple lines of apples and multiple lines or orange.

enter image description here

Is there a forumla that can display only one cell with the product description with apples, oranges, and leave rest of the duplicates blank ("").

enter image description here

Upvotes: 0

Views: 242

Answers (1)

tigeravatar
tigeravatar

Reputation: 26640

I wouldn't really recommend using blanks there. Your original data setup is perfect for a flat file and makes performing calculations like Countif/s, Sumif/s, etc really easy.

If you absolutely must change it, you could use column E as a helper with this formula starting in cell E2 and copied down (note, this formula requires that the data be sorted by Product as shown in your example):

=IF(B2=B1,"",B2)

Then copy the helper column -> select B2 -> right-click -> paste special -> values

And delete the helper column.

Upvotes: 1

Related Questions