Autofill: can it detect change in value?

M

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
 
J

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
 
M

Margie

Worked like a charm! Thanks.

Jacob Skaria said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top