Prev: Find and Replace wildcards
Next: Formula for unique records
From: woodson87 on 16 Feb 2010 19:19
I'm trying to find in one of my rows of my excel spreadsheet specific
countries like Germany, Italy, France, etc. I need a formula that will
display IF one of those names occurs in that row, it will display a Y for
Yes. If it is not one of those names, I want it to display a N for No.
From: Beverly on 16 Feb 2010 19:37
You can use "countif" for this. Here's how it would work:

Row 1 = your data range
Column A = the values you want to find

Here's some sample data:
Row 1 Column A (starting in row 2)
Germany Germany
Italy USA
Austria
France
Hungary

In cell B2, next to Germany, your formula would be:
=if(countif($1:$1,a2)=0,"No","Yes")

Beverly

"woodson87" wrote:

> I'm trying to find in one of my rows of my excel spreadsheet specific
> countries like Germany, Italy, France, etc. I need a formula that will
> display IF one of those names occurs in that row, it will display a Y for
> Yes. If it is not one of those names, I want it to display a N for No.
From: T. Valko on 16 Feb 2010 23:12
I'm assuming you mean that if the range contains Germany *OR* Italy *OR*
France then return Y.

Try this...

=IF(SUM(COUNTIF(A1:J1,{"Germany","Italy","France"})),"Y","N")

--
Biff
Microsoft Excel MVP


"woodson87" <woodson87(a)discussions.microsoft.com> wrote in message
news:F35CA68E-364C-4B7B-A730-B9FB9C58F334(a)microsoft.com...
> I'm trying to find in one of my rows of my excel spreadsheet specific
> countries like Germany, Italy, France, etc. I need a formula that will
> display IF one of those names occurs in that row, it will display a Y for
> Yes. If it is not one of those names, I want it to display a N for No.


 | 
Pages: 1
Prev: Find and Replace wildcards
Next: Formula for unique records