Quote:
|
Originally Posted by sanddrag
That's almost exactly what I wanted. However, I didn't like the sort of back door route of using the hidden "A" column. So, I devised a better IF statement to take care of that. Take a look.
|
Very nice. I like this new solution better as well. Although Dave's method sounds even better. I've never played with Auto-Filter before, but I am definitely going to in the future.