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

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

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

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