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.
Manually every page break insert row than subtotal is difficult ,if many page in a report. Lastly grand total in last page time waste because Scrolling tab and go to last page . I search this easy way it solve but not find in net .
Formula to value a click .Here use a small Vb code when we copy something then paste another sheet problem face by this formula cell another way some time we face which formula use this are hide this are difficult but everything solve by click because all