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