On Feb 28, 8:33 am, Eric wrote:
Thank T. Valko for your detailed description

Make that a double from me ! Enriching clarification.
Thanks for the link.

Would it be possible to retrieve 300 in Cell C1 for this formula?
Variable seems not able to set within { } .

I played around with a defined range in Biff's formula
which seems to work fine in tests here.

Defined range (created via InsertNameDefine or use namebox)
Limits =Sheet1!$M$1:$M$2
where inputs in M1: 300, in M2: -301

Then in say B1, copied down to B15:
=INDEX(FREQUENCY(A$1:A$15,A1+Limits),1)-1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---