Urgent help with Excel formula. Please please help

R

Rashid.adam

I have a spreadsheet that contains 3 columns
Column A is called Deal Number
and contains:
A1:1
A2:2
A3:1
A4:3
A5:1
Column B is called DND
B1:a
B2:a
B3:b
B4:a
B5:c

Column C is called Alert

What i want is to put the word "alert" if column A appears more tha
once and column B is the last letter of the range.
For example for the above entry, it should only "alert" C5

Hope that makes sense.

Many Thanks for all your help.

Kind Regards,

Rashi
 
C

Claus Busch

Hi Rashid,

Am Wed, 19 Sep 2012 11:02:22 +0000 schrieb Rashid.adam:
A1:1
A2:2
A3:1
A4:3
A5:1
Column B is called DND
B1:a
B2:a
B3:b
B4:a
B5:c

Column C is called Alert

What i want is to put the word "alert" if column A appears more than
once and column B is the last letter of the range.
For example for the above entry, it should only "alert" C5

in C1 try:
=IF(AND(COUNTIF($A$1:$A$1000,A1)>1,ROW()=MATCH("",$B$1:$B$1000,-1)),"Alert","")


Regards
Claus Busch
 

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

Top