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 Let's begin be determining which one of the two solutions in the attached workbook work for you. If it's the dynamic array formula with the FILTER function, your'e lucky as it is very easy to apply. If not, then perhaps a combination of the INDEX, SMALL and IF functions might work.
- I attempted using the FILTER formula and I received the error #SPILL! I guess the FILTER formula on its own though will not work for me since it wants to return all data not just a single piece, right? This is why you mention using dynamic array formula?
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!