grouping data

  • Thread starter Thread starter merlin
  • Start date Start date
M

merlin

I have a list of tasks (column A) and in column B a priority from 1 to 4
for each task.

what I'm trying to do is display each item in one of 4 quadrants according
to it's priority (i.e priority 1 top left quadrant, priority 2 top right
etc).

This seems so simple but it has so far defeated me. I've managed to seperate
out the different priorities but I have blank lines in between some of them.
I'm having trouble listing them in the quadrant without the blank lines.

I can't do VB or macros yet but surely I don't need to resort to that for
something this simple - I think I must be missing a trick.

Oh, the other thing I should say is I need this constantly updated. I don't
want to apply filters etc everytime I add a task.

If anyone could help I'd be very grateful.

best regards

john
 
I can't find a way of using formulas for this but I'll definitely try the
pivot tables.

Thanks.
 
Back
Top