Thread
:
Help with Value in one column...
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
Posts: 2,389
Help with Value in one column...
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
wrote in message
...
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.
Reply With Quote
Fred Smith[_4_]
View Public Profile
Find all posts by Fred Smith[_4_]