Hello everyone!

This is my first post and I'm somewhat new to excel VBA. Here we go....

I have an excel sheet with numbers in column A. For instance:

A1 = 1
A2 = 2
A3 = 3
A4 = 2
A5 = 1
A6 = 2
A7 = 5
A8 = 2

What I would like to do, for all cells in column A, is to find the instances of duplicate values, then perform a function in that row.

The code would do nothing for A1, A2, A3, A7 because they are unique values.
For A4, A5, A6, A8 (duplicates), the macro would then do another function in the same row. My coding is poor but the wording would look like this...."IF A4 appears in any cells above, THEN C4 = B4".

Thanks for any help. Let me know if you need any further info.

-Chris