Excel: Ambiguous Data

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: How will Flash Fill get this right? Even I wouldn't know what to fill in next?

Strategy: Before invoking Flash Fill with Ctrl+E, provide enough examples to establish the pattern. If you invoke Flash Fill from B3, you will get the prefix instead of the suffix. By filling in one more example and running Flash Fill from I4, you will get the suffix.

  1. Give Flash Fill enough examples.