I feel that SWITCH is a cleaner option than a series of IF statements that I have been using.
6 responses on “💬 Use SWITCH Function to Categorise”
I have found a cleaner method for adding in the commas and quotations required for the SWITCH formula: =char(34)&join(""",""",ARRAYFORMULA(QUERY(A1:A,"SELECT A WHERE A IS NOT NULL")&""","""&QUERY(B1:B,"SELECT B WHERE B IS NOT NULL")))&char(34)
I have found a cleaner method for adding in the commas and quotations required for the SWITCH formula:
=char(34)&join(""",""",ARRAYFORMULA(QUERY(A1:A,"SELECT A WHERE A IS NOT NULL")&""","""&QUERY(B1:B,"SELECT B WHERE B IS NOT NULL")))&char(34)