SOLVED

** HELP ** Need to Join Text but also have superscript

Copper Contributor

Hi All,

@Hans Vogelaar / @Sergei Baklan 

Wondering if you can help here and will walk you through what im trying to achieve

Step 1:

In Columns D, we have the name of a Feature/Product but i need to merge Column F then E with Column D but the content in Column F needs to be superscripted.

sbruk89_2-1715768036017.png

 

Step 2:

On tab Formulas, i would like to create XLookup/Filter/Search whereby it pulls through results based on the value of Column A, B & C on "Clean Tab" e.g If i wanted to see everything that was assigned to Global Platform > Launches >New Operators it would pull through the top 9 and so on Global Platform > Launches > New Operators etc etc again the challenge i have is i still need Columns F to be superscripted from Clean tab to be superscripted.

Step 3:

The objective is to essentially be able to pull these data from excel and easily insert into a PowerPoint document as such:

sbruk89_4-1715768530289.png

 




 

4 Replies

@sbruk89 

That would be very complicated. Formulas cannot preserve the format of the cells they refer to, so superscript formatting will be lost.

@Hans Vogelaar 

Thanks for the speedy response Hans, understood about the superscript. Was worth an ask. Would you be able to help with joining the Columns D, F & E based on the values of A, B & C to create a filter/search?

best response confirmed by sbruk89 (Copper Contributor)
Solution

@sbruk89 

Let's say you enter a value for columns A, B and C in A2, B2 and C2 on the Formulas sheet.

To return the matching values from D, F and E:

 

=FILTER(Clean!$D$2:$D$1000&" "&Clean!$F$2:$F$1000&" "&Clean!$E$2:$E$1000, (Clean!$A$2:$A$1000=A2)*(Clean!$B$2:$B$1000=B2)*(Clean!$C$2:$C$1000=C2), "")

@Hans Vogelaar 

Awesome thank you Hans. Just one final thing/question. 

Similar request to before, can you help be write an expression that looks in Column A of "Sheet1" and then pulls through the values for each subsequent column that falls within lets say "launches" so i want New operators to be filled and then New Retail Partners etc 

Again pulling Columns D, F & E from Tab "Clean"

 

sbruk89_0-1715784573877.png

sbruk89_2-1715784787884.png

 

1 best response

Accepted Solutions
best response confirmed by sbruk89 (Copper Contributor)
Solution

@sbruk89 

Let's say you enter a value for columns A, B and C in A2, B2 and C2 on the Formulas sheet.

To return the matching values from D, F and E:

 

=FILTER(Clean!$D$2:$D$1000&" "&Clean!$F$2:$F$1000&" "&Clean!$E$2:$E$1000, (Clean!$A$2:$A$1000=A2)*(Clean!$B$2:$B$1000=B2)*(Clean!$C$2:$C$1000=C2), "")

View solution in original post