Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Needed! Please Help!
Hello,
I am trying to create an equation that would automatically pick up the last known data point in a range. For example, I have all the months starting from Row 3 Column C, and in Row 3 Column 1, I need to create a function that would pick up the most recent data point and place it in that cell, C1. So, if there was something in March, it would replace February, if there was something in July, it would replace June in C1. Please help. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Needed! Please Help!
Rashid I can't help because I don't understand what you want. Could you rewrite your question with more specifics, including which cells hold the various months, what you mean by the latest known data point, how Row 3 Column 1 (i.e.cell A3) relates to the data, what you mean by "if there was something in March" (what is this "something" and where is it stored?), etc. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=534007 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Needed! Please Help!
Suppose A1 is my final value cell, and B1 - M1 are values for each month from
Jan -Dec. When I input something in B1 (Jan), it should show up in A1, then if I input something in C1 (Feb), it deletes the value in A1 and updates it with the value in C1 and so on. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Needed! Please Help!
One way ..
Put in A1's formula bar, then array-enter the formula (press CTRL+SHIFT+ENTER): =INDEX($B1:$IV1,MATCH(TRUE,$B1:$IV1="",0)-1) Copy A1 down as required to return correspondingly for rows2, 3, ... -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rashid" wrote in message ... Suppose A1 is my final value cell, and B1 - M1 are values for each month from Jan -Dec. When I input something in B1 (Jan), it should show up in A1, then if I input something in C1 (Feb), it deletes the value in A1 and updates it with the value in C1 and so on. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed with function | Excel Worksheet Functions | |||
DAverage Function help needed | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions | |||
function needed | Excel Worksheet Functions | |||
IF function help needed | Excel Worksheet Functions |