I have a list of property address. I have a master list of restrictions. Not every property has the same restrictions. AND, if they have a restriction, they may or may not be in compliance with that restriction.
I need to be able to show how many have certain restrictions and if they are in compliance with their restrictions. I'm struggling with how to set the data up, multiple rows or mutliple columns or "countif".
I need to be able to show how many have certain restrictions and if they are in compliance with their restrictions. I'm struggling with how to set the data up, multiple rows or mutliple columns or "countif".