#1
|
|||
|
|||
Need help with exell
I made a spread sheet with that tracks all my relusts by time location result ect and gives out by BB/ HR $/HR Standard D , i want to make identical copies of the sheet that only take the data from the original sheet within a certain criteria ie. Last 6 months, last 12 months, 4/8 8/16,ect. is there some sort of copy IF Funtion???
|
#2
|
|||
|
|||
Re: Need help with exell
You can use the IF function to pull data from your main sheet into any other sheet in the workbook.
The HELP feature in excel will walk you through it. Basically you would set up the sheet like this: <font class="small">Code:</font><hr /><pre> A B C 1 date limit result 2 4/1 4 +75 3 4/2 10 +112 4 4/3 2 -52 </pre><hr /> If you want all results for 10/20, you would have the following formula in D2: =IF(B2=10,C2,0) This would return a value of 0 for row 2. You can omit the ,0 at the end and it would then return a value of FALSE for row 2. Copy this formula down and you'd get this: <font class="small">Code:</font><hr /><pre> A B C D 1 date limit result 2 4/1 4 +75 0 3 4/2 10 +112 112 4 4/3 2 -52 0 </pre><hr /> From what I can tell, dates are a little trickier - you might need to put in a hidden column where the date is converted to a number, then use that number in your formula to determine 6 months ago, 1 month ago, all of 2003, etc. |
#3
|
|||
|
|||
Re: Need help with exell
You might want to look into making a pivot table.
|
#4
|
|||
|
|||
Re: Need help with exell
I'm not sure if you have any experience with SQL (or Access), but I think that it would be much easier to store the data in a database and pull it into excel (for editing or viewing) using the data import feature. By doing this you could write your query to pull in the data with whatever parameters you like. As you continue to add to the database, you could simply refresh the excel sheet.
|
#5
|
|||
|
|||
Re: Need help with exell
=(SUMIF('ALL TIME'!K5:'ALL TIME'!K1003,">'Summary'!K9",('ALL TIME'!G5:'ALL TIME'!G1003)))/(SUMIF('ALL TIME'!K5:'ALL TIME'!K1003,">'Summary'!K9",('ALL TIME'!D5:'ALL TIME'!D1003))-SUMIF('ALL TIME'!K5:'ALL TIME'!K1003,">'Summary'!K9",'ALL TIME'!C5:'ALL TIME'!C1003))
Whats wrong with this function ALL TIMEis sheet with all results K = row with dates converted to number G is result d is time is c in time out Summary K= date vaule i am trying to sort with thanks allot for your help |
#6
|
|||
|
|||
Re: Need help with exell
I will take a look at your xls file and see what I can do. In the meantime, I would recommend that you download PokerTracker and check it out. You can download it it for a free trial at
http://www.pokertracker.com/ |
#7
|
|||
|
|||
Re: Need help with exell
thanks
I ahve poker tracker and it is a very good program, however i want something for live game stats |
#8
|
|||
|
|||
Re: Need help with exell
does pokercharts.com do what you need?
|
#9
|
|||
|
|||
Re: Need help with exell
Did you get a chance to look at the changes to the spreadsheet? Did you find it helpful at all?
|
#10
|
|||
|
|||
Re: Need help with exell
yes very helpfull my email wont let me upload a file taht large i there anothere way for me to get you the final result???
|
|
|