My current descending rank formula ignores '0''s
=OFFSET(S$6,MATCH(SMALL(V$6:V$25,ROW()-ROW(V$6)+1),V$6:V$25,0)-1,0)
but I need it to ignore blank cells instead?
Can anyone help, please?
My current descending rank formula ignores '0''s
=OFFSET(S$6,MATCH(SMALL(V$6:V$25,ROW()-ROW(V$6)+1),V$6:V$25,0)-1,0)
but I need it to ignore blank cells instead?
Can anyone help, please?
Not sure how you work out that the formula ignores 0's, they will still be returned as the lowest ranking value(s).
=IF(ROWS(V$6:V6)>COUNT($S$6:$S$25),"",LARGE($S$6:$S$25,ROWS(V$6:V6)))
Will ignore blanks and prevent the #NUM! errors that your formula returns.
I am attaching the file so you can see what I am trying to do.
The worksheet in question is 'Totals' and the columns that are causing problems are N, V-Z
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks