Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Ed & Dave 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: $5262
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,355
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: $5175
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,933
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: $5175
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,933
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: $660
VARSITY
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: 76,359
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: $5262
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,355
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: $5262
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,355
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: $5262
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,355
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: $5175
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,933
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: $660
VARSITY
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: 76,359
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: $5175
=INDEX(A7:B37,MATCH(1000000,B7:B37),1)

That work?

Last edited by DaFace; 04-19-2011 at 04:08 PM..
Posts: 27,933
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: $5262
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,355
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: $5175
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,933
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: $14463
The real question is.....how exactly ARE you getting a million dollars in 28 days?
Posts: 44,047
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: $5262
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,355
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: $5175
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,933
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:24 AM.


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