Try the below

1. Select the data range in ColA (say A1:A100).
2. Press F5. From 'Goto window'Special from Options select 'Blanks' and
hit OK
3. This will select all blanks.
4. Now press = (equal sign)
5. Then press Up Arrow to reference the cell just above
6. Now press Ctrl and Enter key together

--
Jacob


"Margie" wrote:

Is there a way to autofill down a column, where the autofill detects a new
value and uses that value, until the next time it hits a new value? Simple
example:

I want this: To look like this:

Dave Dave
Dave
Dave
Bill Bill
Bill
John John