Hi Guys,
I want to sort row based on duplicate value in Column 2 & 3. And copy the content if Column 3 is Self-duplicate.
Hard to explain, something like this:
Column 1
131.74
1.63
12.31Column 2
375-9323
384-803
267-6491Column 3
375-9323
NO
384-803
267-6491
375-9323
Result should be like this:
Column 1
131.74
1.63
12.31
131.74Column 2
375-9323
384-803
267-6491
375-9323Column 3
375-9323
NO
384-803
267-6491
375-9323
I've been playing with different Macro and search quite a few places but haven't got any luck so far.
I'm wondering if someone here is kind enough to write an example Macro/VBA coding for this.
Thanks guys
Bookmarks