hi
is there any way to filter columns by top N and bottom N based on values from that column?
hi
is there any way to filter columns by top N and bottom N based on values from that column?
You could sort on that field and then use the Keep rows options?
Rory
You could duplicate the query - get top n in one, bottom n in the other and then append one to the other as your output.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
How do you want to handle ties? In other words, if there were, say, two items with the 5th largest (or smallest) value, do you want them both returned, so you could end up with more than 10 rows for a top and bottom 5 values? Equally, if there were multiple items with the largest value, do you still want the top 5 values?
hi,
there are no duplicates and regarding results with the same value, would be best to have them all in - so it also can be top 10 and bottom 5.
I am looking for a one query solution I already have multiple queries in that file and do not want it to be too messy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks