https://www.lotterypost.com/thread/312837 Lottery Post Forum Topic: Help with excel formula en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/312837/5111511 https://www.lotterypost.com/thread/312837/5111511 Sun, 28 May 2017 13:50:05 GMT Sunglasses Ok, write one.

]]> Sunglasses https://www.lotterypost.com/thread/312837/5110865 https://www.lotterypost.com/thread/312837/5110865 Sat, 27 May 2017 21:32:05 GMT Mr-B 216 Sorry, but that one may require a macro.

]]> Mr-B 216 https://www.lotterypost.com/thread/312837/5110279 https://www.lotterypost.com/thread/312837/5110279 Sat, 27 May 2017 10:20:48 GMT Sunglasses What if you have 123A0577 and you want all frequencies in B1, sorted by frequency and mode in bold red? Do you have such a formula for me

]]> Sunglasses https://www.lotterypost.com/thread/312837/5109929 https://www.lotterypost.com/thread/312837/5109929 Sat, 27 May 2017 01:01:00 GMT Mr-B 216 You are very welcome...GOOD LUCK

]]> Mr-B 216 https://www.lotterypost.com/thread/312837/5109878 https://www.lotterypost.com/thread/312837/5109878 Sat, 27 May 2017 00:11:42 GMT adobea78 Thank u very much, is working

]]> adobea78 https://www.lotterypost.com/thread/312837/5109793 https://www.lotterypost.com/thread/312837/5109793 Fri, 26 May 2017 23:05:26 GMT Mr-B 216 =LEN($A$1)-LEN(SUBSTITUTE($A$1, 5 , ))

Simply change the 5 to whatever digit you are looking to count.

]]> Mr-B 216 https://www.lotterypost.com/thread/312837/5109767 https://www.lotterypost.com/thread/312837/5109767 Fri, 26 May 2017 22:36:28 GMT Sunglasses use mid() in cells next to A1. Then continue like normal.

]]> Sunglasses https://www.lotterypost.com/thread/312837 https://www.lotterypost.com/thread/312837 Fri, 26 May 2017 00:54:04 GMT adobea78 I need the format function to return each digit frequency for the cell A1.

A1(5506518186505214207433493715908751689058)

Thanks.

]]> adobea78