View Single Post
  #4   Report Post  
Max
 
Posts: n/a
Default

If you want the cell address (relative),

Put in say, A2, and array-enter
(press CTRL+SHIFT+ENTER):
=ADDRESS(ROW(1:1),MATCH(TRUE,1:1<"",0),4)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----