BillY2305Copper ContributorSep 19, 2024expand a dynamic named range I work in insurance. I am building a template that can work with our customers who have a random number of health plan options (possibly more than one each of: health plan, dental plan, vision plan...Show More
Harun24HRBronze ContributorSep 19, 2024BillY2305 REDUCE() function may give you desired output. See the attached file.=DROP(REDUCE("",InsurancePlan,LAMBDA(a,x,VSTACK(a,HSTACK(EXPAND(x,4,1,x),VSTACK("EO","ESP","ECH","FAM"))))),1) reduce.xlsx10 KB
