Candace Hagood
asked on
Excell flash fill based on another column
Good afternoon everyone,
I'm needing to flash fill a group down a column sequentially based on another column. To give an example: Column A has Test codes, column D has questions. I need to populate column C with sequential question numbers 1 - ? for each question in the corresponding test.
Column| A-Test Code | B- Company ID | C - Question Number | D- Question content |
A231 | CompID | 1 | What color is the sky?
A231 | CompID | 2 | How old are you?
A231 | CompID | 3 | what is the atomic pass of silver?
A985 | COmpID | 1 | What is the name of your favorite teacher?
A985 | CompID | 2 |How many kids did the Brady bunch have?
But instead i have like 12K lines and dont want to go through numbering all of column c based on column A. Any options? Thank you!!
I'm needing to flash fill a group down a column sequentially based on another column. To give an example: Column A has Test codes, column D has questions. I need to populate column C with sequential question numbers 1 - ? for each question in the corresponding test.
Column| A-Test Code | B- Company ID | C - Question Number | D- Question content |
A231 | CompID | 1 | What color is the sky?
A231 | CompID | 2 | How old are you?
A231 | CompID | 3 | what is the atomic pass of silver?
A985 | COmpID | 1 | What is the name of your favorite teacher?
A985 | CompID | 2 |How many kids did the Brady bunch have?
But instead i have like 12K lines and dont want to go through numbering all of column c based on column A. Any options? Thank you!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.