Unique city is nothing more than I am looking at the "Jurisdiction" column and I'm creating a column with just unique entries. I did this so that I can then add just items for those unique cities a little easier. It is my way of breaking the problem up into multiple steps.

The reason there are multiple tabs is because each tab represents a different investigator. The person using this spreadsheet goes to each investigator and tracks which cases they are assigned...... which incident types and cities, etc.

I personally think a small Access DB would be better for doing what he is doing but this is what I have to work with at the moment.