Bold First Instances of data in Column

[mattyp]

Hi Everyone, I'm having a bit of trouble wrapping my mind around making particular updates to a spread sheet. What I'm trying to do is have the script look at a column of data and make only one instance of text bold and leave all the rest of the duplicates alone. I'm going to do more than make the text bold, but that's not my problem. To show what I'm trying to do I made a small list below. What the script needs to do is look at the first cell and make the text Bold. Then ignore all other duplicates of this cell and move onto the next unique cell (Data B) and make that one bold and so on and so forth. Can anyone help me attack this? Everything I've found online uses arrays and I really don't understand how they work. Any help is greatly appreciated!!!




Data A
Data A
Data A
Data A
Data A
Data B
Data C
Data C
Data C
Data C
Data C
Data C
Data C
Data C
Data C
Data C
Data C
Data C
Data C

[Gatti]

Hello!!

You have to define what will be your "iColumn" (if is A, iColumn = 1)

Please Login or Register  to view this content.

[skywriter]

This macro assumes you have a header row. If not let me know and I'll change the code.

Please Login or Register  to view this content.

[mattyp]

Wow you both are amazing! Thank you both very much!! I never have used the "Cell" function much before and that was the missing link for me for sure. Both macros work as intended too. Thank you!!

[YasserKhalil]

@Gatti
Great code but changes the value in A1 .. you missed to set the range in this line

Please Login or Register  to view this content.

It should be

Please Login or Register  to view this content.

@ Bruce
Thank you very much for the code

[Gatti]

@Gatti
Great code but changes the value in A1 .. you missed to set the range in this line

Please Login or Register  to view this content.

It should be

Please Login or Register  to view this content.

@ Bruce
Thank you very much for the code

Oops... tottaly true
My bad

Thanks for the feedback