Quote Originally Posted by argomike View Post
Pete,

This one doesn't seem to be working. I get the following error: "Range has no entry corresponding to the cell"
You know, I've never come across that particular error message before. It worked for me in the test file, so I can only assume that you have introduced some typing error. Obviously, you should not place that formula within any of the ranges that it covers (i.e. put it in column D somewhere) and you should check that you have typed it out correctly as there are a lot of brackets in there. To avoid typing mistakes, copy the formula from the above post and paste it into the formula bar with a cell in column D selected. Then make the adjustments to the ranges to suit your data.

Hope this helps.

Pete