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

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

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

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

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