View Single Post
  #5   Report Post  
Bruno Campanini
 
Posts: n/a
Default

"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