Thread: FIND method doesn't work in UDF. What's wrong with this code?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default FIND method doesn't work in UDF. What's wrong with this code?
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
Reply With QuoteReply With Quote