Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the last value in a range of cells
Hi everyone.
I was wondering what function in Excel can be used to return the last value in a range of cells. Specifically - Row 10 has 12 cells in it that contain monthly forecast values for Jan - Dec. I need the value of the 13th Cell M10 to contain the last value in the row that is 0. I'm sure this is embarrassingly simply, and any insight would be greatly appreciated. Regards... |
#2
|
|||
|
|||
Try...
=LOOKUP(9.99999999999999E+307,IF(A10:L100,A10:L10 )) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "cincode5" wrote: Hi everyone. I was wondering what function in Excel can be used to return the last value in a range of cells. Specifically - Row 10 has 12 cells in it that contain monthly forecast values for Jan - Dec. I need the value of the 13th Cell M10 to contain the last value in the row that is 0. I'm sure this is embarrassingly simply, and any insight would be greatly appreciated. Regards... |
#3
|
|||
|
|||
Thanks Domenic... This will do the trick. Needed to work a little to
understand arrays, but I believe I've got the answer. "Domenic" wrote: Try... =LOOKUP(9.99999999999999E+307,IF(A10:L100,A10:L10 )) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "cincode5" wrote: Hi everyone. I was wondering what function in Excel can be used to return the last value in a range of cells. Specifically - Row 10 has 12 cells in it that contain monthly forecast values for Jan - Dec. I need the value of the 13th Cell M10 to contain the last value in the row that is 0. I'm sure this is embarrassingly simply, and any insight would be greatly appreciated. Regards... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |