Is there a reason you cannot use Autofilter option?
Highlight the Header Row
Click DATA - FILTER - AUTOFILTER
Now click the arrow in the Header of your choice, and select Display "Not 0"

Rgds
Steve

"searcher" wrote:

I have a group of cells that are mostly 0. I want to display a list of the
cells that aren't 0. I was able to use this formula for the first cell:
=IF(B1140,B114,IF(B1150,B115,IF(B1160,B116,IF(B 1170,B117,IF(B1180,B118,IF(B1190,B119,IF(B1200 ,B120,IF(B1210,B121,0))))))))

I can't figure out how to make the second and third row work.
Any help is greatly appreciated!