That sounds more like it!

You do not know by any chance how that would work?

Thanks,

Johannes


"Frank Kabel" schreef in bericht
...
Hi
you could create some array formulas but if you have more than 100
records this gets quite slow

--
Regards
Frank Kabel
Frankfurt, Germany

"Johannes" schrieb im Newsbeitrag
...
Thanks, quite usefull add-in though it is not really what i'm looking
for.
Am looking for a dynamic kind of link that prevends me from doing
this every
time an amount goes from 0 to a positive number. The add-in actually
uses a
static copy-pastevalues kind of link.

Still quite helpfull add-in though.

Johannes


"Frank Kabel" schreef in bericht
...
Hi
you may try the following addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Johannes van der Pol" schrieb im
Newsbeitrag
...
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