Search code examples
Get values from last 3 non-blank cells in a row...


vbaexcelworksheet-function

Read More
Application.Worksheetfunction.Max does not return the largest number in array...


vbaexcelmaxworksheet-function

Read More
How to get the newest value from a column with conditions...


excelworksheet-function

Read More
Excel Nested IF statement with various text conditions...


excelif-statementexcel-formulaworksheet-function

Read More
Excel VBA Worksheet Change Monitoring...


vbaexcelworksheet-function

Read More
Excel - 2 tables in 2 worksheets (Find cell value in Table 2 if 2 cells from 2 tables match)...


excelexcel-formulaworksheet-function

Read More
Excel - How do I remove the items in column 1 from column 2 and put results in column 3?...


excelworksheet-function

Read More
Using conditional formatting to alternate the formatting of data by category...


excelexcel-formulaexcel-2010worksheet-functionconditional-formatting

Read More
Have formula treat value as text, not numeric...


excelworksheet-functionarray-formulas

Read More
How to evaluate a excel formula through XSSF event API...


excelapache-poiworksheet-functionxssf

Read More
Average function in macro not returning value...


vbaexcelaverageworksheet-function

Read More
Excel charts - setting series end dynamically...


excelchartsworksheet-function

Read More
Excel 2010 vba Can I reference the result of a worksheetfunction in another formula?...


excelworksheet-functionvba

Read More
Trying to get the number of Calendar Days/Workdays/Weeks within a set period...


vbaexcelworksheet-function

Read More
SUM but only the last instance / occurrence if there are duplicates in Excel...


excel-formulaworksheet-function

Read More
Automatically increment sheet reference when dragging formula...


excelexcel-formulaworksheet-functionexcel-indirect

Read More
Transform the contents of a column in Excel...


worksheet-functionexcel-2016

Read More
How to return the header by value in a PivotTable...


excelexcel-formulamatchpivot-tableworksheet-function

Read More
WorksheetFunction.CountA() is returning 0 when i dont think it should be...


excelworksheet-functionvba

Read More
Display data from one workbook depending on mapping in a second workbook...


excelexcel-formulaexcel-2010worksheet-function

Read More
Extract multiple first and last names from a string which contains 2 patterns...


arraysexcelstringgoogle-sheetsworksheet-function

Read More
Computing sum of progressively-increasing values in Excel...


excelmathworksheet-functionfinancial

Read More
Highlight Duplicate Column ONLY When Specific Text is Present...


excelvbaduplicateshighlightworksheet-function

Read More
How to convert a value in Excel cell on one sheet to show as a dropdown in another...


c#excelexcel-formulaworksheet-functionexcel-2016

Read More
Returning cell values from other sheets by referencing sheet names from a list...


excelexcel-formulaformulaworksheet-functionexcel-indirect

Read More
How do I only count visible rows when using the COUNTIFS function?...


excelexcel-formulaworksheet-function

Read More
SumIF() Returning 0 Even If I manually Sum() It Is > 0...


excelexcel-2013worksheet-functionsumifs

Read More
Conditional formatting for duplicates except for first value in a repeating column in Excel...


excelconditional-formattingworksheet-function

Read More
Sumproduct as a function in VBA...


excelvbasumproductworksheet-function

Read More
Writing Excel formula using vb.net...


vb.netexcelworksheet-function

Read More
BackNext