Matching Values of 1 row vs all other rows.

R

rotegirte

Hi!

I am using Excel 2010 and fairly new to the whole software. My proble
is the following:

1) Data presentation

_____ |Criteria1|Criteria2|
Name1|
Name2|

Where each row contains only zeros and ones for each criteria met.
also made use of the "table" functionality to be able to sort an
filter.

2) Task

I want to create a new table

______|Name1|Name2|
Name1 |
Name2 |

Where each cell contains the total number of matching cells of one ro
to the other.

Any help would be appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find a number in a column then return a value from another cell 2
select max value from row of data and column containing max value 2
I want to count No .of same names in work sheet 1
Compare Names in a column and create single list with adjacent vla 6
Formula for summing purchases and sales 8
Query for random values multiple records 9
Macro to copy data X number of times into a column 0
Search other sheets for numbers & color them 10

Top