Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room
Reload this Page Poop excel gurus... could use a hand
Register FAQDonate Members List Calendar

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
Old 04-19-2011, 03:37 PM  
pr_capone pr_capone is offline
**** SOC & **** YOU
 
pr_capone's Avatar
 
Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
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: 19,884
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
Kind of a mod
 
DaFace's Avatar
 

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

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

would do it I think.
Posts: 51,792
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
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
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: 51,792
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: $10329900
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: 180,739
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
**** SOC & **** YOU
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
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: 19,884
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
**** SOC & **** YOU
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
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: 19,884
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
**** SOC & **** YOU
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
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: 19,884
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
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
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: 51,792
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: $10329900
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: 180,739
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
Kind of a mod
 
DaFace's Avatar
 

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

That work?
Last edited by DaFace; 04-19-2011 at 04:08 PM..
Posts: 51,792
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
**** SOC & **** YOU
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
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: 19,884
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
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
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: 51,792
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
The Franchise The Franchise is offline
Most Valuable Villain
 
The Franchise's Avatar
 

Join Date: Dec 2006
Casino cash: $3085047
The real question is.....how exactly ARE you getting a million dollars in 28 days?
Posts: 92,188
The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.The Franchise is obviously part of the inner Circle.
     Reply With Quote
Old 04-19-2011, 04:08 PM   #14
pr_capone pr_capone is offline
**** SOC & **** YOU
 
pr_capone's Avatar
 

Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
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: 19,884
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
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
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: 51,792
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
Page 1 of 2 1 2

« Previous Thread | > Nzoner's Game Room < | Next Thread »

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 11:39 PM.

Contact Us - ChiefsPlanet - Archive - Top

This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Advertise with us!
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.