question

oarsout avatar image
0 Votes"
oarsout asked oarsout edited

Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell

I am looking for a VB script that will:

  1. Add the word "Duplicate" in column J for all records (except the first instance) where the corresponding value in column B is duplicated.

  2. If there is a value in column I for any one of the [duplicate] instances of column B, than copy that I value into column I for all instances.

  3. If any instances of the value in column B has a different I value, then highlight the cells in column I for all instances.

See the attached example. Thanks for your help.

145564-example.png


office-scripts-excel-dev
example.png (22.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers