PDA

View Full Version : cells that some rows have in common



analarana
06-04-2013, 09:00 AM
Hi,
I know nothing about excel, and I don't even know if excel is the right program for what i need.
I've made a big spreadsheet so that I can find formation in it. Could someone please tell me how I can find the cells that some rows have in common? For example: row 1 has the cells 1 (Ana) and 2 (Chris), row 2 Laura, Ana and Tamara, and row 3 has the cells Martha and Ana. How can I get Ana (the cell in common) to be the result?

patel
06-04-2013, 11:47 AM
attach a sample file with data and desired result