Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
#Ref! after row deletion
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Fred Smith, post: 3282524"] A date field cannot return 1901/01/00. If the number 0 is formatted as a date, then you will see 1900/01/00. If you want blank instead, you will have to modify your formula in the same way, as in: =if(indirect("A"&row()-1)="","",indirect("A"&row()-2)) Regards, Fred [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
#Ref! after row deletion
Top
