| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
specific data
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 -- MFS22 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
specific data
HI,
You can copy everything to the 2nd sheet, then sort by "0", highlight all the rows that have 0, and delete them "MFS" wrote: 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 -- MFS22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data to specific cells for a specific row | Excel Discussion (Misc queries) | |||
| Getting specific data into specific cells? | Excel Discussion (Misc queries) | |||
| Get data from specific collumn | Excel Worksheet Functions | |||
| HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
| How do I color specific data series based on location on data she | Charts and Charting in Excel | |||
Linear Mode
