Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure what type of formula to use
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure what type of formula to use
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure what type of formula to use
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What type formula to use? | Excel Worksheet Functions | |||
Cannot see formula descriptions in worksheet as I type a formula. | Excel Worksheet Functions | |||
Look for a certain type of formula... | Excel Discussion (Misc queries) | |||
Just need to know what type of formula i would use for this | Excel Worksheet Functions | |||
"IF" type formula | Excel Discussion (Misc queries) |