Color a Duplicate values in a particular column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Is there a straight forward way to color duplicate value in a column. All I want to do is give Green color to a TRADE ID in column G which are appearing twice and give blue color to a TRADE IDs which are appearing more than twice in column G. I have attached file having 2 sheets named as INPUT (the dataset for colouring) and RESULT (I am looking for) as example. Your help is much appreciated
Thanks
Nikhil
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@HULK
I think we can use the Formula option with PCXML to achieve this.
First we will do a count for TRADE ID and store in a new column "Count".
Use the "Count" to do a conditional formatting while unchecking it from output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the solution @Qiu. This is very helpful.
Is there a way to extract the data in excel format instead of using the Browse tool? Or is there a way to extract the output in excel format from the browse tool?
Thanks.
