G
Guest
Hi
I have a list of data. I'm filtering a one of the columns to find all
records with a value between x and y. This results in only the matching
records being displayed. Real simple.
Now, is there an instruction to analyse ONLY the records that are remaining?
Example: I'd like a cell at the end saying "# records matching criteria", and
another cell summing a particular column (again using ONLY the remaining
records).
At present, I'm doing this using macros to filter, cut, paste, etc. It's
well slow!
I have a list of data. I'm filtering a one of the columns to find all
records with a value between x and y. This results in only the matching
records being displayed. Real simple.
Now, is there an instruction to analyse ONLY the records that are remaining?
Example: I'd like a cell at the end saying "# records matching criteria", and
another cell summing a particular column (again using ONLY the remaining
records).
At present, I'm doing this using macros to filter, cut, paste, etc. It's
well slow!