specific data

M

MFS

Hi all, I used an example to explain my problem
I have data (plant/car) in column A in sheet 1, I want to have specific data
in sheet2 (only car) without having anything else

Sheet1- A1=car,A2=plant,A3=plant,A4=car

Sheet2- A1=if(sheet1!$A1=car;sheet1!A1;0)-- Sheet2-
A2=if(sheet1!$A2=car;sheet1!A2;0) Sheet2- A3=if(sheet1!$A3=car;sheet1!A3;0)
Sheet2- A4=if(sheet1!$A4=car;sheet1!A4;0) etc

Now for each cell in sheet1 does not equal car, I will get “zero†in sheet2
Sheet1- A1=car,A2=0,A3=0,A4=car

What I can do to avoid “zeroâ€, and to have only the data I want without
spaces between cells, which mean I want to have “car†in sheet2
Sheet1- A1=car,A2=car

Please help me
 
E

Eduardo

HI,
You can copy everything to the 2nd sheet, then sort by "0", highlight all
the rows that have 0, and delete them
 

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

Excel - Wich Function should I use? 1
Need Help with a VBA subroutine 0
Another Hyperlink question 2
Check to see if a value exists in a list? 4
Automatically populating cells down a row 8
How Do I Avoid #REF! In Formulas? 5
Search Entire Sheet instead of 1? 4
List from a Table 1

Top