Download Historical Currency Data into Excel Download Historical Forex Data into Excel
Large and Max in Excel Max function is used to get the maximum of numeric range Large function is used to get the first, second, third Largest values in the range. The second argument can be changed as 1,2,3 etc.
Small and Min in Excel Min function is used to get the minimum of numeric range Small function is used to get the first, second, third smallest values in the range. The second argument can be changed as 1,2,3 etc.
ADDRESS, INDIRECT, OFFSET, INDEX Checks “Test” in A1:A16 range and the matching row. Address will ask for row and column. Row is from Match and column number can be specified. Indirect is used to get the string and convert to value corresponding to that cell. Offset is used to get the range of...
How to capitalize first letter only or first letter of each word in Excel? Use “Proper” function in Excel that converts first letter of each word to caps and others as small letters. Proper(TEST)=Test Proper(“TEST CASE”)=Test Case
Get age from birthday The age can be calculated to years (or) years and months and days https://exceljet.net/formula/get-age-from-birthday =INT(YEARFRAC(birthdate,TODAY())) https://www.lifewire.com/calculate-current-age-datedif-function-3123763 =DATEDIF (E1, TODAY( ),”Y”) & ” Years, ” & DATEDIF (E1, TODAY( ),”YM”) & ” Months, ” & DATEDIF (E1, TODAY( ),”MD”) & ” Days”
Convert text to Date using Excel Vba Using Cdate function using dateserial(date function (year, month, day)) https://stackoverflow.com/questions/20375233/excel-vba-convert-text-to-date
Case statement in Excel vba Select Case test_expression Case condition_1 result_1 Case condition_2 result_2 ... Case condition_n result_n End Select https://www.techonthenet.com/excel/formulas/case.php
Export sheet to PDF in Excel VBA ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "c:\Book1.pdf", Quality:= _ xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ OpenAfterPublish:=True Export Range in a sheet to PDF in Excel VBA Sheets("Sheet1").Range("A1:B1").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "c:\Book1.pdf", Quality:= _ xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ OpenAfterPublish:=True
Time difference in hours as decimal value =Mod(End time-Start time,1)*24 End time and Start time are in time format. Ex: 4:00 pm. http://www.excelfunctions.net/Time-Difference-In-Excel.html https://exceljet.net/formula/time-difference-in-hours-as-decimal-value