Extracting Data into a table ?

[ibidem]

Hi, not sure how to descibe my problem properly.

I have a list of data similar to this (several thousand entries):

J7 12
92 -4
JJ 34
TT 9
AQ 23
TT -3
AA +23
98s -5

The letters refer to my poker starting hands, and the number to the p/
on that particular hand.

I'm trying to figure a way of automatically putting all these entrie
into a table of some kind to tell me the number of times i've playe
each hand combination and the best/worst/average profit from each
i've been doing it manually so far and there's must be a better way!

Any help or suggestions as to which part of the manual deals with thi
would be appreciated.

Thanks very much

 

[Trevor Shuttleworth]

Assuming your hands are in column A and the p/l is in column B, insert the
following formula into cell C2 (or whatever) and drag down.

=SUMIF(A:A,A2,B:B)/COUNTIF(A:A,A2)

You could use an Advanced Filter on column A to extract the unique entries
and then use similar formulae but using the table of unique entries.

Regards

Trevor

 

[AlfD]

Hi!

Looks as though each entry has a space in between the Hand and the p/
(is that profit/loss?)

If so, use Data > Text to Columns to separate the hands from the p/l
(Use delimiter as space).

Give each of the 2 cols a heading (e.g. Hand; p/l).

Now sort the data in these two cols. (Data > Sort using Hands col.)

Two options now. First my preference.

Select the data in the 2 cols (including headings). Use Data
Subtotals... You will want to choose Hands as the "at each change in
option. You can choose Sum, Max or Min as the reported result whic
should go in the p/l col.

Alternatively: some people would prefer to use a pivot table for thi
bit.
Try it: select the data: use Data > Pivot Tables and.....
The Wizard will take you through: I suggest put Hands in the column
and p/l in the rows. The data section can give you Sum, Max and Min.

Al