Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge

Reply
 
Thread Tools Display Modes
Old 04-19-2011, 04:37 PM  
pr_capone pr_capone is online now
** *- -- -- *
 
pr_capone's Avatar
 
Join Date: Jan 2006
Location: Aguadilla
Casino cash: $8265
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,393
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:46 PM   #2
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

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

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

would do it I think.
Posts: 28,666
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:49 PM   #3
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12023
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: 28,666
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: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: $671
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: 78,218
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:52 PM   #5
pr_capone pr_capone is online now
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $8265
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,393
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:53 PM   #6
pr_capone pr_capone is online now
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $8265
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,393
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:56 PM   #7
pr_capone pr_capone is online now
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $8265
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,393
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:56 PM   #8
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12023
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: 28,666
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: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: $671
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: 78,218
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, 05:00 PM   #10
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

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

That work?

Last edited by DaFace; 04-19-2011 at 05:08 PM..
Posts: 28,666
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, 05:05 PM   #11
pr_capone pr_capone is online now
** *- -- -- *
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $8265
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,393
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, 05:06 PM   #12
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12023
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: 28,666
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, 05:06 PM   #13
Dicky McElephant Dicky McElephant is offline
Smith sucks elephant trunk.
 
Dicky McElephant's Avatar
 

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

Join Date: Jan 2006
Location: Aguadilla
Casino cash: $8265
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,393
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, 05:11 PM   #15
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12023
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: 28,666
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 02:02 AM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.