Prev: Earliest time in a range
Next: Can a formula be "built" referencing text content from another cel
From: minyeh on 11 Mar 2010 00:19 On Mar 10, 4:09 am, EllenM <Ell...(a)discussions.microsoft.com> wrote: > Hello, > I have a data set that looks like this: > Sortterm Doc # Main Term CAS # CFR REG # > DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.105 > DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.300 > DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.380 > DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.390 > DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 176.170 > > I'd like to concatentate the last column with the unique values to look like > this: > Sorterm DocNum Mainterm CAS Regnum > DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.105<br > />175.300<br />175.380<br />175.390<br />176.170 > Thanks in advance, > Ellen why don't u just use a pivot table? it would be easier and it hide duplicate value. another way would be to show all the value and hide the duplicates using a formula like AA2=IF(A2=A1,"",A2) for all the columns u want to hide duplicate value (input in A2:E100, output in AA2:AE100)
First
|
Prev
|
Pages: 1 2 3 Prev: Earliest time in a range Next: Can a formula be "built" referencing text content from another cel |