Prev: Vlookup in Excel 2003
Next: keeping values
From: BeckyB on 1 Apr 2010 17:01
I have various items in a spreadsheet. Some of these items are repeated in
various rows, but have a different text description for it. They all have the
same reference number, just a different description. I want to combine all
the descriptions into one cell. I am doing vlookup, but it is only putting in
the first occurance. Is there a way to combine all descriptions into one cell?

From: Pete_UK on 1 Apr 2010 20:53
Yes, I like to use COUNTIF to set up a sequential number for each
multiple of the unique reference.

However, your description of your data is a bit vague, so I can't
really recommend a particular formula for you. Can you supply some
details of how your data is laid out and what you want to do with it?

Pete

On Apr 1, 10:01 pm, BeckyB <Bec...(a)discussions.microsoft.com> wrote:
> I have various items in a spreadsheet. Some of these items are repeated in
> various rows, but have a different text description for it. They all have the
> same reference number, just a different description. I want to combine all
> the descriptions into one cell. I am doing vlookup, but it is only putting in
> the first occurance. Is there a way to combine all descriptions into one cell?

From: Aziz on 2 Apr 2010 05:12
Use the Option Concatenate for three cells to get unique ce name and that
should help

"BeckyB" wrote:

> I have various items in a spreadsheet. Some of these items are repeated in
> various rows, but have a different text description for it. They all have the
> same reference number, just a different description. I want to combine all
> the descriptions into one cell. I am doing vlookup, but it is only putting in
> the first occurance. Is there a way to combine all descriptions into one cell?
>
From: BeckyB on 2 Apr 2010 10:34
It's like this on another sheet within the same file. I am trying to pull it
from Sheet2 into Sheet1.

Reference # Description
123 Pant Set
123 2pc set
123 Shirt & Pants

I want it to appear in a cell like this: Pant Set 2pc set Shirt & Pants.

It really doesn't matter what order they go in. I just want all of them in
one spot.


"Pete_UK" wrote:

> Yes, I like to use COUNTIF to set up a sequential number for each
> multiple of the unique reference.
>
> However, your description of your data is a bit vague, so I can't
> really recommend a particular formula for you. Can you supply some
> details of how your data is laid out and what you want to do with it?
>
> Pete
>
> On Apr 1, 10:01 pm, BeckyB <Bec...(a)discussions.microsoft.com> wrote:
> > I have various items in a spreadsheet. Some of these items are repeated in
> > various rows, but have a different text description for it. They all have the
> > same reference number, just a different description. I want to combine all
> > the descriptions into one cell. I am doing vlookup, but it is only putting in
> > the first occurance. Is there a way to combine all descriptions into one cell?
>
> .
>
From: BeckyB on 2 Apr 2010 10:48
Thanks for replying. I did try that, but I am looking up a reference # on
another sheet and want all occurances of that reference number's description
to go into one cell on Sheet1.


"Aziz" wrote:

> Use the Option Concatenate for three cells to get unique ce name and that
> should help
>
> "BeckyB" wrote:
>
> > I have various items in a spreadsheet. Some of these items are repeated in
> > various rows, but have a different text description for it. They all have the
> > same reference number, just a different description. I want to combine all
> > the descriptions into one cell. I am doing vlookup, but it is only putting in
> > the first occurance. Is there a way to combine all descriptions into one cell?
> >
 | 
Pages: 1
Prev: Vlookup in Excel 2003
Next: keeping values