changes to a formula to allow for differences in decimal places

[BigTandthepc]

Hi ,

ive adapted the formula so it does exactly what I need it to,

the only problem is it sees values as exact amounts so for example £2.10 matches £2.10, but £2.10 does not match £2.1011111111111 for example.

how do i make the fomula less exact so it will match the numbers?

the adapted formula is:

=IF(A15=0,0,COUNTIFS(Q:Q,Q15,L:L,L15)>1)

please help if you can

[Cutter]

Solved in duplicate post: http://www.excelforum.com/excel-gene...ne-client.html