ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I take specific rows and move them to the bottom (https://www.excelbanter.com/excel-worksheet-functions/15355-how-can-i-take-specific-rows-move-them-bottom.html)

Mcobra41

How can I take specific rows and move them to the bottom
 
I am still some what new to these Data Sheets and the different types of
functions. Let me show by example what I am trying to do.

A B C D E
F
1DVD MOVIE 16292 14.98 8.99 2140497
2140497
2DVD MOVIE 28264 14.98 8.99 2133826
2133826
3DVD MOVIE 56428 14.98 8.99 2114870
4DVD MOVIE 75638 14.98 8.99 2114869
5DVD MOVIE 35482 14.98 8.99 2111693
2111693
6DVD MOVIE 18792 14.98 8.99 2148557
7DVD MOVIE 27865 14.98 8.99 2133826
2133826

Basically I would like to move rows 3,4,6 to the bottom of the list because
they are missing the information in column F. Like I said I am still
somewhat new on all the features Excel can do and would like any help that
you can provide. Thanks in Advance.

Mcobra41



"Mcobra41" wrote:

I am still some what new to these Data Sheets and the different types of
functions. Let me show by example what I am trying to do.

A B C E F
1DVD MOVIE 16292 14.98 2140497 2140497
2DVD MOVIE 28264 14.98 2133826 2133826
3DVD MOVIE 56428 14.98 2114870
4DVD MOVIE 75638 14.98 2114869
5DVD MOVIE 35482 14.98 2111693 2111693
6DVD MOVIE 18792 14.98 2148557
7DVD MOVIE 27865 14.98 2133826 2133826

Basically I would like to move rows 3,4,6 to the bottom of the list because
they are missing the information in column F. Like I said I am still
somewhat new on all the features Excel can do and would like any help that
you can provide. Thanks in Advance.


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com