I'm trying to run a formula that pulls the smallest value from columns L,O,R,U,and X but I want it to exclude zeros. There are numbers located in between the columns above so I am unable to run the "Small" formula, any suggestions?
I'm trying to run a formula that pulls the smallest value from columns L,O,R,U,and X but I want it to exclude zeros. There are numbers located in between the columns above so I am unable to run the "Small" formula, any suggestions?
Assuming all cells are populated try this for row 2
=SMALL((L2,O2,R2,U2,X2),(L2=0)+(O2=0)+(R2=0)+(U2=0)+(X2=0)+1)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks