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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.