Thread: match data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Le
 
Posts: n/a
Default match data

I need help asap?
I want to match information in four columns
ex
name test1 name test2
tina 86 mark 75
mark 80 tina 85
jim 45 jane 86
jake 51
mary 95
Not every one who took test1 took test2. I want to have the test1 and test2
grades for the students across the same row for those who took both test