Welcome. Your requirements were both numerous & complex.

I'm quizzical about this comment though:
.. The result is sort of off from what I am looking for ..
as the results yielded does look like a 100% exact match
with what you originally posted.

Could there be a problem with your actual data, I wonder?

Take down the sample file, see for yourself
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Saz" wrote in message
...
Hi Max, Thank you for the help. Using your formula did help me where
to start. The result is sort of off from what I am looking for but I
think I can twist little bit and get what I want. Thank you again, Saz