Macro to display values in Col E only once if values of Col A, B, C, D, E and I are same

[pnasir]

Hello All,

I am using Office 2013 and I need help with VBA for the problem shown in the attached sample file.

Data starts from Row 2 till down. I have shown a small set only.

The last Column is Col O

If the Value in Col A, B, C, D, E and I are same then the values in Col E must be shown only once

I have shown the result expected below in Rows 20 onwards.
In the sample I have highlighted Row 4 & 5 also Rows 8, 9 and 10 for explanation.

Values in Col E are shown only once

Hope to get some help
TIA

[Richard Buttrey]

Are the rows that are the same always adjacent or might they be separated?

[TMS]

One way:

Please Login or Register  to view this content.

[pnasir]

Dear Richard,
Thanks for your reply. They will always be adjacent

[TMS]

And the solution offered in post #3?

[pnasir]

Dear Trevor,
Thanks for your code. I tested your code on my actual data.
My apologies for not showing few blanks cells in Column D in the sample submitted.
It is also replacing cells with 0 under Column E if some adjacent cells are blank in Column D
Also the code should run on Active Sheet and not on Sheet1

Sorry once again.
Thanks for your time and help

[TMS]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

What does blanks in column D have to do with anything?

Post an updated sample with revised expected results.

[pnasir]

Dear Trevor,
I am attaching Revised Sample herewith.
Please check Rows 6,7 & 12,13.
In the submitted sample (old) there are values under Column E which is getting replaced by the macro.

I think it is clear now.
Thanks for your time and help.

[TMS]

OK, try with this version:

Please Login or Register  to view this content.

[pnasir]

Hi Trevor,
I will test it with my latest data when the office opens on Monday.
I will get back to you.
Thanks once again for your time and help

[pnasir]

Hello Trevor,
I tested it with my actual data and I would request you to amend your code to look for duplicate values in Col C and change the value to zero for the second and subsequent rows under Col E.

Thanks once again for all your time and help.

[TMS]

I don't understand. Are you saying, check for duplicate values in ONLY column C, as opposed to duplicates in columns A, B, C, D and E?

If that's the case, just remove the references to the other columns ( A, B, D and E ).

[pnasir]

Hello Trevor,
Sorry for getting back late due to some unavoidable circumstances.
The macro works great.
Post marked SOLVED. Rep added.
Thanks for all your time and help.

[TMS]

You're welcome. Thanks for the rep.