Top "Worksheet-function" questions

A worksheet function is represented by a keyword in an Excel formula that performs some action on input and returns output to the calling procedure, either a worksheet cell or another function.

How do I sum a named range of values that contains errors?

I have an Excel spreadsheet which imports data from another source that I need to run a calculation on. The …

excel worksheet-function excel-2010
MATCH or VLOOKUP starting from the end of the range

I have a table that looks like this A B ID1 data 123 ID2 data 234 ID1 data 456 ID2 data 567 I am …

excel worksheet-function
Dynamic cell access

My question may seem quite simple but I haven't found the answer yet. In excel, I would like to access …

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

I read a similar question but, was not exactly what I needed and was over my head. I have two …

excel worksheet-function
calling excel worksheet function from excel cell

I have a set of user defined vba functions that sit in an excel module, which are then called from …

module excel worksheet-function worksheet vba
How to implement a resettable, over-ridable, default cell value in Excel?

>> Question summary I want to implement a resettable, over-ridable, default cell value in Excel. By this, I mean …

vba excel excel-formula worksheet-function
Adding previous cell and current cell functions

I like to have an Excel Function for: Previous cell + Current Cell = Current cell to do this function for the …

excel excel-formula sum worksheet-function excel-indirect
Automatically increment sheet reference when dragging formula

I have a formula with the following syntax: =SheetName!E10 and need some way to drag the formula and change …

excel excel-formula worksheet-function excel-indirect
Excel Select Case?

i want to create the "cases" formula for excel to simulate Select case behavior (with multiple arguments and else optional). …

excel vba worksheet-function
INDIRECT with column reference and row reference in different cells

So I have two cells, both referring to another sheet. One cell has the row of the other sheet and …

excel excel-formula worksheet-function excel-indirect