Urgent help with Excel formula. Please please help

[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

 

[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