S
starguy
i have some values in col A in range A2:A12. some values are appearing
more than once. i have put a formula in col B to show values only
once.
=IF(COUNTIF($A$2:$A$12,A2)>1,IF(ISNA(VLOOKUP(A2,$B$2:B2,1)),A2,"-"))
what i meant from this formula is:
if value in A2 is appearing more that once in range A2:A12 then check
in col B in all preceding cells that has it appeared in that range, if
appeared return "-" otherwise value in cell A.
but this gives error of circular refrence. i changed it many times to
correct it but of no avail.
how can i make this formula correct
thanks in anticipation
more than once. i have put a formula in col B to show values only
once.
=IF(COUNTIF($A$2:$A$12,A2)>1,IF(ISNA(VLOOKUP(A2,$B$2:B2,1)),A2,"-"))
what i meant from this formula is:
if value in A2 is appearing more that once in range A2:A12 then check
in col B in all preceding cells that has it appeared in that range, if
appeared return "-" otherwise value in cell A.
but this gives error of circular refrence. i changed it many times to
correct it but of no avail.
how can i make this formula correct
thanks in anticipation