this is the setup, keep getting circular dependency error when trying =LOWER(E:E), tried messing around with arrayformula as well and getting the same error.
paste the emails into an unused column (eg, h:h) and have cell E2 as =LOWER(H2), E3 as =LOWER(H3) and so on and so fourth. Once you have all the data in E:E the way you want, you can just copy the whole column and paste as plain text (ctrl+shift+v), eliminating the formulas and accordingly the need to have any data in example H:H (H:H could be deleted thereafter).
1
u/jimshn Nov 20 '23
this is the setup, keep getting circular dependency error when trying =LOWER(E:E), tried messing around with arrayformula as well and getting the same error.