Marv1n
asked on
Filling a range in Excel
Guys,
In an excel file, I have data arranged as seen in the attached file. I need to fill the value in Column A down to match where column B is populated until a new value occurs in Column A. Then I need to use the next value in Column A and continue down until there's another new value in A.
In the attached, I'd fill "Air/Auto DC to AC Adapter" from Column A down from row 3 to row 18, then fill "Air/Auto DC to AC Inverter" from row 20 until another value is present.
Can someone point me in the right direction?
Thanks,
Brian
Fill-Example.xlsx
In an excel file, I have data arranged as seen in the attached file. I need to fill the value in Column A down to match where column B is populated until a new value occurs in Column A. Then I need to use the next value in Column A and continue down until there's another new value in A.
In the attached, I'd fill "Air/Auto DC to AC Adapter" from Column A down from row 3 to row 18, then fill "Air/Auto DC to AC Inverter" from row 20 until another value is present.
Can someone point me in the right direction?
Thanks,
Brian
Fill-Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.