Formula is Required for Multiple Condition

S

Shaun

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.

A B C
NAMES DETAILS STATUS
aaa ST NUMBERS & ST
aaa 12354 NUMBERS & ST
abbbb 321325 NUMBERS
abcdef ST ST
abcdef ST ST
pqrs 6548 NUMBERS
pqrs 6548 NUMBERS
xyz ST NUMBERS & ST
xyz 5466 NUMBERS & ST

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 required results are given in C Column for ur reference.

I think i have explained it correctly. Pls suggest.

Thanks in Advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to return desired Result 4
countif on multiple criteria 1
excel formula 5
Macro that sorts data with blanks at the bottom 1
How do I Delete blank cells in a row 3
Merging rows- urgent help req 2
mutiple criterias formula 3
Find Duplicate names listed in opposite order 1

Top