Forum Discussion
formula for list top ten occurring numbers in a complete spreadsheet
Hi all, i am trying to find a formula for finding the top 10 most occurring number from B5 to U17
ideepdosanjhHi,
A key may be to get all the numbers in one column to easier find and count unique numbers.
FILTERXML("<col><row>" & TEXTJOIN("</row><row>",0,B5:U17) & "</row></col>","//row")FILTERXML and TEXTJOIN can do that and then UNIQUE; COUNTIFS and SORTBY as attached.