View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C. C. is offline
external usenet poster
 
Posts: 14
Default Match and combine multiple rows into one

Hi all,

I have the data set below in three separate columns in one worksheet

A3 B3 C3
10 71 120171
10 71 43311
10 71 43312
10 72 101321
10 72 10372
1 421 42101
1 421 42102

I want the data to just match and return the first two rows and
combine it into one cell in another worksheet so it would look like
this (with the dash):

A3
10-71
10-72
1-421


Thanks!

Cheers,
Chris