Find a value looking in two columns

[ghostexcel]

Hi all,

I have two columns (please see the attached file)

Would like to find a formula that looks in both column A and B and find only the value in the column A that have only one number in column B; in this example is going to be the value C, as in the column B all the value for C are 0 (there is no any value C with number 1 related)

Many thanks

[acroley1]

The attachment comes up as an "x" for me and I can't click on it....can anyone else see the attachment?

[Glenn Kennedy]

I can - it's a jpg. Are you using IE as your browser? I used to and was frequently unable to see pix. Try Firefox instead.

[samba_ravi]

=IFERROR(INDEX(A$1:A$9,MATCH(TRUE,INDEX(COUNTIFS(A$1:A$9,A$1:A$9,B$1:B$9,B$1:B$9)=COUNTIF(A$1:A$9,A$1:A$9),0),0)),"")

Try the above formula or below array formula

=IFERROR(INDEX(A$1:A$9,MATCH(TRUE,(COUNTIFS(A$1:A$9,A$1:A$9,B$1:B$9,B$1:B$9)=COUNTIF(A$1:A$9,A$1:A$9)),0)),"")

[ghostexcel]

Great! Many thanks, this works perfectly!

[acroley1]

Glenn - sady, I'm on IE8 and I don't have a choice on this computer as I'm at work and our IS has us blocked from downloading Chrome or any other internet options. Boooooo

[Glenn Kennedy]

Our IT crowd supplied us with IE, but forgot to block the download of FF; so - no problems!!!

[acroley1]

I'm jealous....our team took away ALL rights to download ANYTHING!!! Too many dummies puttings coupons.com on their work computers!