Posts Tagged ‘Excel’

Excel Hints: Duplicated Entries

Monday, December 1st, 2008

Radio needed a hand with something the other day. She’d been battling with it long hand for months. I solved the issue in about ten seconds, so I promised her I’d blog about it so she could see how the solution came so easily.

Her problem was that she had about 11,000 data entries. The problem for her was that she knew that a lot (in fact all) of these were duplicates. What she needed to find out was how many unique entries there were in that list of data.

(more…)