Well you do know... Filter everything > 1 and exactly that is what is filtered.
But I do understand where you are comming from tho... A lot of times if you count on default or "self thinking" software... eventually it will come around and bite you somewhere painfull.
This tho I have been using for atleast 8 years without fail... But it is your project after all.... and (again) I do know where you are comming from bloody self thinking *freaking me out* darnation software!
Yeah it's just that this particular sheet is extremely important and if something was removed that shouldn't be it can be a HUGE issue - we're talking compliance with federal laws and stuff so yeah I'm being a bit over paranoid with this project.
Thanks for the help - it's working now. And in a way that I can manually verify the data to insure integrity so that I know the program can't be doing something I don't want it to.
What I had it do was loop through the results and for every value > 1 I had it put "DELETE" in that cell. Then looped through after that and removed the rows that had "DELETE".