Row and column sum by easy formula

Row and column sum by easy formula. By this formula easily know rows sum and column sum are equal or not . This formula easily identify rows sum and column sum right or wrong.

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.

Page break,Page subtotal,lastly grand total by a click.

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 .

Number to inches and feet by function .

Some time we need how to convert number to inches and feet. It is difficult by normal process but it is easy

Formula to value a click .

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

Odd or even row color easy way.

Some time need to odd row or even row color in ms excel sheet for easy way working.But manually this work is very difficult and time killing .Easy way solve this thing, at first sheet select than go to menu bar click

Date Sum with number.

Date to date sum very easy.But Some time need date sum with number in this time we feel this is difficult...

Error function Different type Symbol in Ms Excel.

Some time we don't know which type of error function by error symbol. So, i explain which symbol which