You need an array formula for this: type this formula

=ADDRESS(SMALL(IF(A1:A10=B1,ROW(A1:A10),65536),3), 1)

then press CTRL+SHIFT+ENTER, not just ENTER

On Thu, 4 Nov 2004 03:44:03 +0800, "Chris" wrote:

3, 1, 1, 2, 1, 2, 2, 2, 1,
3