Counting Visible cells in Excel

Today, I created yet another report in Excel. As usual, I had used the Format as a Table command and then filtered out some data. The next step was to count the number of rows that were still visible. I used the formula =SUBTOTAL(3,A2:A144) and had the required information. This website has a good explanation of the process, along with how to count rows that have been manually hidden (instead of filtered).

macOS installer commands

High Sierra

sudo /Applications/Install\ macOS\ High\ Sierra.app/Contents/Resources/createinstallmedia --volume /Volumes/HighSierra

Mojave

sudo /Applications/Install\ macOS\ Mojave.app/Contents/Resources/createinstallmedia --volume /Volumes/Mojave

Source

Vocal warmup

This is intended to be spoken slowly and deliberately:

“Eleven benevolent elephants met Lilly and Lucy in Philadelphia. They went to see Camelot in Unique New York, with guns and drums and drums and guns which they kept in the bodega bodega bodega. They soon came across Brilliant Italian William from Topeka, who merely murmured, ”lilly lally lilly lally.“ Then around the rugged rock the ragged rascal ran, to live among Culligans and Callalillies and let his tone drift off as easily as a sigh.”

Source

Deleting a Profile from iOS

I have seen a few “infected” iOS devices in the past couple of weeks. Yes, for real. After so many years of being nearly bulletproof to normal malware, the iPhones I’ve worked on were compromised by configuration profiles. To remove the proxy or other malicious settings, the profile has to be deleted.

This Apple KB article details how to remove an app that has installed a profile on your iOS device. Since macOS now uses configuration profiles to ease large deployments, so it’s likely this will become a common threat vector on Apple’s desktop and notebook computers.

TL;DR Instructions

  • Go to Settings > General > Device Management, Profile Management, or Profile & Device Management, then tap on the app’s configuration profile.
  • Tap Delete Profile. If asked, enter your device passcode, then tap Delete.

Running PowerShell on macOS

At work, I have to manage several Office 365 tenants. While many tasks can be completed via the GUI, there are times PowerShell commands are required. That is fine on a Windows 10 computer, since PowerShell is part of the operating system.

However, I prefer to use the company’s iMac. While I was working on an issue with one of our clients, I found an article from Microsoft about using homebrew to install a PowerShell module on macOS!

When I started in IT, I don’t think that would have ever happened.