Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jatolo

  1. jatolo

    Modifying a Formula

    Thank you SKIPVOUGHT!! Thanks.... Jatolo
  2. jatolo

    Modifying a Formula

    This formula is working PERFECT.... =IF((P4=1)*(R4=1)*AND(T4=1),1,0) NOW I NEED TO ADD "C1"... I MEAN... P4="1 RA4=1 T4=1,1,0 P4="C1" RA4=1 T4=1,1,0 P4=1 RA="C1" T4=1,1,0 P4=1 RA=1 T4=C1,1,O P4"C1" RA"C1" T4"C1",1,0... in other words count "c1" as 1 thank you!! Thanks.... Jatolo
  3. jatolo

    Subtracting From 2 differents cell

    JPAULES Thank you very much!!! Thanks.... Jatolo
  4. jatolo

    Subtracting From 2 differents cell

    I need to subtract from 2 differents cells,,,, This is the formula subtracting from one cell EZ11 =SUM(C11:EQ11)-EZ11 Now I need to subtract from cell FA11 as well... All this...=SUM(C11:EQ11) minus EZ11 AND FA11 Thanks... Thanks.... Jatolo
  5. jatolo

    Chance a Fomula...

    TheManiac Thank you for your help....AGAIN YOU GOT IT RIGHT!!! Thanks.... Jatolo
  6. jatolo

    Chance a Fomula...

    Thanks themaniac,, the formula WORKS great!!! Just one more question.... If I want to copy this formula to BL4, BL5, BL6 and so on... what should I do.... I tried but it keeps BL3 all the time..... Thanks.. Thanks.... Jatolo
  7. jatolo

    Chance a Fomula...

    Works ... but WHEN $BL$64="C"and BL3="C" it keeps showing 1 instead "C"... thanks... Thanks.... Jatolo
  8. jatolo

    Chance a Fomula...

    You are right.... "Is it correct that if BL3 = BL64, it should be 1, and if not it should be 0, unless it is matching C in both locations, and then it should be C1? Is that the criteria?" ..and the vaslues are...A, B, C.... NOT "".. Thanks again Thanks.... Jatolo
  9. jatolo

    Chance a Fomula...

    SORRY SORRY SORRY!!! i MADE A BIG MISTAKE... =IF($BL$64="","",IF(BL3=$BL$64,1,0)) I NEED TO CHANGE THE ABOVE FORMULA TO: IF $BL$64="A" AND BL3="A",1,0 IF $BL$64="B",AND BL3="B",1,0 IF $BL$64="C",and BL3="C","C1",0 ONCE AGAIN JUST WHEN IT SHOWS "C" THE RESULT SHOULD BE C1 or 0 THANKS FOR...
  10. jatolo

    Chance a Fomula...

    =IF($BL$64="","",IF(BL3=$BL$64,1,0)) I NEED TO CHANCE THE ABOVE FORMULA TO: IF $BL$64="A" THEN BL3=1,0 IF $BL$64="B",THEN BL3=1,0 IF $BL$64="C",THEN BL3="C1",0 ONCE AGAIN JUST WHEN IT SHOWS "C" THE RESULT SHOULD BE C1 or 0 THANKS FOR YOUR HELP!!! Thanks.... Jatolo
  11. jatolo

    Comparing Rows.

    1 2 3 4 5 6 7 8 9 10 joe Doe A C B C C A B A A C John P. C B A A A C B B C B MARY S. A C B B C C A A B C I have about 60 persons with diferents scores(A,B,C)in 10 games... Is there any way to find out if two persons has chosen the same scores.....coincidentally. Thanks very much...
  12. jatolo

    BLANK CELLS

    I AGREED WITH YOU...BUT I'M NOT AN EXCEL EXPERT I USE EVERY "BLUE MOON".. THANKS AGAIN... Thanks.... Jatolo
  13. jatolo

    BLANK CELLS

    I wish I could explain it, but the whole process is too complicated. The 95% is running thanks to THIS WONDERFUL AND HELPFUL FORUM and EXCEL 2003 BIBLE... Thanks again... but I'M GIVING UP.... I'll try for 2014 SOCCER WORLCUP IN BRAZIL.... ;) Thanks.... Jatolo
  14. jatolo

    BLANK CELLS

    Sorry I made a mistake.. Every single cell is organized... (64) Games...
  15. jatolo

    BLANK CELLS

    1). Every cell represents a SOCCER WORLCUP GAME.= Total 64 Games 2). Every cell is connected to another worksheet... 3). Every cell will show any score between 0 and up (>=0) I want to show the numbers of game played every day. sorry I'm NOT an expert I'm learning from you.. Thanks.... Jatolo
See more

Part and Inventory Search

Back
Top