Sorting based on IF statement *please help me!*

Sorting based on IF statement please help me!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikey C - 18 Sep 2007 09:44 GMT

Hi

I'm trying to create a macro which will sort a table 1st based on an
IF statement and then by a due date. What I'm trying to do is sort the
table so that any complete tasks (signalled by a "Yes" in the
designated column) will be pushed to the bottom of the list and the
most overdue to the top.

My IF statement displays a True or False in a hidden column if the
task is complete or not. Then I tried sorting by that column first and
then the due date afterwards. That didn't work either though because
the complete items are pushed right to the bottom of the sheet -
leaving hundreds of empty rows between!

I'm sure there must be an easier way. Can anyone help?

Reply to this Message

Pete_UK - 18 Sep 2007 11:14 GMT

Can't your macro just delete the blank rows?

It sounds as if you are allocating your hidden formula to many more
rows than you need, and the blank rows are indicating that the task
has not been completed. You could refine the formula so that it does
not respond to blank rows, or you could ensure that it only applies to
rows with data in them, or you could adjust your sort range to ensure
that only rows with data in are included.

So many possibilities !! It would help if you pasted your macro here.

Pete

> Hi
>
[quoted text clipped - 11 lines]
>
> I'm sure there must be an easier way. Can anyone help?

Reply to this Message