Re: too many IF's ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave (post_at_site.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 09:44:26 -0400

sorry..... didn't know that was not acceptable!

"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:OwZ1aUwoEHA.324@TK2MSFTNGP11.phx.gbl...
> Hi
> please do not attach files to this NG. Best way would be you'd explain
> your spread*** layout in plain text.
>
> Without looking at your attachment have you tried 'Data - Filter -
> Advanced Filer' for this?
> Also have a look at Ron's great Easyfilter addin for this kind of
> filter operations:
> http://www.rondebruin.nl/easyfilter.htm
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "Dave" <post@site.com> schrieb im Newsbeitrag
> news:O#a$bSwoEHA.1608@TK2MSFTNGP15.phx.gbl...
> > I have enclosed a sample workbook.
> > *** one has a database of customers and services.....
> > *** two has IF formulas that will automatically copy info from
> *** 1 if
> > no fee has been recieved ( if cell in column F is blank). It works
> just
> > fine, however I would like for any data from *** 1 with "free" in
> *** 1
> > column G to be left out (not copied) to *** 2. In the enclosed
> example
> > data from sheet1 row5 would not copy to sheet 2.
> > can't seem to figure that one out!
> >
> > Dave
> >
> >
> >
>

Quantcast