Hi Folks,
This is my first posting.
O.O. Spreadsheet - help please.
I have started compilation of an extensive list of ancestors which comprises
of five columns, first two text, second, whole numbers, (birth, death, life
span) as follows:
A B C D E
Smith Tom 1840 1910 70
I have planned for extraction of some data e.g. infant deaths, average
lifespan, no.'s achieving age majority, longest living etc.
However I have hit a problem extracting some information, using the above
example:
I can add a formula which sorts out the oldest survivor, OK, but I would
like to precede that cell result with the relevant column A & B (The named
individual) so it would read something like:
Oldest surviving ancestor: Smith Tom 70 yrs
Everything I have tried fails, and I have read & re-read the 'O.O. Help'
without success, it must be possible (And probably simple) but too much for
my poor old brain!
Can anyone help me?
Barrie Sharples
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
