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 ...
Let's say the list is on a sheet called Master List in columns A to T, with the Categories are in column C.
Create a new sheet.
Enter the following formula in A1:
=VSTACK('Master List'!A1:T1, FILTER('Master List'!A:T, 'Master List'!C:C="First Category"))
where First Category is one of the five categories.
The formula will automatically spill to as many rows as needed.
Repeat for the other four categories.
- 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.
- Thanks so much! This is the formula I typed based on my sheets names:
=VSTACK('Master Donors List'!A1:T1,FILTER('Master Donors List'!A:T, 'Master Donors List'!C:C="Current"))
I got back a #Calc! error
Question 1: Does it matter that I have hidden columns
Question 2: Once it is working, how can I apply it to any new rows entered on the Master list?
