On Jul 24, 7:22*am, JAgger1 wrote:
On Jul 23, 10:14*pm, wrote:





Are you trying to count the rows between those two cells? *I am not sure what yo mean by count between values. *There are no values between 3 and 3; but they happen to be 4 rows apart, so would the answer be 4? *Are you always going to go with cells A2 and A7? *Or is always going to be the the two threes? *Please explain what you are trying to accomplish, and I am sure there will be a formula that can figure it out.
Ken

On Monday, July 23, 2012 1:09:14 PM UTC-4, JAgger1 wrote:
Is there a simple formula for getting cell count beween a certain
value? Example:

In column A1:A8 I have the following numbers.

1
3
6
9
6
7
3
2

I would like a formula that can give me the cell count between
A2(number3) and A7(number 3), which would be 4.- Hide quoted text -

- Show quoted text -

Yes, I'm trying to get a row count (in this case it's 4 rows) between
the two values (3),- Hide quoted text -

- Show quoted text -

Better yet, If I have a list of 100 numbers with multiple duplicate's,
can this formula:

=ABS(MATCH(BA1,A1:A100,0)-MATCH(B2,A1:A100))-1 (where B1 & B2 are the
search value, in previous case number 3)

be modified to show the largest row count between duplicates?