Autofill - Excel

C

Chris

I want to use the autofill feature to complete column B (which is currently
null) so I can then concatenate Columns A&B to make unique values (see
result).

Column A Column B Result
C100 A C100A
C100 B C100B
C100 C C100C
C203 A C203A
C203 B C203B
C304 A C304A
C304 B C304B
C304 C C304C

Is anyone able to assist?
Thanks.
 
P

Peo Sjoblom

Create a custom list first (tools>options>custom lists), then copy down and
autofill, then you might want to delete the list when you are done
 
C

Chris

Thanks - I'm confortable with concatenating for Column C - my question was
regarding autofil for Column B; starting over at A when the value in Column A
changed to a different one. Your first suggestion was to create a custom list
- how does it know when to start over again.
 
P

Peo Sjoblom

So I was close after all If your data goes like

A
B
C
A
B

then starts with ABC again? Import the above (or type it) into the custom
lists
then it will repeat like

A
B
C
A
B
A
B
C
A
B


and so on, note that it would be a good idea to delete the custom list after
you have finished since it is so easy to apply if you need to do it again


--
Regards,

Peo Sjoblom
 
W

William Horton

Copy the below formula in cell B2 (assuming that's where your column starts).
Then copy it down to all necessary rows. It will # each item. However,
your list does need to be sorted by the values in column A for this to work.

=IF(A2=A1,B1+1,1)

Hope that helps.
 

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