First I have a question, in Excel you could filter by one column, then filter the remaining records by a different column, does Calc not have this functionality. I can't seem to get it to work and I think I read something in the past implying that you couldn't have more than one filter going at a time, so I wanted to verify with the community whether or not this was possible.
Second, I'm currently working on a document and went to filter it, but it was ignoring the bottom half of the document when populating the drop down with filtering options. These records also remain regardless of what I filter by. Is there some way to modify the filtering range? I tried selecting everything, turning off the autofilters, then turning them back on and the problem still existed. Any suggestions? Thank you for your help, Robert Volke --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
