Macro to delete items where Ref is Simililar and variance between values is a max of 0.70

**Howardc1001** · 07-21-2023, 01:07 PM

I have references in Col D and values in Col F and G

Where the references are similar and the difference between the sum of the value in Col F and G is a max of 0.70 , then those rows are to be deleted

I have highlighted the items in my sample data to be deleted

I have tried to write code but it deletes the wrong rows

Please Login or Register  to view this content.

**Marc L** · 07-21-2023, 01:35 PM

First issue is the column D references are different …

**Howardc1001** · 07-21-2023, 10:08 PM

Hi Marc

Where the references are similar for eg PQRT P and PQRT and a small difference can be established between Value/s in Col F -ol G not exceeding 0.70, then those rows must be deleted

I have attached updated sample data which I have highlighted in Yellow to be deleted

Macro to delete items where Ref is Simililar and variance between values is a max of 0.70

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete items where Ref is Simililar and variance between values is a max of 0.70

Re: Macro to delete items where Ref is Simililar and variance between values is a max of 0

Re: Macro to delete items where Ref is Simililar and variance between values is a max of 0

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to delete items in Col G greater than 1

[SOLVED] Macro to delete certain items in Col B

[SOLVED] Macro to delete certain items then count remaining items #2

[SOLVED] Macro to delete certain items then count remaining items

Macro to delete items contain 1 and less

Delete unwanted items in a column and joining values together

[SOLVED] Compare Data from Two different tabs and to identify variance items

Bookmarks

Bookmarks

Posting Permissions