How to Select Odd Numbers in Excel | MOD Function Excel Trick

In this Excel tutorial, you will learn how to select odd numbers in Excel using the MOD function. This simple Excel trick allows you to quickly identify and filter odd numbers from a list of data. In this step-by-step tutorial, we use a student roll number example to demonstrate how the MOD formula in Excel works and how it can help separate odd and even numbers efficiently. This technique is useful when working with student roll numbers, order IDs, invoice numbers, ticket numbers, and large datasets where you need to filter or extract odd numbers quickly. In this video you will learn: • How the MOD function works in Excel • How to identify odd and even numbers • How to filter odd numbers from a dataset • A simple Excel trick that works in Excel 2016, Excel 2019, Excel 2021, and Microsoft 365 This is a quick and practical Excel tip that can save you time when working with numerical data. If you enjoy learning Excel tips and tricks, make sure to subscribe to KnowHow for more Excel tutorials.