how to select no.'s in a column that differ by <1

D

Danni

aHi, could anyone tell me how to select numbers from a list/column that
differ from other numbers on the list by e.g. <1? Can I do this by inserting
formula or would this involve programming? Any help would be extremely
appreciated.
 
G

Gary''s Student

Let's say we have values in column A. First sort the column if it is not
already sorted ( or copy the column and sort elsewhere). Then select A2 and
apply Conditional Formatting Formula is:

=A2-A1<1

and copy the formatting down the column. This works because we are bringing
close values close together
 
Top