Maintain IF statement when sort

[catherineburns]

Schedule.xlsx

In the attached spreadsheet column E records:

- "more than 2 years" IF the time elapsed since the date entered in column C is more than 2 years
- "more than 1 year" IF the time elapsed since the date entered in column C is more than 1 year but less than 2 years
- "within schedule" IF the time elapsed since the date entered in column C is less than 1 year

I want to be able to sort the data in column E so that rows that equal more than 2 years sort to the top of the spreadsheet followed by rows that equal more than 1 year followed by rows that are within schedule, whilst maintaining what is achieved by the IF statements in column E.

Thanks very much

[Glenn Kennedy]

Hi there. I fixed two problems with this. I changed the starting phrase so that it returns a blank if Column C is empty. That stops the long line of responses in empty rows. I changed the references to A1 to $a$1. This locks the formulas to looking at A!. So when you drag the formula down, it keeps looking at A1.

Once that was done (and some odd purple colouring in the background removed); they were sorted by Data?Sort/Column C/Values/Odest to Newst.

How does this look?

You might need to add a new CF rule to cover the bottom row, which currenytly has no shading...

[catherineburns]

Hi Glenn

Thanks v. much for your speedy response - it sounds brilliant but I think you attached the original spreadsheet rther than your modified one. Please reattach and ill take a look

Thanks once again

Catherine

[Glenn Kennedy]

Dohh! Is this it???