Using MIN function to return equal minimum values

Hi,

I would greatly appreciate if someone could help me--I have been searching on here for hours but nothing seems to apply exactly to my problem. Let me give you some context:

I have an Excel worksheet with survey results on love attitudes. I have already created basic SUM formulas to calculate each person's score for each of the 6 kinds of love. But now I need a formula that picks out the MINIMUM score(s) and spits out which type of love (column) they belong to. I want it to include all "ties," so if someone scored equally low in more than 1 type of love, I want it to be brought to my attention as well.

To visualize this, please see attached Excel file.

The function I have in AF2 to make the type of love with the MIN score appear is this:
=INDEX($Z$1:$AE$1,MATCH(MIN(Z2:AE2),Z2:AE2,0))

Thanks bunches for any help you can provide!!

pictures are not data..can't work with them... upload a sample workbook (see signature below for details), then you will probably get a far faster answer a

somegirl, welcome to the forum.

Have a look at the following thread: http://www.excelforum.com/excel-form...-required.html which includes 2 methods to return the results of multiple matches in a single cell.

Hope this helps.

See if this is what you are looking for:Social Psychology Survey_ Love Attitudes2sol1.xlsx
Also did the high readings, as the formula is basically the same, just did a search replace of the MIN to MAX
the formula is a bit cumbersome, but it works...lol

Formula:

Please Login or Register  to view this content.

Hope this helps

You are welcome
The formula is actually rather simple, just looks complex because of the length, all it does is check each cell in the range to see if it equals the lowest value in the range, if it does, add it to the list with a "; " separator,The LEFT() function just strips off the last "; " so that it looks better (also increases the length of the formula...because it needs to do the same calculation twice to get the lenght..but the results look more "Profesional" )
The initial 'IF(' part just says that if the first cell in the range is blank, return a blank, otherwise, find the results !

Hope that made sense !

Well, In a range as small as we are looking at, this works, but if the range gets much bigger, so does the formula ! , sometimes VBA is the right way to go, and some people prefer it
But you are very welcome

Glad to hear you are experimenting with the solution! That is the Best way to learn things !
if you really do not care about the last "; ", this formula is about as short as it gets :

Formula:

Please Login or Register  to view this content.

( I think I remembered all the braces...lol )

You are welcome