| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare rows for a match and sum the matches
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare rows for a match and sum the matches
Bert wrote:
How do I compare numbers say d101:l101 with c17:k17 and count the number of matches between the 2 ranges? Array-formula (commit with CTRL+SHIFT+ENTER): =SUM(--(C17:K17=TRANSPOSE(D101:L101))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two files and find records without matches | Excel Worksheet Functions | |||
| Compare lists and highlight matches | Excel Discussion (Misc queries) | |||
| Compare lists and highlight matches | Excel Discussion (Misc queries) | |||
| Compare columns, count matches | Excel Worksheet Functions | |||
| I need to compare to columns and indicate the matches in another | New Users to Excel | |||
Linear Mode
