Hi Domenic,

Thank you very much for time and assistance. Appreciate suggestion for
filtered data but it really does need to stay in its original location as
is, when filtered.

Appreciate any further assistance to work with filtered data.


D11, copied down:

=IF(C11=C10,0,IF(COUNTIF($C$11:C11,C11)-1,(ROW()-ROW($C$11))-LARGE(IF($C$
11:C11=C11,ROW($C$11:C11)-ROW($C$11)+1),2),ROW()-ROW($C$11)))

....confirmed with CONTROL+SHIFT+ENTER. As far as filtered data is
concerned, one option might be to copy and paste into another location,
and then use the above formula, adjusting the references accordingly

Thanks
Sam

--
Message posted via http://www.officekb.com