So I have been working on a sheet (multiple sheets actually) and was just thrown a curve. I currently have a list where users selection a city and the data populates (formula below). Pretty straight forward though I am sure there is an easier way. I was asked to create this list based so it displays either the data base on a city selected or a region now.
I am at a loss on how to condition this formula so it will display all the data for the city if a city is selected or to display all the data for the region which would include multiple cities.
=IF(ISERROR(INDEX('Shelter Data'!$A$6:$H$262,MATCH(0,COUNTIF($A$6:$A6,'Shelter Data'!$A$6:$A$262)+('Shelter Data'!$C$6:$C$262<>$C$3),0),COLUMN(A5)))," ",(INDEX('Shelter Data'!$A$6:$H$262,MATCH(0,COUNTIF($A$6:$A6,'Shelter Data'!$A$6:$A$262)+('Shelter Data'!$C$6:$C$262<>$C$3),0),COLUMN(A5))))
I am at a loss on how to condition this formula so it will display all the data for the city if a city is selected or to display all the data for the region which would include multiple cities.
=IF(ISERROR(INDEX('Shelter Data'!$A$6:$H$262,MATCH(0,COUNTIF($A$6:$A6,'Shelter Data'!$A$6:$A$262)+('Shelter Data'!$C$6:$C$262<>$C$3),0),COLUMN(A5)))," ",(INDEX('Shelter Data'!$A$6:$H$262,MATCH(0,COUNTIF($A$6:$A6,'Shelter Data'!$A$6:$A$262)+('Shelter Data'!$C$6:$C$262<>$C$3),0),COLUMN(A5))))