ooops my bad, i just re tried Pepes formula and realised i was posting it into column F! which was then looking at column I as i hadnt changed the formula, Sorry Pepe
Thank you both, both work and i appreciate both of your answers you have saved me much stress over this small formula![]()
Bookmarks