EXCEL
[find match and index] ref. https://www.get-digital-help.com/index-match-multiple-results/ Target: find the matched number in column B and return the index content in column A with the key in D1, the result is show in column F Step: 1. in F1 fill in the content =INDEX($A$1:$A$11, SMALL(IF(ISNUMBER(MATCH($B$1:$B$11, $D$1, 0)), MATCH(ROW($A$1:$A$11), ROW($A$1:$A$11)), ""), ROWS($A$1:A1))) 2. press 'ctrl+shift+enter' for array mode 3. pull down + symbol and extend Col F [histogram] ref. https://trumpexcel.com/histogram-in-excel/ 1. select result zone, input "frequency(data array, bin array)" 2. ctrl+shift+enter