Related Posts
Any insight on LinkedIn and contract roles?
Dm if you are interested for a job at Deloitte 😊
Additional Posts in Excel Genius
What are the most typical models you all build
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
New to Fishbowl?
unlock all discussions on Fishbowl.
Mentor
If I understood your dilemma correctly... you have to highlight multiple cells that introduce the sequential pattern.
For example, if you want consecutive numbers, highlight "1" and "2" and dragging down will activate the flash fill functionality in Excel.
Figures it out tried that...apparently there’s a glitch need to filter and unfilter and it works....