Help on Excel Formula

 

Kindly help me on the below formula,

=AND(COUNT(MID(A9,{6,7,8,9},1)+0)=4,COUNT(FIND(MID(UPPER(A9),{1,2,3,4,5,10},{1,1,1,1,1,999}),”ABCDEFGHIJKLMNOPQRSTUVWXYZ”))=6,UPPER(MID(A9,4,1))=”P”)

The formula works perfectly well. But at the end of the formula I want additional details like

UPPER(MID(A9,4,1))=”C”), UPPER(MID(A9,4,1))=”F”), UPPER(MID(A9,4,1))=”A”)

Thank you.

 

By: Rajan

Leave a Reply

Your email address will not be published. Required fields are marked *