Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|