# Formula for line column

1. ## Formula for line column

Hello, I don't know how to explain this but I will try.

Week------Sales
1-----------500
2-----------600
3-----------300
4----------Div/0
5----------Div/0

First Week 500
Last Week (Formula)

So basically I want it to know what is last data is. It's 300, but I want excel automatically to put the number in. Is there a formula for this like =line(b1:b4),1) or something like that?

Thanks, Bogdan.

http://www.excelforum.com/attachment...1&d=1468256035

2. ## Re: Formula for line column

Try

=LOOKUP(9.99999999999999E+307,B2:B9)

3. ## Re: Formula for line column

Originally Posted by Jonmo1
Try

=LOOKUP(9.99999999999999E+307,B2:B9)
Is this a joke? why are those numbers so large? so basically the formula has something to do with =lookup?

4. ## Re: Formula for line column

....................................

5. ## Re: Formula for line column

Originally Posted by sovietchild
ok thanks I tried =lookup(b2,b2:b9) and it worked
It might have worked but it is a coincidence; if you want the last value, his formula was working well

His number is huge because it has to be a bigger number than all the ones you have. You can try with something like 9999999999 is his number seems to large, but that's still the idea.

6. ## Re: Formula for line column

9.99999999999999E+307 is documented as the largest number a cell can possibly hold.

And No, it was not a joke.

Did you try it?

7. ## Re: Formula for line column

Originally Posted by Jonmo1
Try

=LOOKUP(9.99999999999999E+307,B2:B9)
I just looked up on youtube and yes that is the formula, sorry for that I thought you was playing a cruel joke on me, (playing a joke on nubs freezing their computers)

8. ## Re: Formula for line column

it works, thank you so much

9. ## Re: Formula for line column

Members would probably get banned from the forum for playing jokes like that.

10. ## Re: Formula for line column

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1