the cells that some rows have in common
Hi,
I know nothing about excel, 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.
| Attachment | Size |
|---|---|
| common number.xlsx | 12.48 KB |
- analarana's blog
- Login or register to post comments
- 2706 reads
.
.
link
this is the same link in dropbox:
https://www.dropbox.com/s/ylqs36s0nmvbvx4/excel2.jpg
I have added a pivot table
I have added a pivot table solution to your problem
here's how it works:
1. structure your data like this:
2. in the dropdown on the pivot sheet, select the people you want to compare.. Common numbers will be in green.
3. If you add data to the end of the data sheet, just right click on the pivot table, and choose refresh.
Nick
Thank you!
Thanks a lot for that!
It's exactly what I was looking for. I was going crazy because I have no idea how to do that. You've saved me a lot of time (I have to work with hundreds of names and thousends of numbers).
Cheers,
Ana