What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

Recent content by kaytoy

  1. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @windgun1984 Di ko po masyado ma-gets... could you please include(upload) the files that you are trying to say and also give a report file as output format IF POSSIBLE lang po.... Nevertheless i have a suggestion...
  2. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. Suggestion lang not sure kung mag-work Add mo ito sa MACRO mo….. :slap: 1. Clear the Filter 2. Lock the Cell you want to select sample--> ActiveSheet.Range("$A$6:$S$10000").SpecialCells(xlCell TypeVisible).Select...
  3. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @bemadriaga Suggestion: 1. Use Consolidation Function on Excel - See attached Image... 2. Formula Solution ---> =SUMIF($A$3:$A$8,$J3,$B$3:$B$8)+SUMIF($D$3:$D$8,$J3,$E$3:$E$8)+SUMIF($G$3:$G$8,$J3,$H$3:$H$8) Pls...
  4. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel reportings, presentations, and vba helping thre @CHOT07 Suggestion ko use 1. Text to Column Function pero ma prob lang konti parang formula din na gawa mo.. 2. Flash Fill Feature- Please See Image Uploaded.. btw i am using Excel 2013 - Type2x ka lang then Excel will...
  5. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @kensh80 Gamit ka lang VLOOKUP function ---> =VLOOKUP($E3,'Sheet2 (2)'!$B$7:$E$37,3,1) Revised ko lang konti para walang N/A na lalabas ---> =IF(ISERROR(VLOOKUP($E4,'Sheet2...
  6. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @albert diko masyado ma-gets... but i suggest you RECORD your own macro according to your specifications.. it would be not that hard i suppose... Recording Macro on Excel Video Link -...
  7. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @berylx diko masyado kabisado yang offset na function... sinubukan ko lang po i hope tama ang ginawa kong bagong poormula. Pls. See attached File... ..hope it helps™
  8. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @kurapikot parang mahirap ata ma-open ang EXCEL file na may password... na-try ko na yan last time... ang dami kong ginamit para ma-decode lang ang password ng excel pero di ako medyo nahirapan nun ksi ang simple lang...
  9. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @edwardz89 Comment lang po.... - it would be very unlikely that a human could stay in front of a computer for straight 24hrs... :)
  10. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @benteSAiz Save a macro-enabled workbook Follow these steps to save a macro-enabled workbook: Click the Office button and then click Save As. The Save As dialog box appears. Enter a name and select a location for...
  11. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel we give solutions. formula, codes and tutorials. @ ohohOrmhel Math Problem: - Suggestion You must identify how many hours or days you need to finish 1 report per manpower. pagnakuha mo na yun... you may now setup a formula that may satisfy 15 reports in 6 days. Hope it helps ^_^
  12. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel we give solutions. formula, codes and tutorials. Suggestion: Gawa ka new File Ilagay mo lahat ng data sa isang worksheet lang, add ka lang ng isang column for YEAR OR DATE... Convert mo into Table... Then Pivot Table mo na... . that way mas madali ma-sort ang data. Suggestion...
  13. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel we give solutions. formula, codes and tutorials. @nash as per my own understanding, yung fullname nasa isang column lang? then gusto mo ihiwalay ng columns? di na kailangan ng formula.... Gamitin mo lang ung Text to Column na function ng Excel... i hope i got it right... ^_^
  14. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel we give solutions. formula, codes and tutorials. @ ohohOrmhel FORMULA SOLUTION :excited: Used up again a column helper then if & countif functions Then lastly VLookup. See Attached File - - - Updated - - - @Boss Nash I have consulted THE BOSS about ur concern hehe... di...
  15. kaytoy

    true power of MS excel. update: PowerBI

    Re: MS excel we give solutions. formula, codes and tutorials. @Boss Nash Can you post again ur concern with direct to the point instruction.... wag lang masyado mahaba explanation. Show mo Data - then - desired Output then problem encountered.. I will try mo check on it pag-may time...
Back
Top Bottom