Spreadsheet tip: “is not” or “is not equal to”

If you are looking to set up a condition in a spreadsheet function in a situation where you want to include everything but one thing, you need to use the following:

"<>EXCLUDED_TERM"

Turns out the “less-than/greater-than” combo sign means “not equal to”, and it applies to text strings in addition to number strings.

I wasn’t sure what terms to search for initially, and relevant results for “is not”, and “is not equal to” were not giving me the answer I needed. Including terms such as “spreadsheet”, “Apple Numbers”, “function” and “formula” didn’t help either.

Continue reading “Spreadsheet tip: “is not” or “is not equal to””

Advertisements

Alphabetical Keyboard Characters in OS X

mac-os-x-finder-keyboard-character-file-name-sorting

If you, like me, use the weird symbols on your keyboard to help you sort files in the Finder, then you’ll be happy to find that I went through the trouble of not only naming a folder full of folders with top-row keyboard characters so you can see exactly how they sort, and then naming those folders so you know what key commands will produce them, but I also made it downloadable so you can just use it yourself. I put this folder on my Desktop for quick reference.

See here for a web table for every last keyboard character in alphabetical order.

Enjoy.

Secure Input & Photoshop’s Hand Tool Spacebar Shortcut

If you are a fellow Photoshop user, and have experienced an unexplained loss of accessing the Hand tool using the spacebar keyboard shortcut, this  may have been caused if you are running password manager software 1Password and have used the “Hide” menu option.

I would have never found this had it not been for the warning on TextExpander‘s menubar icon, and the resulting blog post they published regarding TextExpander and Secure Input.

Quitting 1Password and relaunching it fixed the issue for me, so I can only assume it was indeed the culprit.

Continue reading “Secure Input & Photoshop’s Hand Tool Spacebar Shortcut”

1Keyboard: Type on your iPhone or iPad with yourMac

1Keyboard is a virtual bluetooth keyboard application for Mac OS X that allows you to wirelessly connect to Bluetooth enabled devices such as your iPhone, iPad and Apple TV. It does not require a wireless Bluetooth keyboard. Works great. It went from free to being a paid app since I tried it out. There’s a free demo that lasts for 2 days so you can give it a whirl.

Assign a Keyboard Shortcut to Move Messages to a Folder in Apple Mail

Here’s a great tip on how to assign a keyboard shortcut to move messages to a folder in Apple Mail. In short, you use the Applications Shortcuts found within System Preferences > Keyboard > Keyboard Shortcuts to assign a keyboard shortcut to a specific folder in Apple Mail. Similar to my tip on a global keyboard shortcut for creating a new email message in Apple Mail.

Continue reading “Assign a Keyboard Shortcut to Move Messages to a Folder in Apple Mail”