Hi,
Thanks for your help. I am an amateur with EXCEL and have no idea how this formula works but it did. It will still get messy as it grows but is shorter than before. If you have time, could you explain how would I use named ranges?

Gratefully,
jrpspayne