Help with Code

[Jim May]

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

 

[Bob Phillips]

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)