•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#rows.com
#formula generator
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#margin report
#formula
#locations
#accounts
#column H
#header
#list
#specific accounts
#report
#data extraction
#location recognition