Forum Discussion
Carlos Monssen
Sep 15, 2017Copper Contributor
compressing out zero or blank cells in a row
I am trying to manage individual players scores we have weekly scores, players do not always play what I want to do is reverse the order of the scores and have last first and compress out any cells w...
SergeiBaklan
Sep 15, 2017Diamond Contributor
Hi Carlos,
To remove blank rows in the range please check this http://www.techrepublic.com/blog/microsoft-office/a-quick-way-to-delete-blank-rows-in-excel/, after that sort as you need
Carlos Monssen
Sep 15, 2017Copper Contributor
was hoping that there was a function like small or large that would do that. Tried your suggestion and it worked. Thanks for that!