if statement to return a list of values where answer is true
there are 300+ rows and the numbers are not always positive
--
Eric
"T. Valko" wrote:
How many rows of data is there on Sheet1?
The numbers in column B, are they always positive numbers?
--
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 but without spaces.
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
|