Forum Discussion
Solved
Summarize list based on value?
Please advise me on how to create a a summary in the red box area with only names that contains unblank notes. Any help would be much appreciated. Thank you, Monchi
=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<>"")
1. Take down that image as quickly as you can. You've posted an image that contains real names of real people.
2. create a dummy file with fictitious names (copy your real excel sheet and just change names) and then post that file on OneDrive or GoogleDrive and paste a link here that grants edit access to your file. That helps us help you far more effectively than an image.
2. create a dummy file with fictitious names (copy your real excel sheet and just change names) and then post that file on OneDrive or GoogleDrive and paste a link here that grants edit access to your file. That helps us help you far more effectively than an image.