Unterhaltung

Nachrichten

1. clacke clacke

   Ok, so if we pretend there's an array literal and engage in some formula language pseudocode, it seems that RANK(x, [43,34,53,34,12]) for x = [43,34,53,34,12] is [2, 3, 1, 3, 5]. I need to figure out a way to make …

   Saturday, 05-Sep-20 04:17:59 UTC von libranet.de
   • clacke

     Yes! I can make a VLOOKUP with the ambiguous values as keys in the left column and the disambiguated values so far as values in the right column.Value will be the same as key, unless the same key is found in keys-s…

     Saturday, 05-Sep-20 04:31:05 UTC
   • clacke

     omg it worked! The linear search always finds the first hit from top to bottom, but I just need to do the calculation bottom-up and the first value found will be the highest value. So if I have a list of 5 lines A1…

     Saturday, 05-Sep-20 04:48:42 UTC
   • clacke

     So for illustration, albeit a horrible one, here's a link to a hashify.me rendering of the markdown with tables that describes the cells, with formulas and with values, required to list 5 prices in ascending order:…

     Saturday, 05-Sep-20 05:43:53 UTC
   • clacke

     Maybe an #OrgMode online spreadsheet even? *wiggles eyebrows*

     Saturday, 05-Sep-20 06:21:03 UTC