| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a statement about if then
I am very new to this. I have a sheet - sheet 1 which has names in column b, c, d and if the number one is in column A on sheet one, I want it to pull the names in column b, c, d on sheet 1 to sheet 2 column b, c, d. If sheet 1 column a has z zero I want it to skip it and go to the next row with a number 1 in column A. You see, I only want the data on sheet 2 if I have a one in column 1. I want it to skip all records until it sees a One again in column a sheet one. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| better way to write a count if statement? | Excel Worksheet Functions | |||
| How do I write a basic VLOOKUP statement? | New Users to Excel | |||
| How do I write a compound if statement? | Excel Worksheet Functions | |||
| How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
| how do I write the date in an if statement | Excel Worksheet Functions | |||
Threaded Mode
