Hi all -
I am looking for some help creating a formula.
Column A1:A20 has a satisfaction score between 1 and 10
Column B1:B20 has text (customer comments)
What I need:
Column G1:G10 contains the descending numbers 1 to 10
I would like column H1:H20 to return the longest text from column B based on the satisfaction score (column A to match column G).
Apologies for the long-winded description but my business firewall doesn't allow image or file uploads.
Thanks for any help
SA
Bookmarks