Thread: filter function
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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