RichieRichJPN
New Member
- Joined
- May 22, 2024
- Messages
- 2
- Office Version
- 2021
- Platform
- Windows
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
=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")),"")
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")),"")
