Forum Discussion

Copper Contributor

Sep 15, 2017

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...

BI & Data Analytics

Need Help

SergeiBaklan

Diamond Contributor

Sep 15, 2017

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
Copper Contributor
Sep 16, 2017
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
- SergeiBaklan
  Diamond Contributor
  Sep 16, 2017
  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-a00e9e476b03#ID0EAAEAAA=2010
Carlos Monssen
Copper Contributor
Sep 15, 2017
was hoping that there was a function like small or large that would do that. Tried your suggestion and it worked. Thanks for that!