Welcome back, Guest!
Register
Forgot your Password?
Page 212 of 223 FirstFirst ... 112162202210211212213214222 ... LastLast
Results 2,111 to 2,120 of 2224
  1. #2111

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    @chester,

    eto na ung workbook, kaso sobrang maselan to sa naming ng worksheet.
    at kasi ung example na pinakita mo puro sa G51:H51 ung closing cash nila,
    ganon ba lagi ung case? or kailangan naten gawing mas dynamic pa ugn formula?


    click here to download


    Goodluck

  2. #2112

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    Sir yung pagmove or copy (move to end), gusto ko sana na yung closing balance ko for yesterday's date ay automatic na syang mag-appear sa opening balance ko for today's date.. Paanu yun sir? Salamat sa tulong sir..

  3. #2113

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    onga yan na yon.

    Step1) copy mo ung worksheet kahapon (ex April 5 ngayon. copy mo ung April 4)
    Step2) then rename mo ung "April 4 (2)" into April 5.
    step3) ganon din sa ibang mga worksheet pa na gagawin mo

    matik nang kukuhanin ng april 5 ung ending cash value dun sa April 4.
    Assuming na nasa G51:H51 cell ung closing cash value. kuha?
    Last edited by romcel11; 8th May 2018 at 14:07.

  4. #2114

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    Quote Originally Posted by romcel11 View Post
    onga yan na yon.

    Step1) copy mo ung worksheet kahapon (ex April 5 ngayon. copy mo ung April 4)
    Step2) then rename mo ung "April 4 (2)" into April 5.
    step3) ganon din sa ibang mga worksheet pa na gagawin mo

    matik nang kukuhanin ng april 5 ung ending cash value dun sa April 4.
    Assuming na nasa G51:H51 cell ung closing cash value. kuha?
    Oo nga sir noh? hehe, now ko lang sinubukan.. Ang galing mo talaga sir.. Maraming salamat sir..
    Anyway sir, pwede ko ba itong idelete yung sinulat mo sa mga cells? Thank you

  5. #2115

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    Oo pero wag ung mga dates at numbers sa tabi ng begining cash for the day.

  6. #2116

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    ah, sige sir.. salamat talaga..

  7. #2117

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    Hi po hihingi lang po ako nang kaunting tulong sa inyo po , hihingi lang mo ako nang idea kung paano sisimulan ang isang fishbone analysis na chart , hindi po kasi ako magaling sa excel at chart pero willing po ako to learn , gagamitin ko lang po ito sa trabaho. Maraming salamat po sa tutulong.

  8. #2118

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    hindi po ok na gamitin ung excel for fishbone analysis eh.
    parang Root-Cause-Analysis din ata tong fishbone.
    pero try po natin gawan ng paraan. upload ka po ng workbook.

    1)dapat merong desired output mo.
    2)optional. meron ka ding desired na way ng pag eencode ng mga analysis.

  9. #2119

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    Quote Originally Posted by romcel11 View Post
    hindi po ok na gamitin ung excel for fishbone analysis eh.
    parang Root-Cause-Analysis din ata tong fishbone.
    pero try po natin gawan ng paraan. upload ka po ng workbook.

    1)dapat merong desired output mo.
    2)optional. meron ka ding desired na way ng pag eencode ng mga analysis.
    pwede yan master.basta di gagamit ng excel provided charts. pwede tayo mag prototyping. pero ang magiging malaking part diyan kasi yung analysis ng gagawa. cons and pros. other than that line shapes nalang yan at text shapes. make sure na complete details na. use paper and ballpen first bago ka gumawa. sure ako. puro hyperlink lang yan for every category.

  10. #2120

    Default Re: MS excel formula, programming, analysis, presentation and tutorials.

    Mga Masters, pa-help ulit

    See attached file. Hindi ko pa kabisado pivoting. Pass muna sa pivot table kung kaya.

    Table A - Lists
    Table B - Un filtered
    Table C - Filtered where column value are greater than 0

    Table A lists same ng Table B at C.

    What if nag lagay ako ng bago at madaming list sa Table A? Kailangan ko ring i-update Table C at i-refilter ulit.
    Need ko ma-update ung Table C ko automatically upon input ko sa Table na uniques values lang kailangan ko?

    TIA
    Attached Files Attached Files
    Last edited by azter; 21st May 2018 at 08:44.

Similar Threads

  1. [HELP] How to Lock MS Excel FORMULA???
    By cley12345 in forum Programming & Web Design
    Replies: 1
    Last Post: 2nd Sep 2013, 20:04
  2. MS Excel and Office (Java)
    By rogerlloydv in forum Legacy Mobile Software
    Replies: 6
    Last Post: 15th Oct 2010, 08:06
  3. [help]MS Excel formula
    By che123 in forum PC Hardware Chat
    Replies: 4
    Last Post: 18th Dec 2009, 19:52

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •