OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Help with logical error checking in excel

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
poojadsr
Newbie
Newbie


Joined: 14 Jul 2011
Posts: 1
Location: Mumbai

PostPosted: Thu Jul 14, 2011 4:35 am    Post subject: Help with logical error checking in excel Reply with quote

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 1Cool, house heads father (should not have age less than househead and smilar like for age difference, not less than 1Cool

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
Back to top
View user's profile Send private message Yahoo Messenger
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu Jul 14, 2011 6:31 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group