Thread
:
Formula to find cell with data on a row
View Single Post
#
4
Max
Posts: n/a
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
----
Reply With Quote