On 2002-07-03 02:16, ljvb wrote:
Aladin, thanks for the post. This is clost but doesn't work because the if statement puts zeros in if the logical statement is false, which defeats the purpose of trying to select the zeroes out. I slightly modified what you sent to change the if statement to put a large number in if the logical statement is false (i.e. zero values) and that seems to work. I also changed the >0 to <>0 because I was looking for non zero entries.
=OFFSET(A2,0,MIN(IF(2:2<>0,COLUMN(2:2),EXP(100)))-1,1,)
Thanks.