Need excel formula

Reply #6

hypersoniq — Sun, 15 Jan 2006 01:28:59 GMT

rank would only give a number value to the hits countthere are some special uses of rank, however... instructions here...http://www.cpearson.com/excel/rank.htmcould be a tricky formula is needed, I'm still brushing up on formulas (creating your own) so I'll have to get back to you on this one... manually, you could select the 2 columns, click on SORT and pick the 2nd of the 2 columns in descending order, this would put the high counts at the top with their corresponding digits (but only if both... [ More ]

Reply #5

Sandy K — Sat, 14 Jan 2006 17:18:09 GMT

yes hyper is was:=COUNTIF($B$2:$D$8,G2)what do you suggest?How would I do it with the =rank?the countif formula counts well but it doesn't sort largest hits at the top on down......Here is the Countif results:DigitsHits04122334415261718291It counts but I wanted sorted so that the 0-3-2 is on top with 4 hits each and so on. If I remember, I think the rank would do it but don't know how to do it.Really what I am trying to do is set up a Power Trails spreadsheet.....fiddling with the amount of... [ More ]

Reply #4

hypersoniq — Sat, 14 Jan 2006 17:09:08 GMT

was it a =countif() formula?I have yet to try, but I think the =rank() formula could help with the order...

Reply #3

Sandy K — Sat, 14 Jan 2006 14:35:27 GMT

thanks LL......but I just got the formula.

Reply #2

Sandy K — Sat, 14 Jan 2006 14:17:53 GMT

thank you big time, LL.......have a great day. Not really what I want but will play with it.....not interested in sums....just the count...I think it is a COUNTIF command or a COUNT command.In the gray area, why can't I just sort with the decending order AZ thingie on the tool bar

Reply #1

lottaloot — Sat, 14 Jan 2006 14:07:39 GMT

P1P2P3026311124814236211323384333954441264851778021085016932510 I have my table set up like this. Will get you by until someone else gives you something better. Draws set up in cells D:FP1=D2:D43P2=E2:E43P3=F2:F43equals resultsThen grey cells starting at 0=sum(of P1:P3)From there you have to count the old fashioned way or use auto filter, etc.

Need excel formula

Sandy K — Sat, 14 Jan 2006 13:49:16 GMT

I want to count how many times a digit fell......Cells B2,B3,B4 are the individual digits cellsthru Row 8preferable sorted with the most hit digits first..........Hypersoniq or WSLS help!!!!!!!The idea is to take 7 days of draws, which would be 42 digits and find out which ones hit the most in a sorted list.