Eeek, let me think about that.
I don't really understand that. The formula give so far does nothing with the year. It looks for pairs of bird IDs and gives them an ID.
Also, once that pair exists in the DB the first time, they get an ID, period. So further down the list will detect that ID and reuse it, so I don't really see what new thing you're adding here.
Last edited by JBeaucaire; 09-07-2014 at 12:31 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sorry, maybe I'm just not explaining myself very well.
Within the spreadsheet, every 'pair' will appear twice for the year that they were together. Once in column A and again in column C once I've entered it.
To prevent me from entering data into column C 6000 times, is there a way for the spreadsheet to detect that the number that I've entered into column C also appears further on in column A and providing the year is the same, automatically copies the ID of its partner for that year.
Back to my initial 'human' population census as an example, let's suggest that the individual in cell A2 is Mr Jones, and in 1977 he lived with Mrs Jones and , thanks to your formula, a unique ID is created for 'Mr and Mrs Jones'.
Further down the spreadsheet, Mrs Jones will be listed in column A under 1977 also. Is there a way for a formula to realise that Mrs Jones , in 1977, was living with Mr Jones (as in line 2) and automatically complete the cells in column C with Mr Jones and therefore completing the unique ID for 'Mr and Mrs Jones' as in cell D2?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks