Blank rows in Excel

For making suggestions and/or requests for new features you'd like added to EViews.

Moderators: EViews Gareth, EViews Moderator

Post Reply
startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Blank rows in Excel

Postby startz » Mon Jul 27, 2009 9:44 am

It would be nice if there were an option to skip blank rows in Excel files. It's quite common to leave a blank row every fifth entry or so to make data more human-readable.
Top
tchaithonov
Posts: 168
Joined: Mon Apr 13, 2009 7:39 am
Location: New York City

Re: Blank rows in Excel

Postby tchaithonov » Mon Jul 27, 2009 2:09 pm

Wouldn't it easier if you skip the blank rows manually (say, =if(iserror(A1), 1,0), then sort it, and remove the empty rows that way) before you insert the data into eviews?
Top
startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: Blank rows in Excel

Postby startz » Mon Jul 27, 2009 2:26 pm

Well, no. It would be a lot easier if there were a checkbox in EViews to do it for me. :wink:
Top
Post Reply

Return to “Suggestions and Requests”

Who is online

Users browsing this forum: No registered users and 2 guests