Excel 2007 : How to search and quantify connected data?

Hello!

I have no idea where to start searching for the answer to my question here on the forum, so I'll give it a go and ask it.

First off, I'm using Excel in Swedish, so excuse me if I use strange formuations.

I have a multisheet workbook with information about patients, personnumbers, addresses and such. One sheet for every diagnosis. Every patient has a relative in either the same sheet or, most likely, in another sheet. They are connected by ID numbers, in that way that every patient has an ID and the relatives ID is one column or more the right or to the left.

I now need to find out how many families there are, with two or more familymembers alive. I've made a table that counts patients with a live relative, but this counts patients and not families. Is there a quicker way than to search each patient and sort of mark the patient and the relative as a family? There are about a 1000 patients...

Thanks, Sarianna

Hi
If You send the file with example it will be easier to do and You will not have to worry about formulas (everything will translate automatically)

regards

I can't send the file because of classified information. I could make up an example, but it would take a long time.. What more information about the problem do you need to know? I'll try and explain as detailed as I can.