Selecting or deleting data

[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

 

[Frank Kabel]

Hi
try in E1:
=IF(A1=C1,"",A1)
and copy this down

 

[Joey]

Thanks Frank


PS - Did you get the spreadsheet about the formula skipping data

 

[Frank Kabel]

Hi
no I didn't gget a file (mazbe it was too large?)
Try sending it again (compressed).

 

[Joey]

How do I compress the workbook? I never did this before

 

[Frank Kabel]

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)