SOLVED

autofilling from multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1569647%22%20slang%3D%22en-US%22%3Eautofilling%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569647%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%20I'm%20new%20to%20this%20community%2C%20and%20have%20very%20little%20training%20with%20Excel.%26nbsp%3B%20I%20pulled%20a%20report%20with%20data%20in%20about%206%20columns.%26nbsp%3B%20I'm%20trying%20to%20generate%20passwords%20for%20students%20in%20a%207th%20column%20that%20is%20based%20on%20information%20in%202%20existing%20columns.%26nbsp%3B%20I've%20done%20this%20before%2C%20and%20after%20about%205-6%20manual%20entries%2C%20Excel%20figured%20out%20what%20I%20was%20doing%20and%20autofilled%20the%20rest%20for%20me.%26nbsp%3B%20It's%20not%20working%20now%20though!%26nbsp%3B%20Any%20ideas%20what%20I%20can%20try%3F%26nbsp%3B%20I%20have%20one%20column%20with%20student%20birthdays%20in%20number%20format%20(mo%2Fday%2F%20year)%20and%20then%209%20digit%20student%20IDs%20in%20another%20column.%26nbsp%3B%20I%20need%208%20digit%20passwords%20with%20the%20birth%20month%2C%20birth%20date%2C%20and%20last%20four%20digits%20of%20the%20student%20ID.%26nbsp%3B%20I%20hope%20this%20makes%20sense%2C%20and%20I%20hope%20someone%20can%20help!%26nbsp%3B%20I%20don't%20want%20to%20do%20600%20manual%20entries!%26nbsp%3B%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1569647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569824%22%20slang%3D%22en-US%22%3ERe%3A%20autofilling%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750916%22%20target%3D%22_blank%22%3E%40Monyca%3C%2FA%3E%26nbsp%3BFor%20some%20reason%2C%20the%20Flash%20Fill%20feature%20doesn't%20recognise%20the%20pattern%20you%20are%20trying%20to%20create.%20Difficult%20to%20judge%20why%20without%20seeing%20your%20real%20data.%20But%2C%20since%20you%20already%20know%20exactly%20how%20you%20want%20to%20build%20the%20passwords%2C%20you%20could%20use%20a%20formula.%20Assume%20column%20A%20holds%20the%20dates%20(in%20date%20format%20mm%2Fdd%2Fyyyy)%20and%20column%20B%20holds%20the%20Student%20IDs%2C%20with%20a%20header%20on%20the%20first%20row.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTEXT(A2%2C%22mmdd%22)%26amp%3BRIGHT(B2%2C4)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EEnter%20the%20above%20in%20G2%20(your%207th%20column)%20and%20copy%20it%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570240%22%20slang%3D%22en-US%22%3ERe%3A%20autofilling%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570240%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750916%22%20target%3D%22_blank%22%3E%40Monyca%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20I'd%20don't%20trust%20to%20FlashFill%20except%20quite%20simple%20cases%2C%20you%20always%20have%20to%20recheck%20if%20it%20works%20correctly%20or%20not.%20Formula%20is%20much%20more%20reliable%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573613%22%20slang%3D%22en-US%22%3ERe%3A%20autofilling%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573613%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello!  I'm new to this community, and have very little training with Excel.  I pulled a report with data in about 6 columns.  I'm trying to generate passwords for students in a 7th column that is based on information in 2 existing columns.  I've done this before, and after about 5-6 manual entries, Excel figured out what I was doing and autofilled the rest for me.  It's not working now though!  Any ideas what I can try?  I have one column with student birthdays in number format (mo/day/ year) and then 9 digit student IDs in another column.  I need 8 digit passwords with the birth month, birth date, and last four digits of the student ID.  I hope this makes sense, and I hope someone can help!  I don't want to do 600 manual entries!  Thanks in advance!

3 Replies
Highlighted
Best Response confirmed by Monyca (New Contributor)
Solution

@Monyca For some reason, the Flash Fill feature doesn't recognise the pattern you are trying to create. Difficult to judge why without seeing your real data. But, since you already know exactly how you want to build the passwords, you could use a formula. Assume column A holds the dates (in date format mm/dd/yyyy) and column B holds the Student IDs, with a header on the first row.

=TEXT(A2,"mmdd")&RIGHT(B2,4)

Enter the above in G2 (your 7th column) and copy it down.

 

Highlighted

@Monyca 

In general I'd don't trust to FlashFill except quite simple cases, you always have to recheck if it works correctly or not. Formula is much more reliable way.

Highlighted
Thank you!