the cells that some rows have in common

[analarana]

Hi
I know nothing about access, and I don't even know if excel is the righ
program for what i need
Could someone please tell me how I can find the cells that some row
have in common? I need to do this lots of times with lots of names, bu
this is a small example
https://www.rapidshare.com/#myrs_filemanager/file/707
So for example, the first time I need to know the numbers that Ana (ro
1), Laura (row2) and Manuel (row3) have in common, so the compute
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 sa
nº2, nº3 and nº4. I'm not looking for the number that appears more time
in the grid, but for the one that the rows I select have in common
Cheers

 

[Claus Busch]

Hi,

Am Mon, 10 Jun 2013 17:49:33 +0100 schrieb analarana:

this is a small example:
https://www.rapidshare.com/#myrs_filemanager/file/7079

there is an error with your link. Please check it.


Regards
Claus Busch