Spreadsheet Help

[PerpetualImperfexion]

I need help with a function that would look at the numbers in certain cells and then show me the highest or lowest one, excluding zero. Thanks in advance.

[Sonic Boom]

Maybe try conditional formatting (assuming you're using microsoft excel v7)?

[PerpetualImperfexion]

Maybe try conditional formatting (assuming you're using microsoft excel v7)?

a. What the fuck is conditional formatting

b. I am using google docs xD

[Sonic Boom]

a. What the fuck is conditional formatting

b. I am using google docs xD

Sorry for the late reply.

In this case, use this for the smalles non-zero number: =SMALL(data range, countif(data range, "=0")+1)

For the largest number: =MAX(data range)

data range is like, for example, A2:D50.

Hope that helps for future problems.