Hi Jasonjhc,

there can be three scenario to this which I solved all for you..

See attached and let me know if this helps.. thanks.

excelforum.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>