Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert the value of a cell in a colum that is bigger of an preestablished value
I mean If I have this column 12 23 34 45 56 76 98 and an specific cell value is 50, I'd like to compare these value with the values of all the column and choose the next one, in these case it would be 56, If the value of that cell were 15 then I'd like to introduce 23 in another specific cell, how can I do that? thanks -- mogly69 ------------------------------------------------------------------------ mogly69's Profile: http://www.excelforum.com/member.php...o&userid=37000 View this thread: http://www.excelforum.com/showthread...hreadid=567225 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert the value of a cell in a colum that is bigger of an preestablished value
=INDIRECT("A"&MATCH(50,A1:A7,1)+1)
HTH Die_Another_Day mogly69 wrote: I mean If I have this column 12 23 34 45 56 76 98 and an specific cell value is 50, I'd like to compare these value with the values of all the column and choose the next one, in these case it would be 56, If the value of that cell were 15 then I'd like to introduce 23 in another specific cell, how can I do that? thanks -- mogly69 ------------------------------------------------------------------------ mogly69's Profile: http://www.excelforum.com/member.php...o&userid=37000 View this thread: http://www.excelforum.com/showthread...hreadid=567225 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the default insert comment bigger? | Excel Worksheet Functions | |||
Look up a value in one colum and insert the value found in the adj | New Users to Excel | |||
Insert new colum, without changing information | Excel Worksheet Functions | |||
Excel 2000 (9.0.6926 SP3) spreadsheet getting bigger & bigger .... | Excel Discussion (Misc queries) | |||
Insert colum with 0's | Excel Programming |