IF/RANK functions help (situational) included video/excel file 🥴

[RichieRichJPN]

Hi everyone! New user and novice excel user here trying to figure our a solution to a problem. I included a video instead of typing out the question here because it's kind of complicated with the concatenate functions that I'm using. The end-goal of what I'm trying to accomplish is based on a handful of criteria.
The video explains what I'm what I'm trying to do. It's complicated to me being as it's actually multiple subset of things within one.
I tried using the XL2BB function had difficulty getting these tables to transfer over probably since a lot of the equations refer to other parts of the workbook. Again, link to the file and video provided below.

tdlr.... not sure if IF/rank are suitable for what I'm trying to accomplish.
if =>2 sentences are true, then ";additionally," would be used at the end of every sentence proceeding the last sentence in sequence.
if =>3 sentences are true, then ";lastly," must be used on the beginning of the last sentence.
if =>1 sentence is the last in sequence, a "." will be used in the end instead of "; additionally,".

Any help is vastly appreciated!!

YouTube video of excel and explanation

The Excel file to what I'm working with for you to test out the solution

TRUE​	PP True/False	Period True/False	False = 0 True = 1	Total T/F	Rank
FALSE​
Pick	TRUE​	P1	1	7​	1​
PPAFE1	TRUE​	TRUE​	1	Punctuation	2​
PPAFE2	TRUE​	P2	1	; additionally,	3​
PPMix	TRUE​	TRUE​	1	; lastly,	4​
PPSingleSmall	TRUE​	P3	1	.	5​
PPSmartPac	TRUE​	TRUE​	1	Transitional	6​
PPSmartPacPoly	TRUE​		1		7​

=IF(AS6=TRUE,(CONCATENATE(""&M6&" in "&B6&" by "&TEXT(C6,"0.0%")&" ("&SERA!M7&" HC vs. "&SERA!L7&" HC), which resulted in a "&W7&" loss in capacity")),"")
=IF(AS7=TRUE,(CONCATENATE(""&M7&" in "&B7&" by "&TEXT(C7,"0.0%")&" ("&SERA!M8&" HC vs. "&SERA!L8&" HC), which resulted in a "&W11&" loss in capacity")),"")
=IF(AS8=TRUE,(CONCATENATE(""&M8&" in "&B8&" by "&TEXT(C8,"0.0%")&" ("&SERA!M9&" HC vs. "&SERA!L9&" HC), which resulted in a "&W12&" loss in capacity")),"")
=IF(AS9=TRUE,(CONCATENATE(""&M9&" in "&B9&" by "&TEXT(C9,"0.0%")&" ("&SERA!M10&" HC vs. "&SERA!L10&" HC), which resulted in a "&W13&" loss in capacity")),"")
=IF(AS10=TRUE,(CONCATENATE(""&M10&" in "&B10&" by "&TEXT(C10,"0.0%")&" ("&SERA!M11&" HC vs. "&SERA!L11&" HC), which resulted in a "&W14&" loss in capacity")),"")
=IF(AS11=TRUE,(CONCATENATE(""&M11&" in "&B11&" by "&TEXT(C11,"0.0%")&" ("&SERA!M12&" HC vs. "&SERA!L12&" HC), which resulted in a "&W15&" loss in capacity")),"")
=IF(AS12=TRUE,(CONCATENATE(""&M12&" in "&B12&" by "&TEXT(C12,"0.0%")&" ("&SERA!M13&" HC vs. "&SERA!L13&" HC), which resulted in a "&W16&" loss in capacity")),"")

 

[RichieRichJPN]

I have partially solved this using data above on the table and using a lengthier than desired way, however, still running into the expected issue and will repost a new topic..

Thank you!