Hi,
I have partially solved a problem by finding the nearest value in a range (A2:A28) of another value (in cell C1) by using the following formula:
{=INDEX($A$2:$A$28,MATCH(MIN(ABS($A$2:$A$28$C$1)),ABS($A$2:$A$28$C$1),0))}
The part I am having trouble with to find the nearest value in a range (A2:A28) to the number in cell C1, if it is within +/ 3 of C1.
Can anyone help please? See attached file.
Regards
GB
I have partially solved a problem by finding the nearest value in a range (A2:A28) of another value (in cell C1) by using the following formula:
{=INDEX($A$2:$A$28,MATCH(MIN(ABS($A$2:$A$28$C$1)),ABS($A$2:$A$28$C$1),0))}
The part I am having trouble with to find the nearest value in a range (A2:A28) to the number in cell C1, if it is within +/ 3 of C1.
Can anyone help please? See attached file.
Regards
GB
Attachments

10.5 KB Views: 8