I have 9 topics (ColumnA) with a tallied numerical answer(ColumnB) in Excel.
I have used the RANK function in Excel to Rank numerical responses from 1 to
9 in Column C. After that I need to sort them by the rank to be displayed
with the Rank Number and Topic name in Column D only to then have it
paste-linked to a word document. I think I need a macro. Can you help?