# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# ROWS

## Any value in A also in B

| August 20, 2024 |

I recently received a question: “I have two columns of numbers and want one cell at the top to tell me if any values in column A exist in column B.” In this blog post, we’ll walk through how to accomplish this using some essential Excel functions. Video Objective The question asked how to write…

Read More

## Last Date in Column

| July 23, 2024 |

Hello and welcome to our latest tutorial! Today we’re diving into a common Excel challenge: finding the last date in a column. This is especially useful if you add rows to your data regularly. Let’s explore three different exercises to solve this problem. Video Tutorial Exercise 1: Using the TAKE Function in a Table Step-by-Step…

Read More

## Random Sort in Excel

| May 23, 2023 |

Despite the many ways you can shuffle rows, columns, and cells, there’s no built-in option to random sort in Excel. That can be useful for randomly assigning tasks or responsibilities, selecting samples, and much more. Instead, you can write a formula that allows you to randomly sort any data you select. Video How to Random…

Read More

## Moving, Rolling, and Trailing Averages

| March 19, 2015 |

The terms Moving, Rolling, and Trailing are commonly used to describe the same calculation idea…that we want to operate on the previous say 3, 6, or 12 data rows. In this post, we’ll allow the user to define the number of rows to include and use the OFFSET function to dynamically define the desired range. Objective…

Read More

### Learn by Email

###### Subscribe to Blog (free)
Something went wrong. Please check your entries and try again.