Many thanks for the suggestions guys, I really appreciate it! I struggle to wrap my head around vba sometimes. I ended up using snb's formula as I found it the easiest to follow but thank you all!