filter function
Hello all,
I have a long list of items (column A) and say amounts (column B) and want
to create a sublist where only the items are shown with positive amounts.
Can this be done without using (advanced) filter?
My cumbersome solution was to add a counter in column C that increases every
time the amount is positive and then use some "match" and "offset" formula's
to create a list. My feeling says it must be possible to do this easier.
Thanks,
Johannes
|