Unique Value Easily Identify

By Md.shaiful islam Talukder | 11:15 PM | |
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.

COUNTIF(A:A,A1)=1
At 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!




0 comments :

Post a Comment

Top^