Consider also perhaps a Pivot Table. It's the easiest way to get unique list of vendors and corresponding counts in one shot.