To learn more about using Flash Fill, read 6 ways to save time using Flash Fill in Microsoft Excel. Figure B Sometimes you won’t want a match. Instead, you’ll want to see a unique list.

If you find entering data into spreadsheets to be mind-numbing drudgery, then you probably don't know about these cool, time-saving tricks that make Excel 2010 do the heavy lifting for you.