Display Name of 1st through Last

[rkramapo]

Hi

I have a set of data that from a survey linked to names. I have the formulas to pull the rankings but when there is a tie that occurs, it takes the name twice. Is there a way to have it display both names when it is a tie?

[dosydos]

in cell K2 use the following formula:

Please Login or Register  to view this content.

drag across and down

currently names will be spearated by a <space>. You can change this by changeing the red quotation marks to whatever you would prefer.

[TMS]

Try:

=WRAPROWS(TEXTSPLIT(TEXTJOIN("|",,BYROW(B2:I20,LAMBDA(bi,TEXTJOIN("|",,TAKE(SORT(VSTACK($B$1:$I$1,bi),2,-1,TRUE),1))))),"|"),8) 

[TMS]

And, with column and row headings:

=VSTACK({"Ideal Boss Survey","Highest",2,3,4,5,6,7,8},HSTACK(A2:A20,WRAPROWS(TEXTSPLIT(TEXTJOIN("|",,BYROW(B2:I20,LAMBDA(bi,TEXTJOIN("|",,TAKE(SORT(VSTACK($B$1:$I$1,bi),2,-1,TRUE),1))))),"|"),8))) 

[TMS]

Please see Master (TMS) in updated sample workbook.

[AliGW]

None of the suggestions made so far will work in Excel 2019 - they all use functions that exist only in 2024 and 365.

https://bettersolutions.com/excel/fu...-functions.htm

[TMS]

Oops. I didn't check the profile, I just saw the solution from dosydos and went from there

[zbor]

Here is solution for older version:

[TMS]

Thanks zbor.

To keep it simple, just add +COLUMN()*EXP(-20) to the first row: =Jeff!B2+COLUMN()*EXP(-20), =Ana!B2+COLUMN()*EXP(-20), =Nick!B2+COLUMN()*EXP(-20), etc. Then fill down. Nothing else has to change. The existing LARGE formulae will be comparing the adjusted values.

That said, the table could be populated with one formula copied across and down.

K1:

Please Login or Register  to view this content.

[TMS]

Updated sample file attached.

[TMS]

@zbor: thanks for the +COLUMN()*EXP(-20). In the past, I would have used +COLUMN()/1000000, but I think +COLUMN()*EXP(-20) is more aesthetically pleasing . And thanks for the +rep

[zbor]

I would have used +COLUMN()/1000000

First I've put /10000 but it was still too big.. So I didn't had a time or will for guessing.
I could use it from now onward too
Thx for the rep the other day