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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement to return only true values but with out spaces
Hi Eric
You could use an autofilter to filer out 0 values in column 2. It can be done on Select column 1 and 2, goto Data Filter AutoFilter. Click on the drop down menu in column 2 and select Custom Does not equal 0 OK "Eric D" skrev i meddelelsen ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement to return only true values but with out spaces
Hi Eric
You could use an autofilter to filer out 0 values in column 2. It can be done on the original sheet. Select column 1 and 2, goto Data Filter AutoFilter. Click on the drop down menu in column 2 and select Custom Does not equal 0 OK Hopes this helps. .... Per "Eric D" skrev i meddelelsen ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement to return only true values but with out spaces
see your other post
-- Biff Microsoft Excel MVP "Eric D" wrote in message ... 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 |
Reply |
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 |