Selecting or deleting data

  • Thread starter Thread starter Joey
  • Start date Start date
J

Joey

Hi all

Is it possible to have a formula which recognises whether to select o
delete data.

Eg;

A1 = xxx
A2 = yyy
A3 = zzz
&
C1 = (Nothing)
C2 = (Nothing)
C3 = zzz

The results in E1,2 & 3 should have data in A1 and A2 but not A3 or C
because Column C is for cancelled items and if it data in this colum
matches then they should cancel each other out.


Many thanks
Joe
 
Hi
no I didn't gget a file (mazbe it was too large?)
Try sending it again (compressed).
 
Hi
normally use a compression program like WinZip. If you
don't have one just try sending it again (I've raised the
maximum data volume for this case)
 
Back
Top