Excel VS. VB

Reply #4

powerplayer — Sat, 26 Nov 2005 06:02:11 GMT

Thank you time*treat!!!I will work on thisPowerplayer

Reply #3

time*treat — Fri, 25 Nov 2005 18:08:55 GMT

well, the bad news is that the routine may be too long for me to post here, but the good news is I just saved a bunch of money... umm... the routine is easy to understand. You basicallydim numbers(999) as integer <--- there is an automatic 0 spacefor cellsrow = 1 to (whatever) if cell(cellrow, column).value < > then number(cell(cellrow,column).value) = _ number(cell(cellrow,column).value) +1 end ifnext cellrowfor digits = 0 to 999 cells(output_row + digit, output... [ More ]

Reply #2

powerplayer — Fri, 25 Nov 2005 08:35:54 GMT

i want to count all 1,000 combinatons to each # set.Ex. 123,132,213,231,312,321so both straight and boxActually all 1,000 combinations are straight since they can come out in any order but, I'm trying to narrow this down to only the combination that hit the most so I can get more straights.I want the script to be able to count for me instead of me doing it and every time I enter a new # from each drawing to update this list.I'm thinking maybe your right a macro is what I need? Not to good with m... [ More ]

Reply #1

time*treat — Fri, 25 Nov 2005 08:15:40 GMT

I do MOST of my excel stuff on the macro side. I don't play P3 but may be able to help, but I'm not sure what you're trying to do here. are you trying to count straights or boxes

Excel VS. VB

powerplayer — Fri, 25 Nov 2005 08:08:35 GMT

Hello,I'm not a very good VB person for what I'm trying was wondering if any one knows VB Excel pretty good???Well here is my question if anyone can shed some light on this it would be great!!I have the following:123313212131231031203211Total6 Now the first row of #'s are in cells going down and the 2nd row is the results with the following formula =SUM(ISNUMBER(FIND( 123 ,B3:M51))*1)So it doesn't look at the 1st column with all the combo's listed in the formula. I have a couple of times by pu... [ More ]