Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matching Values of 1 row vs all other rows.
Hi!
I am using Excel 2010 and fairly new to the whole software. My problem is the following: 1) Data presentation _____ |Criteria1|Criteria2| Name1| Name2| Where each row contains only zeros and ones for each criteria met. I also made use of the "table" functionality to be able to sort and 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 row to the other. Any help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare two files and merge rows base on a matching word within thesetwo rows | Excel Programming | |||
Find matching values, copy/paste values as well as values in ColA | Excel Programming | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Matching rows in 2 sheets and copying matching rows from sheet 1 t | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming |