Prev: Variable Range of Values
Next: fill in date into adjacent cell automatically
From: BeckyB on 25 Mar 2010 15:35
I have various items in a spreadsheet. Some of these items are repeated in
another row, 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. Can I combine all occurances into one?
From: JB on 25 Mar 2010 15:55
UDF:

=rechtous(Value;RangeValue;RangeReturn)

Function RechTous(v, champRech As Range, ChampRetour As Range)
a = champRech
temp = ""
For i = 1 To champRech.Count
If a(i, 1) = v Then
temp = temp & ChampRetour(i) & " "
End If
Next i
RechTous = temp
End Function

http://boisgontierjacques.free.fr/fichiers/fonctionsperso/Fonction_RechercheTous.xls

JB


On 25 mar, 20:35, BeckyB <Bec...(a)discussions.microsoft.com> wrote:
> I have various items in a spreadsheet. Some of these items are repeated in
> another row, 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. Can I combine all occurances into one?

From: BeckyB on 26 Mar 2010 09:06
Thanks for your reply, but I have really no idea what the below is. Please
advise.


"JB" wrote:

> UDF:
>
> =rechtous(Value;RangeValue;RangeReturn)
>
> Function RechTous(v, champRech As Range, ChampRetour As Range)
> a = champRech
> temp = ""
> For i = 1 To champRech.Count
> If a(i, 1) = v Then
> temp = temp & ChampRetour(i) & " "
> End If
> Next i
> RechTous = temp
> End Function
>
> http://boisgontierjacques.free.fr/fichiers/fonctionsperso/Fonction_RechercheTous.xls
>
> JB
>
>
> On 25 mar, 20:35, BeckyB <Bec...(a)discussions.microsoft.com> wrote:
> > I have various items in a spreadsheet. Some of these items are repeated in
> > another row, 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. Can I combine all occurances into one?
>
> .
>
 | 
Pages: 1
Prev: Variable Range of Values
Next: fill in date into adjacent cell automatically