List out the item that appears in one time from a database

**win386** · 03-26-2009, 02:00 AM

If I am given a database ranging from A1:C3 in the following table, how can I set formula to derive the result as listing out in A5:A10 ? The implication for this work is that I want to show the item that appears in one time and then list them out. Those appearing in more than one time is intended to be excluded.

Column A Column B Column C
Row 1 M N K
Row 2 X U M
Row 3 K N O
Row 4
Row 5 K
Row 6 M
Row 7 N
Row 8 O
Row 9 U
Row 10 X

Kelvin

**zbor** · 03-26-2009, 03:07 AM

=if(and(a1>0;b1="";c1="");a1;"")

**zbor** · 03-26-2009, 03:16 AM

Or try this: =IF(AND(A1;OR(ISTEXT(B1);ISTEXT(C1)));"";A1)

(this will give you 0 in Row 4, previous will leave row 4 empty but you can put in AND also A1>0 and get emty too)