Help with logical error checking in excel

[poojadsr]

I have a data with 4 columns:
1. Relation with House Head: it contains values from 1-23, 96...where each of the number represent the relationship of the member with House Head, like 1 means spouse, 2 means daughter etc...96: House Head
2. Sr No. ...one serial number can have multiple lines ...each for each relation, and relation can also be duplicate
For Ex.
HH can have 2 daughters.....but data of both daughters will be under same serial because they are one family (ex. serial...101)
3. Sex of the member 1: Male, 2: Female
4. Age of the member

What I need to do is
1. Check if age of house hold (96) is less than other member with 1 as code (1 means spouse), if true then show error
2. Check similarly for other members which include daughter, son (should not be greater than father, and age gap between father/mother and their son/daughter should not be less than 1, house heads father (should not have age less than househead and smilar like for age difference, not less than 1

These are somthing obvious bt I have data sheet which needs to check this logical errors
Can any one help me with the MAcro for this?
If yes, please tell, I have tried a logic but it is not working
_________________
Pooja Dubey Srivastava

[RPG]

Hello

I think do not use a macro.
Make a database of your spreadsheet.
Use SQL for the logic
Study the help file for the first SQL
Search on queries.

When you like the SQL make a real database.

see here
http://www.oooforum.org/forum/viewtopic.phtml?t=125093

Romke