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

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

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)

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