Forum Discussion
Using if statement
Hi, I'm really new to xl... I have a Master List with a "Category" column with 5 different categories. I want each category to automatically populate its own worksheet. And it needs to be dynamic ...
And it's highlighting the 2 inside brackets in red
The formula should work if you have Microsoft 365 (and in Excel Online). It won't work in older versions.
The formula shoild automatically "spill" to as many rows as needed, accommodating new and deleted rows.
I created a small demo workbook and pasted your formula. It didn't return an error. See the attached file.