Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine if a value in a range is close to the value of another c
Hi!
Is there a way to determine if there is a number in a range of values that is closest in value to another number? I have a column of numbers that I have used to calculate an average, but now I want to find out which of those numbers is closest to the average. Thanks! -- Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a worksheet name from a range | Excel Worksheet Functions | |||
Determine if Cell Address is within a Range | Excel Worksheet Functions | |||
Data Validation range | Excel Discussion (Misc queries) | |||
Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
Range of dates determine days | Excel Worksheet Functions |