Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Re-post from General Questions
Does anyone have any suggestion on how to count the matched values? There is a list of values under column A & B [Column A] 1,5,6,8,9,10,3,20 [Column B] 6,4,9 I would like to count the number of matched value on column B between both columns, but I would like to set an range [+/- 1] for each values in column B. The set value 1 is inputed in cell D1. Such as 4 will not be found in column A, but after the range applied to value 4 in column B, if any number is found in column A between 3 [4-1] and 5 [4+1], then it should belong to matched value for column B. The matched values are 6, 4 and 9 in column B, and it will return 3 in cell C1. Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count the matched values? | Excel Discussion (Misc queries) | |||
Matching numbers in an Array and returning values for matched numb | Excel Discussion (Misc queries) | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |