Help with Code
 

I have a formula in Col G (=IF($F$1:$F$15<"",C1,"")
that is currenlty producing:

I'd like to concatenate the 3 text items in Col G in abc order according to
Col F.
Can that be done?
F G
1 a 1234-5678(2)H




6 c 502/6-8500





12 b 9876

Help with Code
 

Do you mean

=INDEXG1:G6,MATCH("a",F1:F6,0))&INDEXG1:G6,MATCH(" b",F1:F6,0))&INDEXG1:G6,MATCH("c",F1:F6,0))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jim May" wrote in message
...
I have a formula in Col G (=IF($F$1:$F$15<"",C1,"")
that is currenlty producing:

I'd like to concatenate the 3 text items in Col G in abc order according
to
Col F.
Can that be done?
F G
1 a 1234-5678(2)H




6 c 502/6-8500





12 b 9876