Hi
for the closest value in an unsorted list use the following array
formula (entered with CTRL+SHIFT+ENTER):
=INDEX(A1:A5,MATCH(MIN(ABS(A1:A5-C1)),ABS(A1:A5-C1),0))
--
Regards
Frank Kabel
Frankfurt, Germany
"Roccobarocco" schrieb im
Newsbeitrag ...
Hi
Does anyone know which function/formula to use to return a specific
value
from a range of cells? For example:
A B C D
1 10
2 20
3 30
4 20
5 22
6 ?
How do I make A6 return the first instance of 20 from range A1:A5?
If this is not clear, just let me know. All help greatly appreciated
|