Excel Tips & Tricks

Get all unique values in a column

Build a list of all unique values in a column.

For example getting the unique shifts listed in a shift column.

Getting total bill rate for “Shift”

This trick uses the SUMIFS function to total up the billed total column on our labor log (Gantry) sheet.

However it has an added trick. It will only sum the value if the new shift column on the same labor log sheet (Gantry) matches the shift.

This ends up getting a total billed where the shift column = A, B, C, D, etc.