Excel Guides

Large Numbers in the MOD Function in Excel

The MOD function in Excel is a great way to find the remainder of a division operation. However, it can also be used to find large numbers in a given range. For example, if you have a list of numbers and you want to find the largest number that is divisible by 3, you can use the MOD function. Simply enter the following formula into a cell:

=MOD(LARGE(A1:A10,1),3)

This will return the largest number in the range that is divisible by 3. You can also use this technique to find the second largest number, third largest number, etc. Simply change the 1 in the formula to 2, 3, 4, etc.

You can also use the MOD function to find large numbers that are not divisible by 3. For example, if you want to find the largest number in a range that is not divisible by 3, you can use the following formula:

=MOD(LARGE(A1:A10,1),3)

This will return the largest number in the range that is not divisible by 3. You can also use this technique to find the second largest number, third largest number, etc. Simply change the 1 in the formula to 2, 3, 4, etc.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.