Forum Discussion
Return header of Min value from a range, where first cell in row matches search key.
Hello I need help putting together a formula that solves the following for me. I would like to reference "Sample Sheet 1" using a search key from "Sample Sheet 2" to attach the header of each col...
In B1:
=TEXTJOIN(", ", TRUE, FILTER('Sample Sheet 1'!B$1:E$1, 'Sample Sheet 1'!B2:E2=MIN('Sample Sheet 1'!B2:E2)))
Fill down.
Hello, I would need the formula to be able to choose which row to evaluate for the min based off of the state name. Is there a way to do that with the filter formula? Any way that I tried to set the filter up to evaluate the full range would return the error "FILTER range must be a single row or a single column."
I don't know what other formula to use or how to include it here to work around that.