Autofill - Excel

[Guest]

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.

 

[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

 

[DJ Pomeroy]

=A1&B1

 

[Peo Sjoblom]

Doh! I misunderstood the OP

 

[Guest]

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.

 

[Guest]

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.

 

[Ragdyer]

Try this:

=IF(A1<>"",A1&CHAR(64+COUNTIF($A$1:A1,A1)),"")