If I rate a list, can it be generated on a separate sheet in order of selection.

For example, if the item in A1 is ranked as 10 in C1, can the text in A1 appear in position A10 on sheet 2.

Explorer Asked on 15th September 2017 in Excel for Mac.
Add Comment
  • 1 Answer(s)

    Try using Index Match

    Intermediate Answered on 23rd September 2017.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.