View Single Post
 
Old 04-16-2011, 06:24 AM
Jamal NUMAN Jamal NUMAN is offline Windows XP Office 2007
Expert
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Thumbs up

appreciated Paul. it did work

regards

Jamal




Quote:
Originally Posted by macropod View Post
Hi Jamal,

That is not the same spreadsheet that was attached to your other post. Neither does it have the formula I posted in it.

Naturally, since the layout is different, it would be unreasonable to expect a formula designed for a different layout to work with this one. If you delete Column A from the second workbook you posted, then the formula I gave you will work.
Attached Images
File Type: jpg solutionClip.jpg (100.9 KB, 11 views)
Reply With Quote