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






Leave a Reply