Autofill: can it detect change in value?

[Margie]

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

 

[Jacob Skaria]

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

 

[Dave Peterson]

Debra Dalgleish shares a few techniques here (manual and macro):

http://contextures.com/xlDataEntry02.html
and a video
http://www.contextures.com/xlVideos01.html#FillBlanks

 

[Margie]

Worked like a charm! Thanks.

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