Hi guys!
I have a feeling this one is difficult if not impossible to solve (probably am not savvy enough with excel for this). Essentially I have two columns, one with names and one with values. Each name has multiple values. Next is I am generating a random array of names. Once the names are generated, I want to return minimum value of the names generated instead of the names themselves. And if there are duplicate names (which there are), would it be possible to return the minimum value for the first one and second most minimum for the second one? I reckon will be needing to create another array and then overlaying them, but I dunno how to even begin writing that.
Note input and output are both supposed to be in dynamic array form. I will generate a list of random names, and from that I would like the minimum values of the generated names (and second most minimum for the duplicates etc)
Thanks all
Bookmarks