One of the simplest piece of code, to help a colleague from a non IT department. Excel VBA hash count to show duplicates. Their management instructed them to use a copy/paste nested formula trick which was exponentially slower. It was 1 second now. Turned her week of dread (thousands of rows) into 1h of simple work. 8 Lines of code, 6 minutes.