Identify numbers that only occur once in a column.
If your numbers are, say, in column F, then
=COUNTIF(F:F,F1)=1
returns true for the ones occuring once. you can use it either in e helper
column or as a conditional formatting formula depending on the way you want
to identify them.
Regards,
Stefi
€˛Karen€¯ ezt Ć*rta:
I have numerous lists of about 2500 numbers each where most occure twice, but
some only occure once and these are the ones that I want to work with. Any
suggestion as to how I can do this in a simple manner?
|