|Posted: December 23, 2011, 5:06 pm - IP Logged|
Thank you for the reply, it is close to what I need and your formulas works fine , thank you.
What I'm looking for is one formula that I would put in cell R10 and just drag to the right, up to AZ10 and would eather return all pairs if all the 9 digits are there or return blanc cells if there is less digits to deal with.
And the same for the duplicate one.
I know it's possible but I'm not qualify for such formula !!!.