Help with the MODE function
 

Is there a function that will pick out numbers that are almost the same they
just have a .0001 of a difference between them. I have 2 figures that are
reading 15% but they are actually 15.447 and 15.449 therefore the MODE
function is not recognising them as the same. and i need matching figures to
show up on my worksheet
--
Thank you for reading my post. Hopefully you can answer my querie

Help with the MODE function
 

If you round them they will evaluate as the same:-

=MODE(ROUND(A1:B1,2))

with the 2 numbers in a1 & b1.

Mike

"Shazza" wrote:

Is there a function that will pick out numbers that are almost the same they
just have a .0001 of a difference between them. I have 2 figures that are
reading 15% but they are actually 15.447 and 15.449 therefore the MODE
function is not recognising them as the same. and i need matching figures to
show up on my worksheet
--
Thank you for reading my post. Hopefully you can answer my querie

Help with the MODE function
 

Brilliant thank you very very much. this has saved me lots of hair :)
--
Thank you for reading my post. Hopefully you can answer my querie


"Mike H" wrote:

If you round them they will evaluate as the same:-

=MODE(ROUND(A1:B1,2))

with the 2 numbers in a1 & b1.

Mike

"Shazza" wrote:

Is there a function that will pick out numbers that are almost the same they
just have a .0001 of a difference between them. I have 2 figures that are
reading 15% but they are actually 15.447 and 15.449 therefore the MODE
function is not recognising them as the same. and i need matching figures to
show up on my worksheet
--
Thank you for reading my post. Hopefully you can answer my querie