Could you attach a sample file which illustrates a slightly wider dataset -- to do this click Go Advanced -> Manage Attachments, and upload from there (the paperclip icon does not work).
The formula should assign an "X" for the given ID where current Type and Value match the smallest and largest values for each - if you have multiple instances of the smallest Type and greatest Value for a given ID you will get multiple Xs, but this can be adjusted:
if the above is not working for you please post a sample file to illustrate -- to do this click GoAdvanced -> Manage Attachments, and upload the file from there (the paperclip icon does not work).
edit: disregard the above, it does not work for your requirement.
Originally Posted by
mimich
I also want to know please what it means 14 and 6 at the beginning of your formula.
the 14 in the above tells AGGREGATE to use LARGE function on resulting array of values
the 6 in the above tells AGGREGATE to ignore Errors that appear in the resulting array of values (we divide the value by the Booleans to generate errors - e.g. 2/FALSE --> #DIV/0!)
the 1 in the above is used as "k" for use with the LARGE -- so it returns the biggest number.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks