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