Excel Formulas

SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Ĉ
View Download
Excel Formula to calculate age of a person based on date of birth. Can calculate exact Years/Months/Days  26k v. 2 May 31, 2010, 8:44 AM Yogesh Gupta
ċ

Download
Excel Formula to find closest match to target. This has bot the formulas greater than equal to less than equal to closest match.  249k v. 4 Jan 16, 2010, 8:41 AM Yogesh Gupta
Ĉ
View Download
Standard Countif function can count based on sinle condition only. However with tric you can do multiple condition count  30k v. 1 Oct 31, 2009, 8:50 AM Yogesh Gupta
Ĉ
View Download
EMI Calculator Excel file. Input your figures to know your EMI. Play your figures with Spin Buttons to fine tune your results  56k v. 1 Mar 21, 2010, 8:34 PM Yogesh Gupta
Ĉ
View Download
Standard Sumif function can sum based on single condition only. However with a forluma trick you can do multiple condition count  32k v. 1 Nov 6, 2009, 3:37 AM Yogesh Gupta
Ĉ
View Download
Sum top 5 or bottom 5 values in unsorted range in excel  33k v. 1 Feb 1, 2010, 9:57 AM Yogesh Gupta
Comments