Forum Discussion
Formula Help
In sheet Lists in the attached file you can enter your priorities as shown in range C4:C20. The formula in the attached file displays the data ordered according to the values of range C4:C20.
If i do this in the sample file the formula dynamically updates the results in the Vacant Rooms sheet. In the ALL sheet i've added column F with some sample data.
I intentionally created a #SPILL! error in cell A2 as you can see in the screenshot below (#ÜBERLAUF! in german Excel).
The reason for the #SPILL! error is that there is another formula in cell A3 as you can see in the screenshot below.
The spilled results of these formulas overlap and therefore return a #SPILL! error. You can delete any of these formulas to remove the error.
In the attached file i've added the DOR column F in the ALL! sheet.
Hello Sir,
Question? Yesterday my sheet worked super fine. Today, I'm getting #SPILL! in cell A2. I don't recall doing anything that would have caused this. The only thing I did was changed the Sheet name to "Occ Status By Status Code". Did this do something that needs changing somewhere else? I also added the DOR column for which I understand you accounted for this in your formula.
Would you please assist me in getting this working again.
Thank you,
Otherwise, this solution is working great.
Carl