Fill Down .. with a twist

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know I've done this before.. but for the life of me I can't figure out how.

I need to fill down on a column, however, the value changes every 4th
column.
Example:
Smith 1
2
3
4
Jones 1
2
3
4

And I need it to read

Smith 1
Smith 2
Smith 3
Smith 4
Jones 1
Jones 2
Jones 3
Jones 4

I recall a quick fill method... one of those fuzzy recollections at the
edge of my brain.. but I just can't grasp what it was? Can anyone help?

Thanks!
 
Hi,

select the range on the A column, press F5, special select in blank cells
only,
in a2 type =a1 and press CTRL+Enter

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"mmb" escreveu:
 

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

Similar Threads

How to get totals 4
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Inserting rows and rearranging data using VBA 6
Auto-Alphabetize 1
Counting Criteria Values with For Loop 3
Counting text and dates 1
Need help with SUMPRODUCT Formula 10
Transpose large column 3

Back
Top