Navigation

    Links

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    1. Home
    2. Matt
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Groups

    Matt

    @Matt

    382
    Posts
    626
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    Matt Follow
    Matt's Group-6 PrivilegedUser's Group-1 Matt's Group-3 Matt's Group-2 Matt's Group-5 Matt's Group-4 Matt's Group-1

    Posts made by Matt

    • RE: How to...

      How to get comment balloons to reappear in the margins of a MS Word document:

      • Review>Show Comments>List

      Then:

      • Review>Show Markup>Balloons>Show All Revisions Inline
      posted in Matt
      Matt
    • RE: How to...

      How to enable root access in WinSCP:

      • Advanced>SFTP>SFTP server:
      sudo /usr/lib/openssh/sftp-server
      
      posted in Matt
      Matt
    • RE: How to...

      How to withdraw money from a Commonwealth Bank ATM using your phone and the CommBank App.

      1. On the ATM screen, select “Cardless Cash”

      2. In the CommBank app go to 'Pay' > 'Cardless Withdrawal & Deposit ".

      3. Using your phone, scan the QR code on the ATM screen.

      posted in Matt
      Matt
    • RE: How to...

      How to search for a file on linux and suppress error messages and stop once the first instance is found:

      find /home/files -xdev -type f -name 'P13.txt' -print -quit 2>/dev/null
      
      
      posted in Matt
      Matt
    • RE: How to...

      How to show fold changes in an excel spreadsheet when there are 0 values in the denominator. In the example below P30 is the numerator and P2 is the denominator. The logic is:

      1. Both numerator and denominator = 0 → output 0.00

      2. Denominator = 0, numerator ≠ 0 → output >{numerator} (2 decimals)

      3. Numerator = 0, denominator ≠ 0 → output <{denominator} (2 decimals)

      4. Otherwise → output normal division with 2 decimals.

      =IF(AND(P30=0,P2=0),"0.00",
         IF(P2=0,">"&TEXT(P30,"0.00"),
            IF(P30=0,"<"&TEXT(P2,"0.00"),
               TEXT(P30/P2,"0.00"))))
      
      posted in Matt
      Matt
    • RE: How to...

      How to apply for a Visa on Arrival for Indonesia online before you travel:

      A Visa on Arrival (VOA) is available for passport holders in many countries including Australia. It costs US$35 (A$50) and is valid for 30 days. Follow the link below to apply.

      https://evisa.imigrasi.go.id/

      posted in Matt
      Matt