Filter/Find for imperfect match

[AlexCS]

Hi everyone,

What my code is trying to achieve overall is go through the rows of one column, and match 3 elements in each row with 3 elements found in one row of the adjacent column, like

a b c d e f
x y z
a b c

To do this, I am using two AutoFilters and one Find to get the position of the cell that I am finding and paste the initial row in the right place

However, say figure b that is a price is 948.495945473769 in the first column and 948.50 in the second one, thus rendering both Autofilter and Find useless.

Does anyone have any idea how to either convert 948.495945473769 to 948.50 or how to use a find/filter method that would match the two regardless of the formatting?

Please help, I am honestly at a loss by now.

Many thanks,

Alex

 

[circledchicken]

Hi,

I'm a little confused by your example but to convert the number you can use the ROUND function like:

=ROUND(A1,1) or =ROUND(A1,2)

 

[AlexCS]

Thank you so much, confusing example or not this is what I needed

 

[circledchicken]

Haha, your welcome.