Pages tagged “cleanup”

6 pages in Cellwise.

1. Count unique values in Excel and Google Sheets

   Count distinct values with UNIQUE, or with a helper column in older Excel.

   unique count cleanup

2. Count with several conditions, including blanks

   COUNTIFS with text, blank and number conditions together.

   countifs cleanup

3. Extract the domain from an email and a trailing number from text

   Two text formulas: the domain after the @, and a number at the end of a cell.

   text cleanup email

4. Find duplicates on two columns and across sheets

   Flag rows that repeat on two columns, or that already appear on another sheet or list.

   duplicates countifs cleanup

5. Remove duplicates but keep the latest row

   Flag the newest row per name as keep and the older ones as dup, then filter.

   duplicates cleanup maxifs

6. Split first and last name in one cell

   Formulas that take the first and last word from a full name, including a middle name.

   text cleanup names

All pages