Category: Excel Function

Unlike the unique values, the cells without duplicate values are those numbers that only appear once. You can combine the COUNTIF and SUMPRODUCT functions to determine the number of …

The unique value is also called distinct value. When a value appears more than once in a data range, it is only counted once. Example: You are working with …

Odd numbers are not divisible by two (e.g., one, three, five, etc.). When an odd number is divided by two, the remainder is one. You can use the MOD …

Even numbers are divisible by two. When an even number is divided by two, the reminder returns zero. You can use the MOD and SUMPRODUCT functions to count the …

Positive numbers are greater than zero, such as five, fifteen, etc., and negative numbers are less than zero, such as -5, -15, etc. Zeros separate the two groups. You …

Negative numbers are less than zero, such as -5, -15 etc. You can use the SUMIF function to have the sum of the negative numbers, or check here for …