Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
numbers question
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="krs" data-source="post: 1840092" data-attributes="member: 67742"><p>I tried this in Excel on my Mac before I posted.</p><p>Worked exactly as advertised - the program basically selects all rows where that cell in the selected column is blank and then deletes those rows and keeps the other rows in the same order (but obviously with no blank rows in between.</p><p>I think this is what you were after.</p><p>Tried to find a similar function in Numbers, but so far have been unsuccessful.</p><p></p><p>PS: I think it makes more sense to try to delete the rows which have the blank column cells first before doing any sorting.</p><p>With sorting one can usually undo the sort, but that is about it.</p></blockquote><p></p>
[QUOTE="krs, post: 1840092, member: 67742"] I tried this in Excel on my Mac before I posted. Worked exactly as advertised - the program basically selects all rows where that cell in the selected column is blank and then deletes those rows and keeps the other rows in the same order (but obviously with no blank rows in between. I think this is what you were after. Tried to find a similar function in Numbers, but so far have been unsuccessful. PS: I think it makes more sense to try to delete the rows which have the blank column cells first before doing any sorting. With sorting one can usually undo the sort, but that is about it. [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
numbers question
Top