Forum Discussion
Imbedding text and column values into a cell
We have a worksheet that shows some graph data and needs additional explanation, with imbedded words from a column. The graph shows an emotional characteristic (IE - Dominated or Controlled) based on...
Guessing the form has nothing to offer for help on this! Norm_Jennings
If you have the TEXTJOIN function, you could try the formulas in the attached workbook. If not, then I wouldn't know a way to do it w/o vba.
It uses a named formula, RANKINGS, to map the column numbers in order from largest to smallest and provide a crosswalk. So, when changing the ranges to your data, be sure to change that one as well.
Also, if you have the latest excel version, you could modify it to use newer functions (LET, FILTER) that would allow you to incorporate the named formula and eliminate the IF statement to filter the false's out of your data (or someone here may yet offer a more modern solution).
