Quote Originally Posted by AliGW View Post
You are very welcome - so glad we got there in the end!
haha sure did, 1 thing that is coming up i didn't notice last night, if there is only 1 value in the B column like Kitchen and not anything underneath im getting N/A in the P column. as soon as put a value in B column underneath like Bathroom The Formula works great.

any ideas on being able to get the formula to work still if there is only 1 value in the B column like Kitchen?