COUNTIF(A:A,A1)=1At first click menu bar in format tab find conditional formatting than formula is(look picture) find and use this formula .This formula range change for your need.Enjoy!
Unique Value Easily Identify
Unique value easily Identify by conditional formatting a formula . Some time we are need only unique value from report ,If this report range large difficult to manually find unique value. so ,we are use this formula.
You may also like :
Follow me @ Twitter | Facebook | Subscribe via Email
0 comments :
Post a Comment