Prev: Color Me Red
Next: SUMPRODUCT with two valid criteria
From: David M David on 26 Mar 2010 17:37
If you have an ethnicity column I want to go to the next column and for all
of a certain ethnicity I want to return either a 1 or a zero.

Column A Column B
Hispanic 1
White 0
African American 0

In this case I am just quering for one ethnicity to which the second column
would display a1 for yes and or a 0 for no.

Any suggestions.
From: Fred Smith on 26 Mar 2010 17:48
My suggestion is you ask a clear question. I can't figure out what you're
trying to do. Is it as simple as:
=if(a2="Hispanic",1,0)
?

If not, give some more examples.

Regards,
Fred

"David M" <David M(a)discussions.microsoft.com> wrote in message
news:EC9B1352-96E8-4E55-9D95-764D950750F2(a)microsoft.com...
> If you have an ethnicity column I want to go to the next column and for
> all
> of a certain ethnicity I want to return either a 1 or a zero.
>
> Column A Column B
> Hispanic 1
> White 0
> African American 0
>
> In this case I am just quering for one ethnicity to which the second
> column
> would display a1 for yes and or a 0 for no.
>
> Any suggestions.

From: JLatham on 26 Mar 2010 17:55
In B1
=IF(A1="Hispanic",1,0)

Change "Hispanic" to whatever indicator actually shows up in A1.

Other possibilities you might run into later:
Any non-white
=IF(A1<>"White",1,0)
Combination of 2 or more
=IF(OR(A1="Hispanic",A1="American Indian"),1,0)

Hope it helps you along with your project.

"David M" wrote:

> If you have an ethnicity column I want to go to the next column and for all
> of a certain ethnicity I want to return either a 1 or a zero.
>
> Column A Column B
> Hispanic 1
> White 0
> African American 0
>
> In this case I am just quering for one ethnicity to which the second column
> would display a1 for yes and or a 0 for no.
>
> Any suggestions.
From: L. Howard Kittle on 26 Mar 2010 18:20
Try this.

In J1 do a drop down the ethnicities.

With your ethnicity column starting in G9, in H9 enter this formula and pull
down as far as needed.

=IF(G9=$J$1,1,0)

Now when you select a different ethnic group in J1 it will put a 1 there and
0 for the others.

HTH
Regards,
Howard

"David M" <David M(a)discussions.microsoft.com> wrote in message
news:EC9B1352-96E8-4E55-9D95-764D950750F2(a)microsoft.com...
> If you have an ethnicity column I want to go to the next column and for
> all
> of a certain ethnicity I want to return either a 1 or a zero.
>
> Column A Column B
> Hispanic 1
> White 0
> African American 0
>
> In this case I am just quering for one ethnicity to which the second
> column
> would display a1 for yes and or a 0 for no.
>
> Any suggestions.


 | 
Pages: 1
Prev: Color Me Red
Next: SUMPRODUCT with two valid criteria