use function <DMIN
see help
=======
"Bruno Campanini" wrote in message
...
"TheRobsterUK"
wrote in message
news:TheRobsterUK.1vztea_1127783101.6456@excelforu m-nospam.com...
Hi,
Suppose I have a worksheet with the following data:
(column1)......... (column2)
Savings..................I.D.
-243...................... 01
-205...................... 02
-165.......................03
-87.........................04
57..........................05
109........................06
205........................07
303........................08
[...]
Another one:
{=IF(COUNTIF(A3:A10,"0"),VLOOKUP(MIN(IF(A3:A100,
A3:A10)),A3:B10,2,0),"No positive number")}
FormulaArray
Bruno
|