Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Referring to the post in General Question
Does anyone have any suggestion on following case? There is a list of numbers under colume A 1813, 1748, 1652, 1415, 1361, 1169, 1129 945, 890, 765, 633, 604, 598, 525, 490 A range 300 is defined each number's upper and lower limit, such as the number 945, upper limit is 945 + 300 = 1245, lower limit is 945 - 300 = 645. Within the defined limits between 1245 and 645 for the number 945, which cross above the number 1169 & 1129 and cross below the number 890 & 765, this defined range for 945 covers 4 values within those upper and lower limits, then it returns the value 4 in colume B. I would like to perform this calculation for each number. Does anyone have any suggestion on how to do it in Excel? Thank you for any suggestion Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to find the number of value within a range? | Excel Discussion (Misc queries) | |||
How do I find total number workdays from a range of date | Excel Worksheet Functions | |||
Find a negative number in a range | Excel Worksheet Functions | |||
find the cell above any number in any range | Excel Worksheet Functions | |||
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions |