Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Value in one column...
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Value in one column...
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Value in one column...
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 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) |