| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement to return only true values but with out spaces
is it possible to have an if statement or something that could return true
values in a list? ex. on a separate tab i have a sheet that has 2 columns in column 1 is names and in column 2 is $$. Is there a formula i can enter on a separate sheet so that it gives the answer when <0 but without spaces. there is about 300+ lines of data on spreadsheet 1 spreadsheet 1 spreadsheet 2 desired result col1 col2 col1 col2 eric 20 eric 20 dave 0 clark 10 clark 10 mike -5 lori 0 stan 0 mike -5 any thoughts? Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statement to return a list of values where answer is true | Excel Discussion (Misc queries) | |||
| lookup to return true() values only and list | Excel Discussion (Misc queries) | |||
| only return true values | Excel Discussion (Misc queries) | |||
| if multiple values same/others different, return true | Excel Discussion (Misc queries) | |||
| Return blank cell if 'find' statement not true | Excel Worksheet Functions | |||
Threaded Mode
