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.
I have two cells in Excel. one has a string and the other one has a date. in the third …
excel worksheet-functionA recurring Excel problem I have is formulas such as INDEX(array,row,column) that return 0 when there's no result, …
excel worksheet-functionHow do I get the last character of a string using an Excel function?
string excel worksheet-functionI want to be able to determine how many times a person's particular ID (e.g. #123) has appeared in a …
excel excel-formula vlookup worksheet-function countifWhat function can I use in Excel VBA to slice an array?
arrays excel vba worksheet-functionI have next userform developed in vba, which takes info from a worksheet for displaying info I want to order …
vba sorting excel worksheet-functionI am trying to use COUNTIF in Excel to find how many items in a range match the contents of …
excel worksheet-function countifI have an Excel formula reading data from a column. The data in that column is sometimes a date-like format, …
excel worksheet-function array-formulasHow do you zero fill a number to 10 positions inside an excel spreadsheet? i.e. If cell A1 has 1234 how …
excel formatting worksheet-functionI'd like to be able to dynamically specify a range in Excel, based on row/column variables. Let's say I …
excel worksheet-function excel-2011