| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank then sort then pastelink
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pastelink | Excel Worksheet Functions | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| Microsoft Excel Rank and Sort | Excel Discussion (Misc queries) | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
| "Pastelink" cells not updating | Links and Linking in Excel | |||
Threaded Mode
