Hi,
In the attached sample, I want only rows which are not null in columns E,H,I,J,K to appear on top. How can I do this
Hi,
In the attached sample, I want only rows which are not null in columns E,H,I,J,K to appear on top. How can I do this
Please don't firget to sign off your last thread before moving on!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Have done as advised
This proposal employs a helper column (P) which may be moved and/or hidden for aesthetic purposes.
The helper column is populated using: =AND(E2<>"",H2<>"",I2<>"",I2<>" ",J2<>"",K2<>"")
The data is then sorted by selecting largest to smallest from the filter/sort drop down in cell P1
Note that row one was inserted into the data.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks