Erlandsen Data ConsultingThe custom function below will return unique items from a range, you just supply the range you want to get the unique items from and the index number for the unique item you want to return. You can also use the function to return the count of uniqe values/items in a range. Function UniqueItem(InputRange As [...]
Excel has several functions that can return information from your own custom tables in many different ways. Here are some of the most common functions, followed by some examples on how to use them: VLOOKUP(value,range,columnindex,sorted) This function searches for a given value down the rows in the first column in the given range, and returns [...]
Excel has several database functions that can be used to analyze data stored in tables or databases. A table or a database is a range containing at least one column with data and two or more rows. The first row in each column contains the column heading, also called the fieldname. It’s common to define [...]