Hello shg,

Yes, your formula seems to work. How do I go about using that in the spreadsheet? I copied the C1 formula but it does not seem to 'auto solve' (not sure what the term is).

Do I need to do something with the code provided?

I apologize for the lack of knowledge on excel. I am a nooby dan.

Thanks.