| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
matching data
Hello,
I have two columns of numbers. The first col contains 48 48 62 24 The second column contains 48 50 62 I want to see how "close the 2th column is to the first column. Since I can match the single occurence of 48 and 62 in the 2th column with a single occurence of 48 and 62 in the first column. I want the result to be 2. Any suggestions for a formula to achieve this result would be greatly appreciated. thanks Ron |
|
#2
|
|||
|
|||
|
Try...
=SUMPRODUCT(--(COUNTIF(A1:A4,B1:B3)0)) Hope this helps! In article , Ron wrote: Hello, I have two columns of numbers. The first col contains 48 48 62 24 The second column contains 48 50 62 I want to see how "close the 2th column is to the first column. Since I can match the single occurence of 48 and 62 in the 2th column with a single occurence of 48 and 62 in the first column. I want the result to be 2. Any suggestions for a formula to achieve this result would be greatly appreciated. thanks Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
| Matching data using date criteria... | Excel Worksheet Functions | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Matching data in one column to another | Excel Worksheet Functions | |||
Linear Mode
