How to look for value?
 

Refering to the post in General Question

A1 = [NIL] B1 = [NIL]
A2 = 18-Jan-07 B2 = 1
A3 = [NIL] B3 = [NIL]
A4 = 20-Jan-07 B4 = 1
A5 = 24-Jan-07 B5 = -1
A6 = [NIL] B6 = [NIL]
A7 = 26-Jan-07 B7 = 1
A8 = [NIL] B8 = [NIL]
A9 = 28-Jan-07 B9 = -1

I would like to look for the smallest value in A:A colume, in this case
18-Jan-07 in cell A2, then return the value of 1 in cell B2 based on the same
row and put it into cell C1.

I would like to look for the second smallest value in A:A colume, in this
case 20-Jan-07 in cell A4, then return the value of 1 in cell B4 based on the
same row and put it into cell C2.

Does anyone have any suggestion?
Thank you in advance
Eric

How to look for value?
 

See one answer at your post in microsoft.public.excel.misc

Generally, you'd do better to post to a single newsgroup, so that any
answers aren't fragmented.

In article ,
Eric wrote:

Refering to the post in General Question

A1 = [NIL] B1 = [NIL]
A2 = 18-Jan-07 B2 = 1
A3 = [NIL] B3 = [NIL]
A4 = 20-Jan-07 B4 = 1
A5 = 24-Jan-07 B5 = -1
A6 = [NIL] B6 = [NIL]
A7 = 26-Jan-07 B7 = 1
A8 = [NIL] B8 = [NIL]
A9 = 28-Jan-07 B9 = -1

I would like to look for the smallest value in A:A colume, in this case
18-Jan-07 in cell A2, then return the value of 1 in cell B2 based on the same
row and put it into cell C1.

I would like to look for the second smallest value in A:A colume, in this
case 20-Jan-07 in cell A4, then return the value of 1 in cell B4 based on the
same row and put it into cell C2.

Does anyone have any suggestion?
Thank you in advance
Eric