Forum Discussion
** HELP ** Need to Join Text but also have superscript
Hi All,
HansVogelaar / SergeiBaklan
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.
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:
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), "")
That would be very complicated. Formulas cannot preserve the format of the cells they refer to, so superscript formatting will be lost.
HansVogelaar
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?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), "")
