Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
Cell A1 has number for January, Cell A2 number for Feb, Cell A3 number for
Mar etc. I need a formula that will pull the data from the last month entered into B2. (IF A12 is blank get A11, but if A11 is blank get A10, if A10 is also blank get A9 etc.) This needs to go for at least 12 - 15 cells) Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
=LOOKUP(2,1/(1:10),1:1)
-- Gary''s Student - gsnu200809 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
Thank you. That works fine.... how do I modify the formula what if I wanted
to put number in cell W1 instead of B2? "Gary''s Student" wrote: =LOOKUP(2,1/(1:10),1:1) -- Gary''s Student - gsnu200809 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
Fortunately, we can put this formula in any cell (except cells in the first
row). -- Gary''s Student - gsnu200809 "RJ" wrote: Thank you. That works fine.... how do I modify the formula what if I wanted to put number in cell W1 instead of B2? "Gary''s Student" wrote: =LOOKUP(2,1/(1:10),1:1) -- Gary''s Student - gsnu200809 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
I was afraid of that in my tests.
Is there a different formula that would work at the end of a row of cells to use the first cell to the left with a number in it? "Gary''s Student" wrote: Fortunately, we can put this formula in any cell (except cells in the first row). -- Gary''s Student - gsnu200809 "RJ" wrote: Thank you. That works fine.... how do I modify the formula what if I wanted to put number in cell W1 instead of B2? "Gary''s Student" wrote: =LOOKUP(2,1/(1:10),1:1) -- Gary''s Student - gsnu200809 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
You could use a formula where you declare the range to use.
Say you wanted to use A1 to Z1, then you could place this formula in Row1, as long as it was *outside* the referenced cells. So, you could enter this in say AA1: =Lookup(99^99,A1:z1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RJ" wrote in message ... I was afraid of that in my tests. Is there a different formula that would work at the end of a row of cells to use the first cell to the left with a number in it? "Gary''s Student" wrote: Fortunately, we can put this formula in any cell (except cells in the first row). -- Gary''s Student - gsnu200809 "RJ" wrote: Thank you. That works fine.... how do I modify the formula what if I wanted to put number in cell W1 instead of B2? "Gary''s Student" wrote: =LOOKUP(2,1/(1:10),1:1) -- Gary''s Student - gsnu200809 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
PERFECT! Thanks to both you and Gary for great formulas!
"RagDyer" wrote: You could use a formula where you declare the range to use. Say you wanted to use A1 to Z1, then you could place this formula in Row1, as long as it was *outside* the referenced cells. So, you could enter this in say AA1: =Lookup(99^99,A1:z1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RJ" wrote in message ... I was afraid of that in my tests. Is there a different formula that would work at the end of a row of cells to use the first cell to the left with a number in it? "Gary''s Student" wrote: Fortunately, we can put this formula in any cell (except cells in the first row). -- Gary''s Student - gsnu200809 "RJ" wrote: Thank you. That works fine.... how do I modify the formula what if I wanted to put number in cell W1 instead of B2? "Gary''s Student" wrote: =LOOKUP(2,1/(1:10),1:1) -- Gary''s Student - gsnu200809 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - in a row of numbers, put last entered number Cell B2
You're welcome, and appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RJ" wrote in message ... PERFECT! Thanks to both you and Gary for great formulas! "RagDyer" wrote: You could use a formula where you declare the range to use. Say you wanted to use A1 to Z1, then you could place this formula in Row1, as long as it was *outside* the referenced cells. So, you could enter this in say AA1: =Lookup(99^99,A1:z1) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "RJ" wrote in message ... I was afraid of that in my tests. Is there a different formula that would work at the end of a row of cells to use the first cell to the left with a number in it? "Gary''s Student" wrote: Fortunately, we can put this formula in any cell (except cells in the first row). -- Gary''s Student - gsnu200809 "RJ" wrote: Thank you. That works fine.... how do I modify the formula what if I wanted to put number in cell W1 instead of B2? "Gary''s Student" wrote: =LOOKUP(2,1/(1:10),1:1) -- Gary''s Student - gsnu200809 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number entered isn't number recorded in cell. | Excel Discussion (Misc queries) | |||
Can excel give value in words of number entered in another cell? | Excel Worksheet Functions | |||
cell that only a certain number may be entered | Excel Worksheet Functions | |||
sum a range of numbers entered into a cell | New Users to Excel | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) |