Category: Excel
-
Excel Sort Dates by Month and Day
Today I have been given the task of sorting a spreadsheet with about 20,000 rows by birthdate or anniversary. The sort needs to be by month and day, ignoring the year for CRM. The simple formula I used was TEXT(CELL,”mm/dd”). The problem was that many (thousands) of the dates were in unrecognizable formats such as…
-
Excel Combine Duplicate Rows
I have a need to look for duplicate entries in an Excel worksheet and delete the ones with outdated or incomplete data. This has proven to be a bit more difficult than I thought it would be. I will be working on a better solution for this based on demand. The AbleBits add on did…