A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Find Last Item Entered in Row



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2010, 04:49 PM posted to microsoft.public.excel.worksheet.functions
Ron
external usenet poster
 
Posts: 690
Default 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  
Old February 9th, 2010, 04:55 PM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
 
Posts: 8,419
Default 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  
Old February 9th, 2010, 05:42 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default 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  
Old February 10th, 2010, 01:20 AM posted to microsoft.public.excel.worksheet.functions
Ron
external usenet poster
 
Posts: 690
Default 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  
Old February 10th, 2010, 02:54 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.