hermac@pandora.be wrote:
> Thanks Niek.
> You taught me something important.
> Do you have any suggestions on how to get that row number, either with
> a UDF or a WS function ?
> Herman
>
If the functions in the freely downloadable file at
http:/home.pacbell.net/beban are available to your workbook

=INDEX(ArrayMatch("CRIT",SAR),1,1)+ROW(SAR)-1

Alan Beban