Dummie Working On A BJ Audit Has An Excel ?

[NASHVEGAS]

If anyone is an EXCEL 2003 expert for dummies, I have a question on the easiest way (read some complicated ones I think) if possible with a hand history to convert text or a string of text in a column to numeric values so I do not have to keep totaling each hand (over 100K total hands/rows) row by row. A sample of 10 rows and 2 columns (not aligning) below:

Qd,Tc

20

3s,5c,Kd

18

5c,5c,6c,5d

21

Ac,4c,2s,6h,3h,Ks

26

6d,8s,Tc

24

Qd,3s,2c,8h

23

5h,Qc,Qd

25

Td,Ks

20

Th,7s

17

8c,4h

12

P.S.-Never have done an EXCEL macro (or separate worksheet even) if that is the way to go but I can follow detailed instructions for dummies

TIA,NV

[RobWin]

Nash, do you know how to enter (sum=) for the rows and columns and create your formula ??

Example: =N10+N11+SUM(N10:N11)

[NASHVEGAS]

Nash, do you know how to enter (sum=) for the rows and columns and create your formula ??

Example: =N10+N11+SUM(N10:N11)

That I do or I use the auto sum button for the basics. Never have used it to add text (and numbers) though ,LOL, but I have an idea ,well sorta, on what you may instruct. Thanks for any help!!

[RobWin]

That I do or I use the auto sum button for the basics. Never have used it to add text (and numbers) though ,LOL, but I have an idea ,well sorta, on what you may instruct. Thanks for any help!!

Ok, in your formula you need to assign values to the K,Q & J of 10 and an 11 or 1 to the "A" but that could also be a little tricky since the "A" may have been used as a 1 or 11...let me check something here...be back in a few

[jas2587]

Hurry back Rob


woohooo Gators

Go Titans

Cindy

[NASHVEGAS]

Hurry back Rob

No rush, Falcons in a close and important one, in the 4th .

woohooo Gators

#1 in the AP poll but who knows with the BCS until a done deal

Go Titans

28-9 in the 4th

Cindy

Going to check all those formula's et al out again later unless someone can lead this horse to water with the correct formula. Have to account for the suits of each card and although there is prolly a if,then,>,< way to account for the Aces, prolly simplier just to assign an 11 value to all 4 Aces and manually correct values that equal 1. Will stay the course of row by row which is time consuming but could be beneficial (not statiscally) also.

[RobWin]

Going to check all those formula's et al out again later unless someone can lead this horse to water with the correct formula. Have to account for the suits of each card and although there is prolly a if,then,>,< way to account for the Aces, prolly simplier just to assign an 11 value to all 4 Aces and manually correct values that equal 1. Will stay the course of row by row which is time consuming but could be beneficial (not statiscally) also.

I'm stuck... Can't figure out how to account for the different value of the aces and it is most likely something real simple too but just can't manage to decipher it thru the fog...

[NASHVEGAS]

I'm stuck... Can't figure out how to account for the different value of the aces and it is most likely something real simple too but just can't manage to decipher it thru the fog...

Appreciate you trying. Can't expect us construction guys to know everything but just about everything,LOL

[RobWin]

Appreciate you trying. Can't expect us construction guys to know everything but just about everything,LOL

Yep LOL...maybe one of the math wizards will be along and make it look really simple...

[bryand]

Cool project for me to work on while I'm bored....lol. The formula needs an "If, Then" statement to deal with the ace issue. I'll post the formulas when complete.