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?
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