Forum Discussion
Summarize list based on value?
=INDEX(E$6:E$15,SMALL(IF($AM$6:$AM$15<>"",ROW($AM$6:$AM$15)-5),ROW($A1)))You can try this formula, Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. In the example the formula is in cell B19 and filled across range B19:C22.
If you work with Excel 2019 or later you can apply FILTER.
=FILTER(E6:F15,AM6:AM15<>"")
=INDEX(E$6:E$15,SMALL(IF($AM$6:$AM$15<>"",ROW($AM$6:$AM$15)-5),ROW($A1)))You can try this formula, Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. In the example the formula is in cell B19 and filled across range B19:C22.
If you work with Excel 2019 or later you can apply FILTER.
=FILTER(E6:F15,AM6:AM15<>"")
Thank you for the assist. I am using 365 - the filter formula works great on the row with the names and notes however the notes are not appearing in the section next to the filtered names. May please advise.
Thanks so much again for the help. (img is attached)
- It's not possible to customize the filtered section with color and a resizing border box. In the screenshot the FILTER function is in cell E74. You can drag the formula to cell K74 and the results are spilled in the "filter notes area".
Noted. Thank you again! OliverScheurich
- Also would it be possible to customize the filtered section with color and to create a border box that would resize along with the filter ?
