Create 2 sheets, from one, based upon value of one column

  • Thread starter Thread starter NickR2
  • Start date Start date
N

NickR2

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
 
In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"")
In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"")
 
Worked like a champ. THANKS

David Biddulph said:
In cell A2 of sheet 2, =IF(Sheet1!$H2="Y",Sheet1!A2,"")
In cell A2 of sheet 3, =IF(Sheet1!$H2="N",Sheet1!A2,"")
Click to expand...
 
Will this leave a lot of blank lines? If the condition is not met? If yes,
anyway to remove them automatically?
 
Autofilter for non-blanks?
--
David Biddulph

PAL said:
Will this leave a lot of blank lines? If the condition is not met? If
yes,
anyway to remove them automatically?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare identifier columns from 2 sheets - remove rows that are dups 2
Combining data from two columns into one - appending new values tothe end of one column 4
Summing one column if two other columns' values appear in other sh 3
Refernce 2 sheets & same columns & rows 8
Match and delete rows on two different sheets from reference numbers 4
Count the columns from one sheet and paste it in another sheet 0
comparing two sheet of data -- cost price increases 2
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1

Back
Top