Within my speardsheet I have a row which contains different values
increasing from 0 to 1,000.

Each time these values increase by 100, I need to be able to
automatically return another number, say 20 in a different row.

Eg

row of data: 0 10 52 87 91 101 135 168 189 225 265
etc.
required result: 20
20

I'd be grateful for any help anyone can give me.




--
Puzzled
------------------------------------------------------------------------
Puzzled's Profile: http://www.excelforum.com/member.php...o&userid=31908
View this thread: http://www.excelforum.com/showthread...hreadid=528449