| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create 2 sheets, from one, based upon value of one column
We have a spread sheet with several columns of data, and one column which is
yes or no (thanks for the help with that one, by the way). We would like to have all rows with a "Y" in column 8 (for example) show up on Sheet2, and all with a "N" show up on Sheet3. I am having a terrible time trying to do "IF" "THEN" requests. Thanks NickR |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create 2 sheets, from one, based upon value of one column
In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"")
In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"") -- David Biddulph "NickR2" wrote in message ... We have a spread sheet with several columns of data, and one column which is yes or no (thanks for the help with that one, by the way). We would like to have all rows with a "Y" in column 8 (for example) show up on Sheet2, and all with a "N" show up on Sheet3. I am having a terrible time trying to do "IF" "THEN" requests. Thanks NickR |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create 2 sheets, from one, based upon value of one column
arrgggh ... I was missing the empty "" at the end ... Thanks!
"David Biddulph" wrote: In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"") In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"") -- David Biddulph "NickR2" wrote in message ... We have a spread sheet with several columns of data, and one column which is yes or no (thanks for the help with that one, by the way). We would like to have all rows with a "Y" in column 8 (for example) show up on Sheet2, and all with a "N" show up on Sheet3. I am having a terrible time trying to do "IF" "THEN" requests. Thanks NickR |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create 2 sheets, from one, based upon value of one column
Worked like a champ. THANKS
"David Biddulph" wrote: In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"") In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"") -- David Biddulph "NickR2" wrote in message ... We have a spread sheet with several columns of data, and one column which is yes or no (thanks for the help with that one, by the way). We would like to have all rows with a "Y" in column 8 (for example) show up on Sheet2, and all with a "N" show up on Sheet3. I am having a terrible time trying to do "IF" "THEN" requests. Thanks NickR |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create 2 sheets, from one, based upon value of one column
Will this leave a lot of blank lines? If the condition is not met? If yes,
anyway to remove them automatically? "David Biddulph" wrote: In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"") In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"") -- David Biddulph "NickR2" wrote in message ... We have a spread sheet with several columns of data, and one column which is yes or no (thanks for the help with that one, by the way). We would like to have all rows with a "Y" in column 8 (for example) show up on Sheet2, and all with a "N" show up on Sheet3. I am having a terrible time trying to do "IF" "THEN" requests. Thanks NickR |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create 2 sheets, from one, based upon value of one column
Autofilter for non-blanks?
-- David Biddulph "PAL" wrote in message ... Will this leave a lot of blank lines? If the condition is not met? If yes, anyway to remove them automatically? "David Biddulph" wrote: In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"") In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"") "NickR2" wrote in message ... We have a spread sheet with several columns of data, and one column which is yes or no (thanks for the help with that one, by the way). We would like to have all rows with a "Y" in column 8 (for example) show up on Sheet2, and all with a "N" show up on Sheet3. I am having a terrible time trying to do "IF" "THEN" requests. Thanks NickR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seperate data from one sheet to multiple sheets based on a column | Excel Discussion (Misc queries) | |||
| Create Code Based on Column | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
