Forum Discussion
Sorting col large to small with duplicates and putting into a vertical table
I am trying to sort the horizonal values in the first row based upon the values in the second row and have the result be similar to the vertical table to the right I keep getting #num or it only ret...
Dichotomy66This picture shows my final results with the helper columns to the left. The numbers to the right of the colored columns are generated from a totally different table than the one is this problem.After getting the sorts done I then used conditional formatting to get the color indicators. I have tested it now with 3 different data sets of varying size and works great