LinkBack URL
About LinkBacks
I'm trying to find if there is only 1 low value in a column and if so return the name of the individual that had that value.
Please see attached.
I'm trying to find if there is only 1 low value in a column and if so return the name of the individual that had that value.
Please see attached.
Try:
=IF(B10=1,INDEX($A$1:$A$7,MATCH(B9,B$1:B$7,0)),"")
copied across
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Is this ok?
=IF(COUNT(MIN(B1:$B$7))=1;LOOKUP(MIN($B$1:$B$7);$B$1:$B$7;A1:A7);"")
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks