Complicated Excel Spreadsheet Query again!

  originalmiscellany 17:38 02 Dec 09
Locked

Overview:

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!

Thanks

  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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant