Excel: Count rows between two values in a list
Filed in Excel on Nov.01, 2007. Email This article to a Friend
Question: How to count the number of rows between two values
Solution:
=ABS(number)
Returns the absolute value of a number, anumber without its sign.
=MATCH(lookup_value;lookup_array; [match_type])
Returns the relative position of an item in an array that matches a specified value
Related posts:
Excel formula to count cells between two values
What values are missing in List 1 that exists i List 2?
How many common cell values are there in list 1 and 2?
Count unique and duplicates text values in a closed workbook in excel (formula)
Recommended categories
