Thread
:
What is ROW(INDIRECT("1:40")) doing? (array formula)
View Single Post
#
5
Max
Posts: n/a
Oops, typo in line:
LEFT(TRIM(A11),MAX(Exp2 x Exp1))
should read as:
LEFT(TRIM(A11),MAX(Exp3 x Exp1))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
Reply With Quote