Select Page

## How to calculate median by criteria in Excel

In this guide, we’re going to show you how to run calculate median by criteria in Excel. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....

## How to populate alphabet letters in Excel in 3 ways

You can populate numbers, names of months or weekdays easily by dragging your mouse. However, you can’t populate letters in the same fashion. In this guide, we’re going to show you how to populate Alphabet letters in Excel using three different methods....

## Building a Pricing Application with Ability to Select Multiple Products through Dynamic Dropdowns

Dropdown-style user interface controls are fairly common in online forms. This type of controls help with data organization and help users enter data faster by limiting the users to a set of predetermined options. Dynamic dropdowns take the user experience one step...

## How to create recursive functions in Excel with LAMBDA

Recursive function is a term for describing behavior of a function that calls itself from within its own code. This is necessary for solving a problem where the solution relies on the results from multiple instances of the same problem. In this guide, we’re...

## Function: LAMBDA

LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...

## What is the difference between XLOOKUP and VLOOKUP?

In this article, we are going to show you the differences between XLOOKUP and VLOOKUP functions. Download Workbook Please note that the XLOOKUP function is currently only accessible for Microsoft 365 subscribers. XLOOKUP(lookup_value, lookup_array, return_array,...

## Function: XMATCH

The XMATCH function is a Lookup & Reference function that returns the relative position of a lookup value from a specified array or range. In this guide, we’re going to show you how to use the XMATCH function and also go over some tips and error handling methods....

## Function: XLOOKUP

The XLOOKUP function is a Lookup & Reference function that can find values in a table or a range by row. Similar to the better-known VLOOKUP function, you can use this function to do things like looking up the name or price of a product by its code number. In this...

## How to import XML files into Excel

XML is a common file type for storing and transferring data. In this article, we are going to show you how to import XML files into Excel using two methods: First is a more “direct method” and the other is the Power Query approach. Download Workbook Let...