Search

need excel FORMULA Help 2017Reply
thanks raven62 butt not working right... =SUMPRODUCT(LEN(f5:O14)-LEN(SUBSTITUTE(f5:O14, 660 , ))) ctrl-shift-enter-----------array formula =SUMPRODUCT(0+(MID(F$5:O$14,{1,2},660)= B1)) =SUMPRODUCT(0+(MID(A$1:A$10,{1,2},1)= 660 )) =SUMPRODUCT(LEN(F5:O14)-LEN(SUBSTITUTE(F5:O14, 660 , )))answer is giving me 6 and we only have 4----- looking for another formula to make it work RIGHT..... Still need HELP from the EXCEL People thanks bob in Michigan
Sep 18, 2017, 9:18 am - Bob - Mathematics Forum

need excel FORMULA Help 2017
NEED HELP For a FORMULA in EXCEL--Running 2016excel FORMULA To count 3 digit numbers (all in one cell range... =COUNTIF($F$5:$O$14,$F5) -------------------------------------------------------- Need formula to Count All Duplicates (all ways EXAMPLE -- 123--132--213--231--312--321 NUMBERS are 3digits each in 0ne cell (123) Just cant figure out the right formula ...Can Someone HELP?? Thanks Bob in Michigan
Sep 17, 2017, 5:01 pm - Bob - Mathematics Forum

Excel Help NeededReply
Getting kind of confused here----- CarBob puts it 45/3 Time*treat puts it 0/45 I am just learning myself but thinking that carbob is the way to go-- Hits total / divided by Hits Example ----- if the number 5 had 8 Hits and the total was 45 hits than you would take 45 /divided by 8--------------45/8==5.62 Hope that is right--- Thanks Bob in Michigan
Jun 30, 2008, 12:58 pm - Bob - Mathematics Forum

need excel FORMULA Help 2017Reply
Still giving me wrong count for the duplicates =LEN($F$5)-LEN(SUBSTITUTE($F$5, 660 , )) EXAMPLE--HOW MANY DUPS?ANSWER SHOULD BE 5 ---BUTT IT SAYS 3 F G H I J K L M N O 660 1 066 2 606 3 4 066 5 6 660 7 8 anyway WRONG FORMULA THANKS ANYWAY Raven62 Still need a formula----need help bob in Michigan
Sep 18, 2017, 10:48 am - Bob - Mathematics Forum

I believe that Play 3 Lottery can be won with a little math!Reply
Using the system Joker17 Taught me i could make some cash flow if i would just stick to the Addition and multiplication. And if i could see straight. Friday Michigan Midday 5-20 was 763. 7+6=13 use the 3 7+3=10 use the 0 6+3=9 use the 9 7x6=42 use the 2 7x3=21 2+1=3 use the 3 309, 302, 303. Michigan's Evening drawing for Friday 5-20 was 302. How did i miss that? DUH For now on no more subtraction for me in Michigan's drawings, gives me too many numbers to work with.
May 21, 2010, 8:59 pm - CutlassBob - Mathematics Forum

Help find Best frequency for a 3 digit number
excel pro's-- and All--- How does one find the Frequecy of 3 digit numbers??? Is there different frequencys to a group of numbers?? Like how many times a number hits? What do you divide it by? Hits/by number of draws??? Trying to find out which one is the BEST to go by in EXCEL 2007-----??? What is the Best FORMULA to use in EXCEL to get the frequency??? We searched here on LP butt did not find what we wanted... I think maybe a good one is How manytimes a number hits d
Feb 11, 2010, 8:38 am - Bob - Mathematics Forum

Excel Help NeededReply
#DIV/0! 4 45.00-- 9 22.50-- 5 15.00-- 8 11.25-- 1 9.00--- 7 7.50--- 2 6.43--- 3 5.63--- 0 5.63--- 6 Total--45 hits ok got it and thank you carBob----but I get a #DIV/0! on the 4 because they were no hits...?????thats normall??? Would the 4 go on the bottom ??? Thanks again CARBOB Bob in Michigan
Jun 30, 2008, 9:11 am - Bob - Mathematics Forum

Excel question from Bob (i'm running out of private msg)
Bob, 1. We need to handle this request and any future others by open forum topics as I'm a Standard level member here so my private msg capability is limited and then I'll not be able to read any more of them. 2. Regarding your recent request ... Could you make a formula for the 4 digit that will match 3 numbers? We tried to change the 2 digit formula that you gave us for the 3 digit... =IF(LEFT(TEXT(A1, 000 ),2)=TEXT($K$1, 00 ), TRUE TEXT(A1, 000 ),IF(LEFT(TEXT(A1
Feb 13, 2020, 12:03 pm - nibor200 - Mathematics Forum

need excel FORMULA Help 2017Reply
F G H I J K L M N O 5 660 661 662 663 662 665 666 660 668 669 6 110 111 112 113 112 115 116 110 606 119 7 000 001 002 003 002 005 600 000 008 009 8 550 551 552 553 552 555 556 550 558 066 9 330 331 332 333 332 335 336 330 338 339 10 885 881 882 883 882 885 886 880 885 889 11 775 771 772 773 772 775 776 770 775 779 12 995 991 992 993 992 995 996 990 995 999 13 445 441 442 443 442 445 446 440 110 449 14 225 221 222 223 222 225 226 220 225 110 example would like
Sep 18, 2017, 11:35 am - Bob - Mathematics Forum

We need a Formula in EXCEL
1A---76631534 -------------------- 2B---4394687 3C---734156 4D---17562 5E---8328 6F---251 7G--76 --------------------- Need a formula for adding root numbers? Example:row 1A 7+6=13---1+3=4 So 4 would be the first number in row2B next in row 1A--6+6=12---1+2=3 So 3 would be next in row 2B and so on till the last two numbers in row 1A ---3+4=7 need the whole formula --using excel 7 thank you.. we did try the MOD formula but it didn't add the ro
Apr 25, 2015, 10:38 am - Bob - Mathematics Forum