Forum

Fantastic Riny. The file shouldn't have had any queries in it at all. Sorry about that. (Think I copied a table) Your answer was exactly what I was...

Thanks heaps for both responses. Velouria's is nice. And simple. Just how I like it. That's not to take away from Riny's Clunker. That was also hel...

File

One way would be to create a Custom column (You can call it the "Keeper") with the formula: if ([M1] = null and [T1] = null and [W1] = null and [Th1]...

Fantastic Riny. Simple and exactly what I was after.

Good idea. See attached file as suggested.