Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The GET IN MAH BELLY! Lounge

Reply
 
Thread Tools Display Modes
Old 04-19-2011, 03:37 PM  
pr_capone pr_capone is offline
** *- -- -- *
 
pr_capone's Avatar
 
Join Date: Jan 2006
Location: Aguadilla
Casino cash: $162957141
excel gurus... could use a hand

I need a formula that will return the date in which I will have over 1m.

bad cut, days are A and amounts are B

been trying to figure this out for 45 minutes now. I hate excel but I have to learn it.

Posts: 18,371
pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:46 PM   #2
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $656656
If you switch the columns, you could do it with a vlookup.

=VLOOKUP(1000000,A6:B37,2,true)

would do it I think.
Posts: 27,677
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:49 PM   #3
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $656656
Is this for personal use or for a class or something? If you're looking for a formula that would do it without switching the columns, I don't know one right off hand, but could probably figure it out.
Posts: 27,677
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:51 PM   #4
Donger Donger is offline
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675 N 106.475 W
Casino cash: $1906
It looks like you already figured it out in Row 42.
__________________
I think the young people enjoy it when I "get down," verbally, don't you?
Posts: 74,831
Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:52 PM   #5
pr_capone pr_capone is offline
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $162957141
Quote:
Originally Posted by DaFace View Post
If you switch the columns, you could do it with a vlookup.

=VLOOKUP(1000000,A6:B37,2,true)

would do it I think.
close... pulled up the day before
Posts: 18,371
pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:53 PM   #6
pr_capone pr_capone is offline
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $162957141
Quote:
Originally Posted by DaFace View Post
Is this for personal use or for a class or something? If you're looking for a formula that would do it without switching the columns, I don't know one right off hand, but could probably figure it out.
nothing overly pressing... just for class.
Posts: 18,371
pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:56 PM   #7
pr_capone pr_capone is offline
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $162957141
Quote:
Originally Posted by Donger View Post
It looks like you already figured it out in Row 42.
Just placed it there to show what the needed result was
Posts: 18,371
pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:56 PM   #8
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $656656
Quote:
Originally Posted by pr_capone View Post
nothing overly pressing... just for class.
Hmm. Have you been using INDEX and MATCH formulas lately? You could probably do it that way, but it's a bit of a pain in the ass.
Posts: 27,677
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 03:59 PM   #9
Donger Donger is offline
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675 N 106.475 W
Casino cash: $1906
Quote:
Originally Posted by pr_capone View Post
Just placed it there to show what the needed result was
That's cheating.
__________________
I think the young people enjoy it when I "get down," verbally, don't you?
Posts: 74,831
Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 04:00 PM   #10
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $656656
=INDEX(A7:B37,MATCH(1000000,B7:B37),1)

That work?

Last edited by DaFace; 04-19-2011 at 04:08 PM..
Posts: 27,677
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 04:05 PM   #11
pr_capone pr_capone is offline
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $162957141
Quote:
Originally Posted by DaFace View Post
=INDEX(A7:B37,MATCH(1000000,B7:B37),1)

That work?
Nope, returned 30-jan

I havent been using the index feature in class but have briefly touched on vlookup so it is a safe bet to say the first thought was the right one.

reading my textbook tho...

use vlookup to search for exact matches or for the nearest value that is less than or equal to the search value.

which is why it returns the 27th. its looking for the lowest value under 1m.
Posts: 18,371
pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 04:06 PM   #12
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $656656
Quote:
Originally Posted by pr_capone View Post
Nope, returned 30-jan

I havent been using the index feature in class but have briefly touched on vlookup so it is a safe bet to say the first thought was the right one.

reading my textbook tho...

use vlookup to search for exact matches or for the nearest value that is less than or equal to the search value.

which is why it returns the 27th. its looking for the lowest value under 1m.
Could you just attach that sheet? It's kind of hard to play with these things without being able to just do it in Excel.
Posts: 27,677
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 04:06 PM   #13
Pestilence Pestilence is offline
Want a ride?
 
Pestilence's Avatar
 

Join Date: Dec 2006
Location: Nor-Cal
Casino cash: $77614563
The real question is.....how exactly ARE you getting a million dollars in 28 days?
Posts: 43,321
Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.Pestilence is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 04:08 PM   #14
pr_capone pr_capone is offline
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $162957141
Quote:
Originally Posted by DaFace View Post
Could you just attach that sheet? It's kind of hard to play with these things without being able to just do it in Excel.
you know what I did? I modified your first post to

=VLOOKUP(1500000,A6:B37,2,true)

which returned the correct answer. for the purposes of this specific assignment, that will do just fine.

thx for the assist Face!
Posts: 18,371
pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.pr_capone is obviously part of the inner Circle.
  Reply With Quote
Old 04-19-2011, 04:11 PM   #15
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $656656
Quote:
Originally Posted by pr_capone View Post
you know what I did? I modified your first post to

=VLOOKUP(1500000,A6:B37,2,true)

which returned the correct answer. for the purposes of this specific assignment, that will do just fine.

thx for the assist Face!
Cool. In case anyone cares, I just tried my second one as well, and it seems to work fine too. INDEX and MATCH are pretty powerful, but they're a bit of a pain in the ass.
Posts: 27,677
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Reply

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -6. The time now is 05:53 AM.


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.