•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula to pull location until next location listed
I have a margin report that has a header and accounts listed for separate locations. I need a formula that will read that first column and recognize the locations ( I can create a list) and list that location for every account until it finds the next location. My goal is something that looks like column H. I need the locations listed in column H so that I can pull specific accounts from the report and know what location it applies to. My screenshot is a shortened and condensed version of this report, but it shows how the location shows once, followed by the accounts, then the report essentially starts over with a new location.
[link] [comments]
Want to read more?
Check out the full article on the original site