Excel Formula Assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-2336264%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2336264%22%20slang%3D%22en-US%22%3E%3CUL%3E%3CLI%3EI%20maintain%20a%20record%20of%20my%20Funko%20Pop!%20Vinyl%20collection%3C%2FLI%3E%3CLI%3EI%20have%20defined%20names%20for%20Pop_Name%20and%20Sale_Price%3C%2FLI%3E%3CLI%3EI%20am%20attempting%20to%20sort%20all%20my%20pops%20from%20largest%20to%20smallest%20based%20on%20their%20Sale%20Price%20in%20the%20Sell%20sheet%3C%2FLI%3E%3CLI%3EI%20would%20also%20like%20to%20match%20the%20Pop%20name%20to%20the%20sorted%20list%3C%2FLI%3E%3CLI%3EI%20am%20confused%20on%20if%20i%20need%20to%20make%20an%20array%20to%20sort%20and%20display%20the%20list%20of%20if%20there's%20a%20better%20formula%20to%20use.%26nbsp%3B%3C%2FLI%3E%3CLI%3E%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EAny%20help%20is%20appreciated%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2336264%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
  • I maintain a record of my Funko Pop! Vinyl collection
  • I have defined names for Pop_Name and Sale_Price
  • I am attempting to sort all my pops from largest to smallest based on their Sale Price in the Sell sheet
  • I would also like to match the Pop name to the sorted list
  • I am confused on if i need to make an array to sort and display the list of if there's a better formula to use. 
  •  

 

  • Any help is appreciated
0 Replies