| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill - Excel
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
Create a custom list first (toolsoptionscustom lists), then copy down and
autofill, then you might want to delete the list when you are done -- Regards, Peo Sjoblom "Chris" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
=A1&B1
"Chris" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
Doh! I misunderstood the OP
-- Regards, Peo Sjoblom "DJ Pomeroy" wrote in message ... =A1&B1 "Chris" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
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. "Peo Sjoblom" wrote: Doh! I misunderstood the OP -- Regards, Peo Sjoblom "DJ Pomeroy" wrote in message ... =A1&B1 "Chris" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
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 "Chris" wrote in message ... 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. "Peo Sjoblom" wrote: Doh! I misunderstood the OP -- Regards, Peo Sjoblom "DJ Pomeroy" wrote in message ... =A1&B1 "Chris" wrote in message ... 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
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. "Chris" wrote: 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. "Peo Sjoblom" wrote: Doh! I misunderstood the OP -- Regards, Peo Sjoblom "DJ Pomeroy" wrote in message ... =A1&B1 "Chris" wrote in message ... 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill - Excel
Try this:
=IF(A1<"",A1&CHAR(64+COUNTIF($A$1:A1,A1)),"") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Chris" wrote in message ... 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. "Peo Sjoblom" wrote: Doh! I misunderstood the OP -- Regards, Peo Sjoblom "DJ Pomeroy" wrote in message ... =A1&B1 "Chris" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get excel to autofill the next column? | Excel Discussion (Misc queries) | |||
| How do you make the little autofill box in Excel go away? | Excel Discussion (Misc queries) | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Need help with excel autofill VBA style | New Users to Excel | |||
| Excel 2002 autofill and offset | Excel Worksheet Functions | |||
Hybrid Mode
