You could create a project report, add reference number and the other field you think may have common values in the projects. Then you can use groupings to group projects by that other field. Once you save the report, you will have a summary tab where projects with common values in this field will b...