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


留言