Find Last Item Entered in Row

R

Ron

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
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to choose from the last column of a given row 1
finding last number in row excluding 0's 7
Summary of Unique item values 2
Data entered from list automatically enters number in another cell 4
find first and last values in a row of cells 7
Find the last number in a row 6
Computing the item age 2
Extract first value and last value from a table 1

Top