Forum Discussion
qazzzlyt
Jan 06, 2022Brass Contributor
Excel formula fill range formula with dynamic result
A1 has formula ={"dog","cat"}, which filled B1 with "cat". In A3 the formula is =CHOOSE({1,2},A1,B1), and it worked. My goal is to fill multiple cells with one cell and need dynamic result....
SergeiBaklan
Jan 06, 2022Diamond Contributor
qazzzlyt
Jan 06, 2022Brass Contributor
Oh thanks again Sergei. How about if A1 and B1 are not in a spilled range?
- SergeiBaklanJan 06, 2022Diamond Contributor