FSA Tip #18 UNIQUE – My Favourite Formula

Often, you wind up with a spreadsheet that is a long list made up of the same things repeated over and over.

This might happen with your harvest records for the season where there there is a row for each crop you harvested from each day you were harvesting.

You might only grow 30-40 crops but by the end of the season your harvest records that are hundreds or thousands of rows long.

It would be nice to get a summary of what is on that list.

This brings us to my favourite formula:


In this tip, we’ll see …

  • How to use the UNIQUE formula to make a summary list of each item that appears in a longer list.
  • How to use the SORT formula to present that list in alphabetical order.
  • How to extend UNIQUE to cover multiple columns

You can get the spreadsheet from this tip to follow along at home.

What is your favourite formula?

Join me next Thursday at 2pm for my next Farmer Spreadsheet Tip on Facebook Live.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s