sethu29
03-11-2013, 01:56 AM
Hi Support,
I have a huge data in coulmn A.
For Eg
In A column:
AA0001
AA0002
BA0001
BA0002
BA0003
CA0003
CA0004
Now i want to find out the maximum of BA*. Which means the answer would be BA0003
If i type CA in a cell, the answer has to CA0004.Even CA0001 and CA0002 might not be availabel. The answer has to be CA0004. Take an example if im typing AA on B1 cell, the answer need to be placed in C1 cell that AA0002. Please help me for this formula
I have a huge data in coulmn A.
For Eg
In A column:
AA0001
AA0002
BA0001
BA0002
BA0003
CA0003
CA0004
Now i want to find out the maximum of BA*. Which means the answer would be BA0003
If i type CA in a cell, the answer has to CA0004.Even CA0001 and CA0002 might not be availabel. The answer has to be CA0004. Take an example if im typing AA on B1 cell, the answer need to be placed in C1 cell that AA0002. Please help me for this formula