Forum Home
Press F1
Thread ID: 26796	2002-11-05 11:47:00	Sorting Excel 95 database	Deebee (1184)	Press F1

Post ID	Timestamp	Content	User
96260	2002-11-09 09:48:00	Thanks for your valuable suggestions, guys -- I was wondering where the spreadsheet experts were :-). I have to stick with this "old" software because I'm an invalid beneficiary. The 12% of missing "Left" dates were probably a result of sole teachers leaving at the end of a year. Kahawai_Chaser: I wondered whether a Pivot Table would work, but couldn't figure it out. -- will try again. By the way, I used to be a kahawai chaser too. Delicious! Russell D: There are 19 columns -- about five would be needed in the extract. O M Hubbard: Unfortunately, my version of Excel 95 doesn't have the DATEDIF function which is supposed to be in the Analysis ToolPak, according to what I found out on the net (I loaded it, and DATEDIF isn't there), so I have to get ages from Input Date some other way. Many of the pupils made contributions to local newsletters, so I want to get their age on dates other than 1 January for a history I'm writing. Mashimaro: I have Access 95, but haven't needed yet -- Excel 95 has fulfilled my many database requirements so far. As you say, though, I may need it for this job. B.M. Many thanks for your offer. I'll study the info here and have a go at using it, but may yet take you up on it. Craigb: Thanks for your suggestions too. I wrote quite a few complex macros back when I had Word Perfect and Quattro Pro for DOS. It was fairly easy with their plain language, and I found Microsoft Office quite a step backwards. Couldn't believe I had to learn complex programming language to write macros, and have never had time to learn. Was also bowled over to discover that Microsoft didn't include a simple plain text, non-updating, date function in their Word templates. With MS Office, there were so many things I couldn't do "at the press of a button" that I could do way back in the good old CP/M and MS-DOS days.	Deebee (1184)
1 2