Here is Bill's file with the filtering functions corrected, I think.
The formula for counting only visible filtered rows is very complicated. I'll keep my eye open for a simpler one that takes up less memory.
In order to upload it, I had to lop off all the extra rows at the bottom. But if you add rows in the normal way, it will still work, and the programming ranges will update automatically with the extra row numbers.
Bill, if you want me to fix the red and green and yellow colors in all the races, if that's helpful, it would be very easy to do.
Tom
|