Looking for a minor enhancement to my sheet.
I have a list of descriptive text in Column A, column D contains values for that text.
In column G I have an aggregate function ranking TOP 10 values (Column D).
EG: =AGGREGATE(14,6,$D$4:$D$200,ROWS($1:1)) to =AGGREGATE(14,6,$D$4:$D$200,ROWS($1:10)) for the top 10.
Since these values are formatted to NUMBER with 2 decimal (0.65) to custom format "General;General;;@" doesn't work in this case.
Problem is, sometimes D4:D200 only has 4 values therefore the remainder of the Top 10 has 0.00 as the result but would like to show NULL, nothing etc.
Is there a way to do that?
Thank you so much
Bookmarks