Hi,

I need a formula that should check the column A & B, Column A consist
Duplicate Names, but the value in B column for the duplicate Names will
differ. Now i just want to get if duplicate names are numbers then i need the
result in column C stating that "NUMBERS". if duplicate names are numbers &
ST then it should give the result as "NUMBERS & ST", If the duplicate values
contains only ST then it should return the result as "ST". Finally if the (A
Column) Name does not contain any duplicate value, then it should give the
result of "ST" or "NUMBER" depends on the B column Value (ex. abbbb)
The expected answers are given in C Column for ur reference

A B C
NAMES DETAILS STATUS
cat ST NUMBERS & ST
cat 12354 NUMBERS & ST
Lion 321325 NUMBERS
rat ST ST
rat ST ST
tiger 6548 NUMBERS
tiger 6548 NUMBERS
elephant ST NUMBERS & ST
elephant 5466 NUMBERS & ST

Thanks.
--------------------
(MS-Exl-Learner)
--------------------