Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Out of 12 cells in a row, I want farthest right
A1:A13 is January-December and Total. B1:B13 is the GOAL numbers. C1:C13
are the ACTUAL numbers. The numbers entered in the cells of row C are aggregates (they include the amount of the previous months). I want C13 to be the last number entered in that row (which will also be the last month in which an actual was entered). Is there any formula that looks at those 12 cells and takes the farthest to the right? |
#2
|
|||
|
|||
=LOOKUP(9.99999999999999E+307,A:A) for last numeric entry in a column
=LOOKUP(9.99999999999999E+307,1:1) for last numeric entry in a row =LOOKUP(REPT("z",255),A:A) for last text entry in a column =LOOKUP(REPT("z",255),1:1) for last text entry in a row -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Carpie" wrote in message ... A1:A13 is January-December and Total. B1:B13 is the GOAL numbers. C1:C13 are the ACTUAL numbers. The numbers entered in the cells of row C are aggregates (they include the amount of the previous months). I want C13 to be the last number entered in that row (which will also be the last month in which an actual was entered). Is there any formula that looks at those 12 cells and takes the farthest to the right? |
#3
|
|||
|
|||
If I understand Lookup right, it is going to take the highest number closest
to what you provide. So by providing an outrageously large number, it will take the highest number it finds. In this specific example I think it will work for me, but I have other spreadsheets where the monthly value may be negative so the cumulative value actually decreases. In this example the lookup formula provided wouldn't work because it would return the month before (because of the negative value) since it was the greater of the two. What would I do in this case? "Carpie" wrote: A1:A13 is January-December and Total. B1:B13 is the GOAL numbers. C1:C13 are the ACTUAL numbers. The numbers entered in the cells of row C are aggregates (they include the amount of the previous months). I want C13 to be the last number entered in that row (which will also be the last month in which an actual was entered). Is there any formula that looks at those 12 cells and takes the farthest to the right? |
#4
|
|||
|
|||
<"What would I do in this case?"
You would at least try it Maybe you'll like it. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Carpie" wrote in message ... If I understand Lookup right, it is going to take the highest number closest to what you provide. So by providing an outrageously large number, it will take the highest number it finds. In this specific example I think it will work for me, but I have other spreadsheets where the monthly value may be negative so the cumulative value actually decreases. In this example the lookup formula provided wouldn't work because it would return the month before (because of the negative value) since it was the greater of the two. What would I do in this case? "Carpie" wrote: A1:A13 is January-December and Total. B1:B13 is the GOAL numbers. C1:C13 are the ACTUAL numbers. The numbers entered in the cells of row C are aggregates (they include the amount of the previous months). I want C13 to be the last number entered in that row (which will also be the last month in which an actual was entered). Is there any formula that looks at those 12 cells and takes the farthest to the right? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |