I am attempting to use Google Sheets as a scheduler of sorts for some rooms. A1:A4 is a list of room names.
B1:B4 is using this formula =IF(COUNTIF($H$4:$H$6,A1)>=1,"",ROW()) Where the H values are where I want the dropdown to limit if a selection is used.
C1:C4 is using this formula that should remove the options used from the next section of the drop down. =IF(ROW(A1)-ROW(A$1)+1>COUNT(B$1:B$4),"",INDEX(A$1:A$4,SMALL(B$1:B$4,1+ROW(A1)-ROW(A$1))))
This section is working as desired, though when I attempt to use the formula in another section that is not A1, B1, C1, etc I am getting the parameter is out of range.
I am not super savvy in this but attempting to learn.
How would I use the above formulas in any section of the spreadsheet with out this error?
Here is the link to the spreadsheet: https://docs.google.com/spreadsheets/d/1WT_Um6ro1djhKxCdjWqrbXW9tY1E7E4DUzyE58GG_Uw/edit?usp=sharing
Thanks in advanced. Nick