Need help with exell

[bigsooner]

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???

[pudley4]

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.

[BruceZ]

You might want to look into making a pivot table.

[Im Just A Bill]

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.

[bigsooner]

=(SUMIF('ALL TIME'!K5:'ALL TIME'!K1003,"&gt;'Summary'!K9",('ALL TIME'!G5:'ALL TIME'!G1003)))/(SUMIF('ALL TIME'!K5:'ALL TIME'!K1003,"&gt;'Summary'!K9",('ALL TIME'!D5:'ALL TIME'!D1003))-SUMIF('ALL TIME'!K5:'ALL TIME'!K1003,"&gt;'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

[Im Just A Bill]

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/

[bigsooner]

thanks
I ahve poker tracker and it is a very good program, however i want something for live game stats

[mostsmooth]

does pokercharts.com do what you need?

[Im Just A Bill]

Did you get a chance to look at the changes to the spreadsheet? Did you find it helpful at all?

[bigsooner]

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???

[Im Just A Bill]

Sure, I can setup a temp account for you. Have you tried zipping it? xls files usually shrink quite a bit with no graphics.