J
Julz
Here's my data:
A B C D E
F G
George Jones Pro Deb Smith Am 153
Jack Thomas Pro Wendy Jones Am 154
Columns A & B are names of the pro dance partner.....D & E are amateur
partner....G is the comp number.
Need the output to read as follows in a report:
George Jones (P) and Deb Smith (A) #153
Jack Thomas (P) and Wendy Jones (A) #154
Thought I could use SUMPRODUCT, but can't get it to work....
Any thoughts? Thanks so much in advance!
A B C D E
F G
George Jones Pro Deb Smith Am 153
Jack Thomas Pro Wendy Jones Am 154
Columns A & B are names of the pro dance partner.....D & E are amateur
partner....G is the comp number.
Need the output to read as follows in a report:
George Jones (P) and Deb Smith (A) #153
Jack Thomas (P) and Wendy Jones (A) #154
Thought I could use SUMPRODUCT, but can't get it to work....
Any thoughts? Thanks so much in advance!