1. J

    permanently filter out cases and analyse data on a case-by-case basis

    Hello! Would appreciate any help...have searched the previous posts without luck... Am using Excel XP Q1: i want to filter out duplicate cases in a specific column where constant data e.g. 'age' is unchanged for a particular case. I have tried C&P to a separate doc, advanced filtering showing...
  2. S

    VBA to "freeze" conditional formatting

    I've seen VBA written to do this for excel 2003 but not for 2007. All i want to do is to make the fill colour and font colour of the CF permenant so the CF can be deleted. I have a spreadsheet which is being crippled by conditional formatting. As i write this i've been waiting 10mins just to...

Some videos you may like

This Week's Hot Topics