Textjoin multiple columns based on unique values in first column and highest value in another column

[LeonardH]

My title might be confusing. So, here goes.

I'm attempting to create a summary sheet of sorts for a weekly schedule. There are multiple tables throughout the workbook that represent days of the week and tasks for each day. View a portion of one of those tables in my "Thursday" tab below:

I would like for one cell in the summary sheet to call out each unique piece of equipment and add the description of the task with the greatest Total Hours. In other words, based on the sample above, I need a formula for a cell that provides the following output:

BMHT246 - RR KOM 830E AC BED SWAP
BMDZ454 - CAT854K-TIER4-CPM

What I have to this point is shown below:

The formula I currently have is:

=TEXTJOIN(CHAR(10),TRUE,UNIQUE(Thursday!$A$4:$A$25,FALSE))

I really appreciate everyone's help! Thanks in advance.

 

[Eric W]

How about:

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H
1
2
3	Equip	Order#	Priority	Day PM's Bald Shop	Creation	Plan Date	Status	Total Hours
4	BMHT246	9		RR KOM 830E AC BED SWAP				24
5
6	BMDZ454	1		Bent				2
7	BMDZ454	2		CAT854K-TIER-CPM				21
8	BMDZ454	3		a
9	BMDZ454	4		b				4
10	BMDZ454	5		c				1
11	BMDZ454	6		d				2
12
13	BMHT246 - RR KOM 830E AC BED SWAP BMDZ454 - CAT854K-TIER-CPM
Sheet10

Cell Formulas
Range	Formula
A13	A13	=TEXTJOIN(CHAR(10),1,IF(A4:A11<>"",IF(H4:H11=MAXIFS(H4:H11,A4:A11,A4:A11),A4:A11&" - "&D4:D11,""),""))

If there's a tie for the most hours, both tasks will be shown.