sortby

Hi, I've been trying to get my head around how to sort (by multiple criteria) in a filter but can't seem to get it to work. The original filter also included CHOOSECOLS but I have tried to remove that to troubleshoot but without success. The filter (pulling data from a sheet named DATA) is...

Hello This is a list contains some values, I actually want this always randomly changed in new row without duplicates, I use this formula, this formula generate new random list than I manually sort and rearrange the list, and row wise its not duplicate, how I do this with formula, I attached...

Hi, would like to ask for help on this. I need to sort the table (new column with both new and theoretically repetitive tags added weekly) by match and frequency. Any idea how to do that? Example: first line - tag in row matches, most frequent amongst all columns second line - tag in row...

Hello excel experts, I am getting very frustrated by what appears to be a straightforward formula. I have a dynamic array spilling vertically, and various numbers for several years found via xlookup. I want to be able to sort this data, so I made another table to grab the array of GL...