Find and Replace Help

[daveinli]

Hi,

I have 2 columns, the first is the List Price Column M the 2nd is the Sell Price Column O. What i need to do is search for sell price that is higher then the list price and make them list price

thank you

[Pete_UK]

It would help if you attached a sample Excel workbook - see the first yellow banner at the top of the screen for details on how to do this.

Pete

[daveinli]

See Line 22 and Line 31 as examples. the ones in red are just examples of what I need formula to do

[JohnTopley]

If you want to replace value in M by value in O you will need VBA to do this.

[Pete_UK]

You can use this formula in O2:

=MIN(M2,ROUND(N2*1.02,2))

then copy down as required.

Hope this helps.

Pete