PDA

View Full Version : Incrementing the previous value



TheGreatest
07-10-2007, 03:54 AM
Thanks for everybody who had looked into this. I didn't know cross-posting wasn't allowed, so sorry about cousing a confusion.

Thanks again.

RichardSchollar
07-10-2007, 04:05 AM
Hi

It's only reasonable to state that you have croos-posted this elsewhere so that members of this forum do not waste their time on questions tht may have already been answered elsewhere:

http://www.mrexcel.com/board2/viewtopic.php?t=281612

You have been provided with a possible answer at MrExcel.com. If this isn't suitable, perhaps you would be so gracious as to reply to Andrew Paulsom's post.

Bob Phillips
07-10-2007, 04:26 AM
Perhaps you mean an array formula like this

=INDEX($A$1:A15,MAX(IF($A$1:A15<>"",ROW($A$1:A15))))+1