MS Excel and OFFSET formula

[Robert]

[Allan Carr]

I can't work out from your post exactly what you are trying to do. If you can't do it with a standard Excel function, you can write your own in Visual Basic. If you want to send me the workbook, I could have look at at it.

[MartinS]

Originally Posted by Robert

'=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)-1),1)'

Robert
Are you sure the MIN should be preceded with a minus? Surely, you can't offset negative rows when you are starting in A1?
I use dynamic ranges for various things, so I can sort of see what you're up to, but without seeing how the data is in the workbook it's a bit hard to give you a definitive answer. As Alan said, a VBA function may be your answer, but am sure you can do it by modifying what you've got so far.
HTH
Martin