Forum Discussion
=filter function
Hey I need to create a spreadsheet of reviews for a project I'm working on. I have a library of reviews sorted into 4 columns of product code, star rating, name and review. I have a separate workbook...
liamgoodmancc Well, the FILTER function you wrote could work. Though, it's difficult to say why it doesn't give the desired result if you don't upload an example of your file with the incorrect result and explaining why and what's expected.
Be aware that the FILTER function tries to output an entire array in one go. If anything gets in the way, you'll get #SPILL!. So NEVER copy down or across a formula with dynamic array functions as it will obstruct itself and produce the #SPILL! error.