I am currently a police officer in the UK and I am trying to device a
spreadsheet / database that will highlight problem hotspots.

Now, I intend to create a spreadsheet that will highlight areas that are
affected by different crime. So, in one sheet I will have burglaries, car
crime in another, antisocial behaviour in another.

Now I am unsure what data the spreadsheet should contain and how to display
the results. I would like the results to come back on an individual name /
address basis per sheet in the file, but I would also like it to produce
results on road names.

So for example, if Mr Jones lives in 123 High Street, I would want the
spreadsheet to highlight it if Mr Jones gets burgled on two or more
occasions. Nonetheless, I would also like some results produced if two or
more burglaries are recored in High Street, regardless of the house number.

How would I go about this? Can I search cells in a column for specific
words, so in the above case, "High Street" regardless of number?

Many thanks