Reverse Filter Selection

[ozzybourne]

Hi Guys.

Sorry slightly new to this.

Was working on a project where we used Excel to track 10 of thousands of messages and one of the things that we found that was a pain is having to go through and filter out the data that we wanted and then manually go through the same data again to select the remaining data only. For example had values A, B, C, D, E, F and in the first rotation we wanted; A, C, E and then second rotation wanted; B, D, F.

Whats your thoughts on having a button on the filter drop down box that would reverse the filter, so un-select what is selected and select what was not selected?

Regards

[humdingaling]

For the reverse selection...maybe something like this post
http://excelusergroup.org/forums/t/3535.aspx

basically tagging visible cells with 1 and filtering based on what is not 1