Sorting Data from one table to a second table

%3CLINGO-SUB%20id%3D%22lingo-sub-2190180%22%20slang%3D%22en-US%22%3ESorting%20Data%20from%20one%20table%20to%20a%20second%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190180%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20sort%20the%20data%20in%20a%20second%20table%20I%20created%20based%20off%20the%20data%20in%20the%20first%20table.%20I've%20attached%20a%20screenshot%20to%20help%20clarify%20my%20question.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20the%20data%20in%20%22Table%202%22%20to%20be%20sorted%20by%20the%20data%20in%20Column%20F%20of%20%22Table%201%22%20in%20descending%20order.%20So%20I'd%20Like%20Amex%20%26amp%3B%20Credit%20One%20to%20appear%20on%20the%20first%20two%20lines%2C%20followed%20by%20First%20Premier%2C%20Etc.%20I'd%20also%20like%20all%20the%20data%20in%20Rows%20C%2C%20D%20%26amp%3B%20E%20to%20be%20included.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20there%20is%20probably%20a%20very%20simple%20solution%20to%20this%20-%20but%20I'm%20an%20excel%20novice%20so%20tak%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2190180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! 

 

I'd like to sort the data in a second table I created based off the data in the first table. I've attached a screenshot to help clarify my question. 

 

I would like the data in "Table 2" to be sorted by the data in Column F of "Table 1" in descending order. So I'd Like Amex & Credit One to appear on the first two lines, followed by First Premier, Etc. I'd also like all the data in Rows C, D & E to be included.  

 

I know there is probably a very simple solution to this - but I'm an excel novice so tak

1 Reply

@ddiorio16 Is there a particular reason why you want to duplicate everything in a second table? If there is none, just sort the data in Table1 and add the "Pay?" column to it.

 

Otherwise, a dynamic array formula like below could work, provided you are a MS365 subscriber.

=SORT(FILTER(Table1,Table1[CREDITOR]<>""))