Friday, 15 August 2003

Friday, 15 August 2003 01:01 pm
taimatsu: (yomikoface)
Went to job interview. Got there on time. People nice. Questions not hard. Think I did well. Hear next week.

Previous to that, went on very brief holiday to Chipping Campden, which is nice, medieval, that sort of thing. Ate nice food, looked at sheep, talked to family, bought books and buttons and a red pirate handkerchief, slept quite a bit, avoided getting sunburnt.

Am quite tired right now, not feeling very with it.
taimatsu: (sailor kitty)
Part of my aptitude test for the job interview this morning involved working with Excel. I'm pretty good with spreadsheets, and I managed 90% of it no trouble. There was one bit I had to kludge, though. Imagine you have a brief table containing data on five courses, one course to a row. First column, course code (W30456L, for example). Second column, course title (Learning IT). Third column, tutor's name (Adams, Linda). Fourth column, day, and fifth column, time.

Say I want to sort the courses alphabetically by the course title. That's in the second column, and if I select the whole table and push the A>Z button, it sorts on the first col., the course code. If I just select column 2, and sort, it only does that column, it doesn;t take the rest with it. What should I do?

I didn't have time to go through the help files. I cheated slightly (they were interested in the result, not how I got there, and no-one checked what I was actually doing) and inserted an extra column at the start, pasted the course title column in at the front there, sorted it on that, and then deleted it before printing. Not ideal for complex data. There must be an easier way, but I don't know what it is.

Profile

taimatsu: (Default)
taimatsu

April 2019

M T W T F S S
1234567
891011121314
15161718192021
22232425262728
2930     

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags