Forum Discussion
Formula Spill
I have a formula that keeps on spilling to the remainder of the excel sheet but I don't want it to do that. How can I have the formula stop being a spill formula?
jlopez31 How exactly does your formula look like? Having access to the relatively new dynamic array functions is great. But you may have to adjust your formula by using an @-sign in the right place to avoid spilling.
This is what my formula looks like right now
=IF($F$2:$F$2024=$T$4,LARGE(IF($M$2:$M$95=$S$2,$I$2:$I$95),$Q$4:$Q$8),0)
=IF($F$2:$F$2024=$T$4,LARGE(IF($M$2:$M$95=$S$2,$I$2:$I$95),$Q$4:$Q$8),0)
jlopez31 When I enter that formula in an empty sheet I just get several NUM errors and mostly N/A as you didn't provide the context in which you use the formula. What's in those reference you use?
So, difficult to say without the file on hand, but try this, and copy down as far as needed.
=IF($F$2=$T$4,LARGE(IF($M$2:$M$95=$S$2,$I$2:$I$95),$Q$4),0)Otherwise, you can perhaps share a file via Onedrive or something similar.
- I can share it via onedrive that way you can see what data i'm looking at and what I'm trying to pull