compressing out zero or blank cells in a row

[Carlos Monssen]

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 without scores so I will have last score, next to last, etc

[#2]

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

[#3]

was hoping that there was a function like small or large that would do that.  Tried your suggestion and it worked.  Thanks for that!

[#4]

trying to determine how to compress cells to left if it is blank or zero.  i have a row of 23 cells, some with scores and so me either blank or zero.  I don't know how to get zeros to look like a blank so the function key works.  Any suggerstions 

[#5]

Hi Carlos,

To show zeros as blank you may apply custom format 

0;-0;;@

More options and details is here https://support.office.com/en-gb/article/Display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e4...