flag 2-3 smallest numbers based on 2 columns

**alizok** · 03-05-2008, 04:42 PM

Hello everyone, it's been a while since I pose a question. Here is what I’m struggling. I have two columns one that has National ranking and the other column that consists of Area ranking. Once I identify my Area winners I need to pick up 2 National winners within Area winners. So the two that have smallest National ranking should be flagged as National winners see attached for detail explanation:

**oldchippy** · 03-05-2008, 06:45 PM

Hi,

Try this in F2 and auto-fill down the column

=IF(AND(D2=1,C2<=2),"Ntl Lead","")

**alizok** · 03-06-2008, 12:37 AM

thank you for your reply, but the thing is i need to have it without any autofilters since there is too many records. is that possible?

**oldchippy** · 03-06-2008, 08:59 AM

Originally Posted by alizok

thank you for your reply, but the thing is i need to have it without any autofilters since there is too many records. is that possible?

Hi,

Auto-fill not Autofilters

http://support.microsoft.com/kb/291359

See attached

**alizok** · 03-06-2008, 11:20 AM

thanks it does work, but in my original exapmple it just happen to be that it is ranked 1 or 2 but in real life it could be other than 1 or 2. I just updated attached file with real life numbers. Thanks and sorry for confusion

**oldchippy** · 03-06-2008, 05:24 PM

Hi,

May be this might work for you, put this in F2, you may have to adjust the range to your actual range.

=IF(OR(SMALL($C$2:$C$17,1)=C2,SMALL($C$2:$C$17,2)=C2),"Nat Lead","")

See attached