Copy a column from one sheet and paste as row in another using application worksheetfunciton match i...

Runtime error 1004. Need to fetch value from another sheet in same Excel file...

Can't get WORKDAY function to work with a COUNTIF...

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

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

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

Excel Nested IF statement with various text conditions...

Excel VBA Worksheet Change Monitoring...

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

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

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

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

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

Average function in macro not returning value...

Excel charts - setting series end dynamically...

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

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

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

Automatically increment sheet reference when dragging formula...

Transform the contents of a column in Excel...

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

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

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

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

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

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

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

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

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

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