Forum Discussion
Solved
Using array formula to populate data
I’ve tried searching for help on this but everything I find is way more complicated than what I need and I just get lost following along. This is what I’m looking for: If table titled “Applicants...
- I figured it out! Combined it with INDEX to return only the Name column. The spill error was happening because it didn’t like that I was trying to insert into a table which I wasn’t sure how to make that work. I’ll leave that for another day though!
Jbuff26 Actually, that's good news. The spill error means it's working but you have cell occupying the range where the FILTER functions wants to write the results to.
Remove anything that is inside the dashed area that comes up when you select the cell with #SPILL!
I figured it out! Combined it with INDEX to return only the Name column. The spill error was happening because it didn’t like that I was trying to insert into a table which I wasn’t sure how to make that work. I’ll leave that for another day though!