Forum Discussion
Solved
autofilling from multiple columns
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 ba...
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.
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.