If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find Last Item Entered in Row
Hi, I am hoping I can get some help on this.
I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in columns B - BA. I need a formula in colum BB that will find the last price entered for that item # in all of the columns. There will be items that may get updated each week, and others that will only get updated periodically, so those columns may be blank. Any help would be appreciated. Thanks |
#2
|
|||
|
|||
Find Last Item Entered in Row
Ron,
Put this in BB1 and drag down =LOOKUP(2,1/(B1:BA1""),B1:BA1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Ron" wrote: Hi, I am hoping I can get some help on this. I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in columns B - BA. I need a formula in colum BB that will find the last price entered for that item # in all of the columns. There will be items that may get updated each week, and others that will only get updated periodically, so those columns may be blank. Any help would be appreciated. Thanks |
#3
|
|||
|
|||
Find Last Item Entered in Row
in columns B - BA
find the last price entered This will return the rightmost (last) numeric value from the range. =LOOKUP(1E100,B2:BA2) -- Biff Microsoft Excel MVP "Ron" wrote in message ... Hi, I am hoping I can get some help on this. I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in columns B - BA. I need a formula in colum BB that will find the last price entered for that item # in all of the columns. There will be items that may get updated each week, and others that will only get updated periodically, so those columns may be blank. Any help would be appreciated. Thanks |
#4
|
|||
|
|||
Find Last Item Entered in Row
Thanks to both of you. Both formula's worked great!
Ron "Ron" wrote: Hi, I am hoping I can get some help on this. I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in columns B - BA. I need a formula in colum BB that will find the last price entered for that item # in all of the columns. There will be items that may get updated each week, and others that will only get updated periodically, so those columns may be blank. Any help would be appreciated. Thanks |
#5
|
|||
|
|||
Find Last Item Entered in Row
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Ron" wrote in message ... Thanks to both of you. Both formula's worked great! Ron "Ron" wrote: Hi, I am hoping I can get some help on this. I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in columns B - BA. I need a formula in colum BB that will find the last price entered for that item # in all of the columns. There will be items that may get updated each week, and others that will only get updated periodically, so those columns may be blank. Any help would be appreciated. Thanks |
Thread Tools | |
Display Modes | |
|
|