close
How do I find similar or quot;near enoughquot; numbers in a column. Is there a
formula to show these numbers? ( not very well explained I suspect)
Yes there is a formula:
If you have a column of numbers (say column A) and want to know which are
quot;nearquot; to others:
1. sort the column ascending
2. in B2 enter =ABS(A2-A1) and copy down
Just by looking down column B you can find values that are close to each
other. The correspond to very samll values of B
--
Gary's Studentquot;dunequot; wrote:
gt; How do I find similar or quot;near enoughquot; numbers in a column. Is there a
gt; formula to show these numbers? ( not very well explained I suspect)
全站熱搜
留言列表
