Is there a coalesce-like function in Excel?
Learn is there a coalesce-like function in excel? with practical examples, diagrams, and best practices. Covers sql, excel, xls development techniques with visual explanations.
Tag: Excel
Convert XLSX to CSV correctly using python
Learn convert xlsx to csv correctly using python with practical examples, diagrams, and best practices. Covers python, excel, python-2.7 development techniques with visual explanations.
Categories:
Exception (HRESULT: 0x800AC472) when using Excel.Worksheet.Select after calling Excel.Workbook.Sa...
Learn exception (hresult: 0x800ac472) when using excel.worksheet.select after calling excel.workbook.saveas with practical examples, diagrams, and best practices. Covers c#, excel development techn...
Categories:
Excel VBA to Export Selected Sheets to PDF
Learn excel vba to export selected sheets to pdf with practical examples, diagrams, and best practices. Covers excel, vba, pdf development techniques with visual explanations.
Categories:
How to define the amount of the error bar in VBA excel
Learn how to define the amount of the error bar in vba excel with practical examples, diagrams, and best practices. Covers excel, vba development techniques with visual explanations.
Categories:
Combine multiple cells into one in excel with macro?
Learn combine multiple cells into one in excel with macro? with practical examples, diagrams, and best practices. Covers excel, vba development techniques with visual explanations.
Categories:
Using a number in a cell to generate a cell reference
Learn using a number in a cell to generate a cell reference with practical examples, diagrams, and best practices. Covers excel, variables, reference development techniques with visual explanations.
Categories:
Way to run Excel macros from command line or batch file?
Learn way to run excel macros from command line or batch file? with practical examples, diagrams, and best practices. Covers excel, vba, batch-file development techniques with visual explanations.
Categories:
Settling Rank ties in Excel for a Mann-Whitney U-test
Learn settling rank ties in excel for a mann-whitney u-test with practical examples, diagrams, and best practices. Covers excel, statistics, rank development techniques with visual explanations.
Categories:
How to create a bar graph in Excel 2010 by counts?
Learn how to create a bar graph in excel 2010 by counts? with practical examples, diagrams, and best practices. Covers excel, graph development techniques with visual explanations.
Categories:
Application.WorksheetFunction.Match method
Learn application.worksheetfunction.match method with practical examples, diagrams, and best practices. Covers excel, vba development techniques with visual explanations.
Categories:
Why is VBA saying that it has found an 'ambiguous name'?
Learn why is vba saying that it has found an 'ambiguous name'? with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
How do I make a burn down chart in Excel?
Learn how do i make a burn down chart in excel? with practical examples, diagrams, and best practices. Covers excel, charts, excel-2007 development techniques with visual explanations.
Categories:
Drop-down list in Excel cell
Learn drop-down list in excel cell with practical examples, diagrams, and best practices. Covers excel, ms-office, vba development techniques with visual explanations.
Categories:
How to add a named sheet at the end of all Excel sheets?
Learn how to add a named sheet at the end of all excel sheets? with practical examples, diagrams, and best practices. Covers excel, vba, worksheet development techniques with visual explanations.
Categories:
I need to create an excel formula to calculate vacation time with maximum accrual of 240hours
Learn i need to create an excel formula to calculate vacation time with maximum accrual of 240hours with practical examples, diagrams, and best practices. Covers excel development techniques with v...
Categories:
Removing Formats From Entire Worksheet with VBA
Learn removing formats from entire worksheet with vba with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
Skip to next iteration in loop vba
Learn skip to next iteration in loop vba with practical examples, diagrams, and best practices. Covers excel, vba, loops development techniques with visual explanations.
Categories:
Run-time error '1004' - Method 'Range' of object'_Global' failed
Learn run-time error '1004' - method 'range' of object'_global' failed with practical examples, diagrams, and best practices. Covers excel, excel-2007, vba development techniques with visual explan...
Categories:
How to sort by dates excel?
Learn how to sort by dates excel? with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
Add leading zeroes/0's to existing Excel values to certain length
Learn add leading zeroes/0's to existing excel values to certain length with practical examples, diagrams, and best practices. Covers excel, padding development techniques with visual explanations.
Categories:
File extension for tab-delimited values that can be opened by Excel?
Learn file extension for tab-delimited values that can be opened by excel? with practical examples, diagrams, and best practices. Covers spring, excel, download development techniques with visual e...
Categories:
Adding text to a cell in Excel using VBA
Learn adding text to a cell in excel using vba with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
Insert Property of Picture Class
Learn insert property of picture class with practical examples, diagrams, and best practices. Covers image, vba, excel development techniques with visual explanations.
Categories:
Count unique values in a column in Excel
Learn count unique values in a column in excel with practical examples, diagrams, and best practices. Covers excel, unique development techniques with visual explanations.
Categories:
Script for Real Time Quotes from Fidelity
Learn script for real time quotes from fidelity with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
Delete all data rows from an Excel table (apart from the first)
Learn delete all data rows from an excel table (apart from the first) with practical examples, diagrams, and best practices. Covers excel, vba, excel-2007 development techniques with visual explana...
Categories:
Substring in excel
Learn substring in excel with practical examples, diagrams, and best practices. Covers excel, string, excel-formula development techniques with visual explanations.
Categories:
Changing #N/A values in Excel to last non-error value in the spreadsheet
Learn changing #n/a values in excel to last non-error value in the spreadsheet with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
How do I get countifs to select all non-blank cells in Excel?
Learn how do i get countifs to select all non-blank cells in excel? with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
How to save VBA in a in or as Macro
Learn how to save vba in a in or as macro with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
Is there a way to edit a formula in vba
Learn is there a way to edit a formula in vba with practical examples, diagrams, and best practices. Covers excel, vba, formula development techniques with visual explanations.
Categories:
Excel: Pivot table not showing all Fields
Learn excel: pivot table not showing all fields with practical examples, diagrams, and best practices. Covers excel, pivot-table development techniques with visual explanations.
Categories:
Excel to compare parameter values of XML table
Learn excel to compare parameter values of xml table with practical examples, diagrams, and best practices. Covers excel, formula, vba development techniques with visual explanations.
Categories:
Creating Bins/groups in Excel
Learn creating bins/groups in excel with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
PivotTable's Report Filter using "greater than"
Learn pivottable's report filter using "greater than" with practical examples, diagrams, and best practices. Covers excel, pivot-table development techniques with visual explanations.
Categories:
Worksheet function in VBA
Learn worksheet function in vba with practical examples, diagrams, and best practices. Covers excel, vba development techniques with visual explanations.
Categories:
Excel: Can I create a Conditional Formula based on the Color of a Cell?
Learn excel: can i create a conditional formula based on the color of a cell? with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual e...
Categories:
Conditional formatting using AND() function
Learn conditional formatting using and() function with practical examples, diagrams, and best practices. Covers excel, excel-formula, conditional-formatting development techniques with visual expla...
Categories:
excel formula: count unique values only
Learn excel formula: count unique values only with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual explanations.
Categories:
What is the meaning of "&" when dealing with condition formula with cell reference rather than fi...
Learn what is the meaning of "&" when dealing with condition formula with cell reference rather than fixed numbers with practical examples, diagrams, and best practices. Covers excel development te...
Categories:
How to Create an excel dropdown list that displays text with a numeric hidden value
Learn how to create an excel dropdown list that displays text with a numeric hidden value with practical examples, diagrams, and best practices. Covers excel development techniques with visual expl...
Categories:
How to get excel to display a certain number of significant figures?
Learn how to get excel to display a certain number of significant figures? with practical examples, diagrams, and best practices. Covers excel, spreadsheet, rounding development techniques with vis...
Categories:
Remove leading or trailing spaces in an entire column of data
Learn remove leading or trailing spaces in an entire column of data with practical examples, diagrams, and best practices. Covers excel, excel-formula, excel-2010 development techniques with visual...
Categories:
Converting unix time into date-time via excel
Learn converting unix time into date-time via excel with practical examples, diagrams, and best practices. Covers excel, datetime, unix-timestamp development techniques with visual explanations.
Categories:
Simple Pivot Table to Count Unique Values
Learn simple pivot table to count unique values with practical examples, diagrams, and best practices. Covers excel, excel-formula, pivot-table development techniques with visual explanations.
Categories:
Convert Text to Date?
Learn convert text to date? with practical examples, diagrams, and best practices. Covers excel, vba development techniques with visual explanations.
Categories:
How to randomize Excel rows
Learn how to randomize excel rows with practical examples, diagrams, and best practices. Covers excel, random development techniques with visual explanations.
Categories:
Sigma or Summation function in Excel
Learn sigma or summation function in excel with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
Link From excel to open pdf file
Learn link from excel to open pdf file with practical examples, diagrams, and best practices. Covers excel, pdf, hyperlink development techniques with visual explanations.
Categories:
What are .NumberFormat Options In Excel VBA?
Learn what are .numberformat options in excel vba? with practical examples, diagrams, and best practices. Covers excel, vba development techniques with visual explanations.
Categories:
Using OR & AND in COUNTIFS
Learn using or & and in countifs with practical examples, diagrams, and best practices. Covers excel, formula, conditional-statements development techniques with visual explanations.
Categories:
Using SUMIFS with multiple AND OR conditions
Learn using sumifs with multiple and or conditions with practical examples, diagrams, and best practices. Covers excel, sum, conditional-statements development techniques with visual explanations.
Categories:
Wait until Application.Calculate has finished
Learn wait until application.calculate has finished with practical examples, diagrams, and best practices. Covers events, vba, excel development techniques with visual explanations.
Categories:
What does the equals sign in $A$2:$A2=A2 mean?
Learn what does the equals sign in $a$2:$a2=a2 mean? with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
A worksheet function inside a worksheet function
Learn a worksheet function inside a worksheet function with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
TTest in Excel across multiple columns
Learn ttest in excel across multiple columns with practical examples, diagrams, and best practices. Covers excel, statistics development techniques with visual explanations.
Categories:
Calculating a p-value for the spearman's rank statistic in excel (using vba or not)
Learn calculating a p-value for the spearman's rank statistic in excel (using vba or not) with practical examples, diagrams, and best practices. Covers excel, vba, statistics development techniques...
Categories:
Using Excel VLOOKUP() function across two sheets
Learn using excel vlookup() function across two sheets with practical examples, diagrams, and best practices. Covers excel, excel-formula, vlookup development techniques with visual explanations.
Categories:
Excel formula to check date within this week and last week
Learn excel formula to check date within this week and last week with practical examples, diagrams, and best practices. Covers excel, date development techniques with visual explanations.
Categories:
End user difference between .xls and .xlsb?
Learn end user difference between .xls and .xlsb? with practical examples, diagrams, and best practices. Covers excel, vba, ms-access development techniques with visual explanations.
Categories:
Using "If cell contains #N/A" as a formula condition.
Learn using "if cell contains #n/a" as a formula condition. with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual explanations.
Categories:
Excel VLOOKUP and FIND combination
Learn excel vlookup and find combination with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
Use Excel pivot table as data source for another Pivot Table
Learn use excel pivot table as data source for another pivot table with practical examples, diagrams, and best practices. Covers excel, pivot-table development techniques with visual explanations.
Categories:
What is the character code for new line break in excel
Learn what is the character code for new line break in excel with practical examples, diagrams, and best practices. Covers excel, excel-formula, excel-2007 development techniques with visual explan...
Categories:
How to auto-size column-width in Excel during text entry
Learn how to auto-size column-width in excel during text entry with practical examples, diagrams, and best practices. Covers excel, vba, column-width development techniques with visual explanations.
Categories:
Pivot Slicer Update To Slow, Can I pause all functions until slicer update is complete? VBA Excel
Learn pivot slicer update to slow, can i pause all functions until slicer update is complete? vba excel with practical examples, diagrams, and best practices. Covers vba, excel development techniqu...
Categories:
How to remove #DIV/0 errors in excel
Learn how to remove #div/0 errors in excel with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual explanations.
Categories:
Check whether a cell contains a substring
Learn check whether a cell contains a substring with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual explanations.
Categories:
Excel Overtime Calculation
Learn excel overtime calculation with practical examples, diagrams, and best practices. Covers excel development techniques with visual explanations.
Categories:
How to set X axis programmatically on a chart?
Learn how to set x axis programmatically on a chart? with practical examples, diagrams, and best practices. Covers excel, charts development techniques with visual explanations.
Categories:
Creating a List Using Excel Formulas
Learn creating a list using excel formulas with practical examples, diagrams, and best practices. Covers excel, function development techniques with visual explanations.
Categories:
How do you do sumif with equation?
Learn how do you do sumif with equation? with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual explanations.
Categories:
Passing variable from Form to Module in VBA
Learn passing variable from form to module in vba with practical examples, diagrams, and best practices. Covers excel, vba, module development techniques with visual explanations.
Categories:
Return empty cell from formula in Excel
Learn return empty cell from formula in excel with practical examples, diagrams, and best practices. Covers excel, excel-formula development techniques with visual explanations.
Categories:
"And" and "Or" troubles within an IF statement
Learn "and" and "or" troubles within an if statement with practical examples, diagrams, and best practices. Covers vba, excel development techniques with visual explanations.
Categories:
How to filter in excel based on many unique values?
Learn how to filter in excel based on many unique values? with practical examples, diagrams, and best practices. Covers excel, filtering development techniques with visual explanations.
Categories:
How to remove the character "*" in Excel 2010?
Learn how to remove the character "*" in excel 2010? with practical examples, diagrams, and best practices. Covers excel, character development techniques with visual explanations.