Thread: How to code it in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bplumhoff@gmail.com is offline
external usenet poster
  
Posts: 136
Default How to code it in excel?
Hello Eric,

If your numbers are in A1:A99, then write into B1:
=IF(ISBLANK(A1),"",INDEX(A1:A$99,MATCH("Z","Z"&A1: A$99,)-1))
[Enter as array formula with CTRL + SHIFT + ENTER]
and copy down to B99.

HTH,
Bernd

Reply With QuoteReply With Quote