I have 2 formulas, i get Spill error
1. I need to return a date from a column if empty go to the other this within a range of data
=IF('Merged!A:A=A3, Min('Merged'!L:L, Merged'!J:J, "")
2. I want to calculate the median for a range
=IF('Merged!A:A=A3, Median('Merged'!P:P), "")
Thanks in advance.
Sorry i am not able to add sheets in my post
1. I need to return a date from a column if empty go to the other this within a range of data
=IF('Merged!A:A=A3, Min('Merged'!L:L, Merged'!J:J, "")
2. I want to calculate the median for a range
=IF('Merged!A:A=A3, Median('Merged'!P:P), "")
Thanks in advance.
Sorry i am not able to add sheets in my post