January 31, 2020

How to identify duplicates instantly

I was at this shop queuing to buy face masks. You have to show your ID to buy the face mask. Each customer is only allowed to purchase once due to limited stocks. Without checking through hundreds of records, how could you use Excel to check instantly? This is how I will do it.

    Jason Khoo