Urgent help with Excel formula. Please please help
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 |
Urgent help with Excel formula. Please please help
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 |
All times are GMT +1. The time now is 01:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com