PJ & STP

STP

Sounds of the 90s

Live x Alanis

Get Value of Last Non-empty Cell in a Column in Spreadsheets

Let’s say you have a spreadsheet with dynamically growing row numbers. This is a simple formula to get the last non-empty cell in a column. Microsoft Excel & LibreOffice Calc:  Google Sheets:  Apple Numbers:  In this instance, you want the last value in column A.

Publisher Alternatives for macOS

There are those who migrate from Windows to Mac, and are looking for an equivalent application to Microsoft Publisher. Then someone answered, “Use Apple Pages.” Pages is actually the equivalent of Microsoft Word (word processor). But after trying it, it’s true, you can make lightweight DTP (desktop publishing) that is equivalent to Publisher, even quite close […]

Excel Alternatives Problem

I’m currently trying alternative spreadsheet applications to Microsoft Excel. It turns out that LibreOffice Calc, Google Sheets and Apple Numbers do not yet support some advanced formulas. Maybe you can get around it with another set of formulas, but it won’t be practical.

CDBS Radio Action

CDBS Radio Action 94.5 FM (Bali)

Ziggy Tribute to Sting and the Police