View Single Post
  #1   Report Post  
analarana analarana is offline
Junior Member
 
Posts: 1
Default the cells that some rows have in common

Hi,
I know nothing about access, and I don't even know if excel is the right program for what i need.
Could someone please tell me how I can find the cells that some rows have in common? I need to do this lots of times with lots of names, but this is a small example:
https://www.dropbox.com/s/ylqs36s0nmvbvx4/excel2.jpg
So for example, the first time I need to know the numbers that Ana (row 1), Laura (row2) and Manuel (row3) have in common, so the computer should give me nš17 as the answer. If I ask for the numbers (or cells) Chris (row 4)and Eddie (row 5) have in common, the computer should say nš2, nš3 and nš4. I'm not looking for the number that appears more times in the grid, but for the one that the rows I select have in common.
Cheers.

Last edited by analarana : June 10th 13 at 06:49 PM