View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJ44 JJ44 is offline
external usenet poster
 
Posts: 2
Default Matching 2 columns

I have 6 columns of data. 2 of the columns are called ID and there are
thousuands of id numbers in both columns, but currently do not match up. I
want both id columns to have the same id in a row. So for example row 2
should have id#6 in column A and its information related to it in B & C as
well as Column D having id#6 and the 2 columns associatd with that id (as
well as the other information that those ids were associated with).
How do I go about doing this?

Thanks,
~JJ44