1
I have a membership list like this in Excel
| A | 02-02-1994 | B | C
| D | 04-10-1998 | E | F
I want to change it, so it can be ordered by age (the 2nd column) or by name (the 1st column)
As you can the see the age is set up with a date and with that and a defined variable (hidden in another column). I need to calculate the age
That is not the problem
The problem is how I can let the user decide if he/she wants to sort by name or by age (like a Pivot)
I am using Excel 2003
Right now I am creating an HTML-page so you can see what I mean, if you can not see it from the question
UPDATE
An example can be seen on this page http://www.the87boy.dk/membershiplist.php