Skip to content

Swiss Army Spreadsheets

How to do just about anything with software you already have

  • Home
  • About
  • All
  • Author
  • Presentations and Publications
  • Welcome to Swiss Army Spreadsheets

Month: May 2013

Removing duplicates from a list

May 26, 2013 gexner

Sometimes you have a long list of repeated items, and you just want one of each. Or possibly you have a long list of items that are supposed to be unique, and you want to make sure they are. Here’s… Read moreRemoving duplicates from a list

Combining data sets

May 19, 2013 gexner

Recently at work we ran into a situation where my coworker had extracted the names of all of the current members from a spreadsheet, and asigned access codes to them. Afterwards, we realized that we also needed the email addresses,… Read moreCombining data sets

The IF function (about)

May 12, 2013 gexner

If. If you’re going to the grocery store anyway, then could you pick up milk? If I pay $1 extra every month, then my loan will be paid off a month early. If you finish your vegetables, then you can… Read moreThe IF function (about)

Boolean operator functions: AND, OR, NOT

May 5, 2013 gexner

Last week when I was discussing the conditional formatting I did to highlight problem cases, I said I checked two things for the same condition. However, you can only enter one formula. So how did I do it? I combined… Read moreBoolean operator functions: AND, OR, NOT

Recent Posts

  • Working with big data sets: using different functions
  • Working with big data sets: streamlining formulas
  • How big is big?
  • The same but different: conditional formatting in adjacent cells
  • Identifying opening and closing tags

Archives

  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Categories

  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2025 All rights reserved
Proudly powered by WordPress | Theme: Simple Life by Nilambar.
Go to top