• WSboat

    WSboat

    @wsboat

    Viewing 15 replies - 91 through 105 (of 133 total)
    Author
    Replies
    • in reply to: data summary: week,month,year (microsoft xp) #880028

      hi all, hi Steve, hi anyone, i got the Excel list of Date, Net P/L and Total Turnround. as usual, the Date and Net P/L is done but total turnround left out. just Total Turnround sit besides Net P/L. can someone tell me which cell to place the Total Turnround item to get that? THANKS A LOT.

    • in reply to: ways to reduce file links memory (office XP) #878418

      hi Pieterse, sorry, maybe i do not understand your instruction on editing my formula. now, i hit F2 at G2 to provoke the formula on G2 out and i press left arrow key to edit my formula, just like from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)) and lastly press Ctrl+Shift+Down Arrow to complete the formula copies to G6000. about named formula to change =SUM((A2),(D2),(F2)) to =TEST, and =TEST appears in G2 until G6000, and when i need to change =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)), do i have to go Insert-Name-Define- select TEST and edit in the Refers to: column from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2))? if that is the case, i will stick to my original way. Thanks again.

    • in reply to: ways to reduce file links memory (office XP) #878419

      hi Pieterse, sorry, maybe i do not understand your instruction on editing my formula. now, i hit F2 at G2 to provoke the formula on G2 out and i press left arrow key to edit my formula, just like from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)) and lastly press Ctrl+Shift+Down Arrow to complete the formula copies to G6000. about named formula to change =SUM((A2),(D2),(F2)) to =TEST, and =TEST appears in G2 until G6000, and when i need to change =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2)), do i have to go Insert-Name-Define- select TEST and edit in the Refers to: column from =SUM((A2),(D2),(F2)) to =SUM((A2),(B2),(F2))? if that is the case, i will stick to my original way. Thanks again.

    • in reply to: ways to reduce file links memory (office XP) #878360

      Hi Pieterse, i think i understand the named formula in that way, but, the first cell formula requires changes in its input, let say in G2, a formula goes =SUM((A2),(D2),(F2)) and i copy the first cell formula to G6000, 5 seconds later, i change the fomula on G2 to =SUM((A2),(B2),(F2)) and copy down to G6000, and 5 seconds later, i change the G2 formula again to do some kind of testing. with this, i think this named formula cannot fit this requirement, can it? either there is a better way to reduce this kind of formula memory or i just fix to this formula and copy to G6000, as original way? THANKS for any help.

    • in reply to: ways to reduce file links memory (office XP) #878361

      Hi Pieterse, i think i understand the named formula in that way, but, the first cell formula requires changes in its input, let say in G2, a formula goes =SUM((A2),(D2),(F2)) and i copy the first cell formula to G6000, 5 seconds later, i change the fomula on G2 to =SUM((A2),(B2),(F2)) and copy down to G6000, and 5 seconds later, i change the G2 formula again to do some kind of testing. with this, i think this named formula cannot fit this requirement, can it? either there is a better way to reduce this kind of formula memory or i just fix to this formula and copy to G6000, as original way? THANKS for any help.

    • in reply to: ways to reduce file links memory (office XP) #878237

      hi Steve, thanks a lot for your advice. about the ‘named formula’, let say i have a formula that inputs are still variable, and the formula need to be copied down, far down to row6000, how am i going to do the ‘named formula’? thanks again.

    • in reply to: ways to reduce file links memory (office XP) #878238

      hi Steve, thanks a lot for your advice. about the ‘named formula’, let say i have a formula that inputs are still variable, and the formula need to be copied down, far down to row6000, how am i going to do the ‘named formula’? thanks again.

    • in reply to: NERO Burning Rom and PC Jam #877010

      hi John, hi jscher2000, i notice my cd-rw written one is 1X-12X and another is 4X-10X Compatible that is why i think the speed defaulted at 12X might be more than the cd-rw expected. somehow, i don’t know how to interpret the both cd-rw speed requirement i mean where should the speed level be for both cd-rw, i have no clue. THANKS.

    • in reply to: NERO Burning Rom and PC Jam #877011

      hi John, hi jscher2000, i notice my cd-rw written one is 1X-12X and another is 4X-10X Compatible that is why i think the speed defaulted at 12X might be more than the cd-rw expected. somehow, i don’t know how to interpret the both cd-rw speed requirement i mean where should the speed level be for both cd-rw, i have no clue. THANKS.

    • in reply to: PC CANNOT START #877004

      hi StuartR, i restart the pc just after the completion of Windows update installation the last i did after i had a good working pc. somehow, i had the pc reformated by pc technician for about USD 2.6 and here in Malaysia it is RM10. i then install my softwares home to save the cost. if not, the reformatting and softwares installation would charge around USD 13 and here in Malaysian Ringgit is RM50. anyway, money is another matter. i want to learn how to reformat the pc? reformat the pc will makes the pc empty, maybe is it called ‘clean’? can you give me the steps to reformat pc or some links to it so that i can have a start? THANK YOU StuartR.

    • in reply to: PC CANNOT START #877005

      hi StuartR, i restart the pc just after the completion of Windows update installation the last i did after i had a good working pc. somehow, i had the pc reformated by pc technician for about USD 2.6 and here in Malaysia it is RM10. i then install my softwares home to save the cost. if not, the reformatting and softwares installation would charge around USD 13 and here in Malaysian Ringgit is RM50. anyway, money is another matter. i want to learn how to reformat the pc? reformat the pc will makes the pc empty, maybe is it called ‘clean’? can you give me the steps to reformat pc or some links to it so that i can have a start? THANK YOU StuartR.

    • in reply to: PC CANNOT START #876831

      hi StuartR, the pc runs like this Start- Startup Recovery Menu- Windows Logo- and a blink of blue screen with some unclear words because the blue screen blinks very fast and then the pc runs to Start- Startup Recovery Menu- Windows Logo- a blink of blue screen with some unclear words- back to Start again and so on the cycle of the pc runs. I tried with Start in Safe Mode, Safe Mode in Networking, Safe Mode with Command Prompt, Last Known good configuration and Starts Window Normally and the pc still runs the cycle above. Any helps clue ? THANKS.

    • in reply to: PC CANNOT START #876832

      hi StuartR, the pc runs like this Start- Startup Recovery Menu- Windows Logo- and a blink of blue screen with some unclear words because the blue screen blinks very fast and then the pc runs to Start- Startup Recovery Menu- Windows Logo- a blink of blue screen with some unclear words- back to Start again and so on the cycle of the pc runs. I tried with Start in Safe Mode, Safe Mode in Networking, Safe Mode with Command Prompt, Last Known good configuration and Starts Window Normally and the pc still runs the cycle above. Any helps clue ? THANKS.

    • in reply to: IFs shortcut (office XP) #876197

      Hi Steve, THANK YOU SO MUCH for all your formulas. Your formula still not get when there is if in row11 all are S you cannot get a S in Target, but I learned a bit about your formula and get it correct: in AK10, the formula is =IF(COUNTIF(A10:U10,”B”)=21,”B”,IF(COUNTIF(A10:U10,”S”)=21,”S”,AK9)) and in AL10 the formula is =IF(AK10=AK9,0,AK10). That

    • in reply to: IFs shortcut (office XP) #876198

      Hi Steve, THANK YOU SO MUCH for all your formulas. Your formula still not get when there is if in row11 all are S you cannot get a S in Target, but I learned a bit about your formula and get it correct: in AK10, the formula is =IF(COUNTIF(A10:U10,”B”)=21,”B”,IF(COUNTIF(A10:U10,”S”)=21,”S”,AK9)) and in AL10 the formula is =IF(AK10=AK9,0,AK10). That

    Viewing 15 replies - 91 through 105 (of 133 total)