Complicated Excel Spreadsheet Query again!

  originalmiscellany 17:38 02 Dec 2009


I have a spreadsheet used to monitor pupils' work

Broken down into tasks in column C e.g.

I can do x y and z
I can save my work in a safe location

and they tick the box in column d next to the task if they can complete this.

I have done a Vlookup which works out the grades a pupil is working at - this works fine.

My problem is that I'd like to have "improvements" to the work, where it looks at the list of tasks in column C and the 3 improvements are the first three incomplete tasks.

How do I do this!


  originalmiscellany 18:02 02 Dec 2009

I've included a link to google docs to help visualise the problem

click here

Thanks in advance

  Zak 18:59 04 Dec 2009

I am trying to solve and have some ideas but struggling. Maybe this wil now be seen by VoG™, who always has a solution.

  VoG II 20:05 04 Dec 2009

Well I would have a go but I'm not sure I understand what you want to do.

Try posting an example (with fictitious pupil names) showing what you have and what you want to achieve at click here (or another file sharing site) and provide the link.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017