MacMost: Numbers

How To Convert Words and Names To Values in Numbers With IF, SWITCH and LOOKUP
If you have names, product IDs or some other words and need to translate those to number values you can do it with the IF, IFS, SWITCH or LOOKUP functions in Numbers. While the first functions are good for small limited lists of values, only the LOOKUP function works well with a large list that changes often.
10 Useful Mac Numbers Templates
Numbers comes with a variety of useful templates. You can use these in your daily life, or dissect them to learn how they work and learn some spreadsheet skills.
How To Use Autofill In Mac Numbers
You can autofill cells in Numbers using copy and paste, a special autofill feature, and by simply adding new rows to a well-formed table. With the autofill feature, you can have values increase by 1, or using a pattern.
Calculating Difficult Dates In Mac Numbers

Learn how to calculate dates like the first or last day of a month, the first or last day-of-week of a month, or the nth day-of-week of a month.

Mac Numbers Conditional Highlighting and Alternatives
You can use Conditional Highlighting in Numbers to make values stand out. You can also use alternatives like formulas in other columns or custom formats. Also learn how to have cells highlight based on the value of a different cell.
Learn How To Use Pivot Tables In Numbers By Example
If Pivot Tables in Numbers seem intimidating, watch this tutorial to see how easy they are to use. You can get a lot of information without ever needing to using functions or formulas.
Printing Labels Using Mac Pages
You can easily create a simple labels template to print a list of addresses to labels in Pages. The list can come from text or a Number spreadsheet. You can also modify pre-made labels templates to work better.
Calculating Rank In Mac Numbers
If you need to find the ranking of rows in Numbers, you can sort, use COUNTIF or use RANK. It gets a little more complex if you have to use multiple values for tie-breakers or rank within groups.
5 Ways To Generate Random Numbers On Your Mac
Learn how to get random numbers on your Mac using the Calculator app, the Numbers app, Siri, the Terminal and a custom Shortcut.
Quick Calculations In Mac Numbers
You can get the sum, average and perform other calculations on selected cells without needing to create a formula in another cell. The Quick Calculations appear at the bottom of the Numbers window whenever you have more than one cell selected. They also can be dragged-and-dropped to create permanent formulas and will obey filters.
Using Shortcuts To Add Data To a Numbers Spreadsheet
A new action in Shortcuts for Mac allows you to add a row of data to a Numbers spreadsheet. You can prompt for information and then record a time and some data. Numbers version 12 is required. An older technique allows you to change existing data in a Numbers spreadsheet.
Designing Better Numbers Spreadsheets With Text And Shapes
Creating good spreadsheets isn't just about getting the formulas right. By adding some text and design elements you can make it clear to someone else, or yourself in the future, what to do to use the spreadsheet and understand how it works.
An Introduction To Using Formulas In Mac Numbers
Learn the basics of using formulas to perform calculations in the Numbers spreadsheet app. You can perform basic arithmetic, copy and paste formulas to multiple rows, and use functions to get the sum of a column.
How To Track Crypto and More In Numbers and Stocks On a Mac
You can track things like cryptocurrencies, metals, commodities, market funds and other things in the macOS Stocks app and in Numbers. The trick is to realize that the values come from Yahoo Finance and to use the same symbols.
Calculations With Time and Duration Values In Numbers
Dates, times and duration values behave differently in Numbers and other spreadsheet apps than other values. Learn what makes up time and duration values and how to use them in formulas and functions.
Find the Difference Between Two Tables In Mac Numbers
Here's how to compare two tables to see which rows are missing from one or the other. You can also compare two tables using multiple columns. Conditional highlighting can show you which rows don't match.
6 Ways To Sort a List On a Mac
If you have a list of items you need to sort, you can do it using what you have on your Mac or some free apps. Learn how to sort in Pages, Numbers, the Terminal, VIM, CotEditor and using a Shortcut.
Functions For Working With Text In Mac Numbers
Learn how to test and manipulate text in cells in Mac Numbers. You can search for characters, replace them, grab parts of text and more.
Creating Map Charts In Mac Numbers
Sometimes it is useful to have bar charts where each bar is placed at a spot on a map or graphic. You can do that in Numbers, even though there is no special chart type for it. You just need to get creative.
Mac Numbers: New Filter Options
Numbers version 11.2 adds the ability to filter by unique values, fin duplicates and distinct values. Quick filters are also improved with a more comprehensive checkbox system. Learn how to search for duplicates that include several columns with a function.