I want to count how many times a digit fell......

Cells B2,B3,B4 are the individual digits cells

thru Row 8

preferable 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.

P1 | P2 | P3 | ||

0 | 2 | 6 | 3 | 11 |

1 | 2 | 4 | 8 | 14 |

2 | 3 | 6 | 2 | 11 |

3 | 2 | 3 | 3 | 8 |

4 | 3 | 3 | 3 | 9 |

5 | 4 | 4 | 4 | 12 |

6 | 4 | 8 | 5 | 17 |

7 | 8 | 0 | 2 | 10 |

8 | 5 | 0 | 1 | 6 |

9 | 3 | 2 | 5 | 10 |

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:F

P1=D2:D43

P2=E2:E43

P3=F2:F43

equals results

Then grey cells starting at 0

=sum(of P1:P3)

From there you have to count the old fashioned way or use auto filter, etc.

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?

Jan 14, 2006, 12:09 pm

was it a =countif() formula?

I have yet to try, but I think the =rank() formula could help with the order...

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:

Digits | Hits |

0 | 4 |

1 | 2 |

2 | 3 |

3 | 4 |

4 | 1 |

5 | 2 |

6 | 1 |

7 | 1 |

8 | 2 |

9 | 1 |

It 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 draws inputted right now.

Jan 14, 2006, 8:28 pm

rank would only give a number value to the hits count

there are some special uses of rank, however... instructions here...

http://www.cpearson.com/excel/rank.htm

could 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 ranges are selected)... that's how I do quick imports from state lottery games, copy their descended order list and re-sort it by date ascending (so I have newest draws at the bottom)

TopEnd of thread (1 page)

© 2020 Speednet Group LLC Lottery Post is a registered trademark of Speednet Group. |

Welcome Guest

Your last visit: Thu, Oct 29, 2020, 2:58 am