Complicated Excel Spreadsheet Query again!

  originalmiscellany 17:38 02 Dec 09


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 09

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

click here

Thanks in advance

  Zak 18:59 04 Dec 09

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 09

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…