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 than 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,

Rashid

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2