Debra,

I'm not sure if you're still around on here given this was 7-8 years ago but, I need to use lists with illegal for my work. I tried to mimic your example before I tried to do my work sheet but I couldn't get it to work. Maybe it's because I'm using Excel 2010?

If you could help, that'd be great!

Thank you,
Zack