Need Help to find an excel formula

Question

I have some data in Column A such as 1-2-3-0-5-2-1 and in column "B" A-F-E-G-C-B-D now I want to sort column A and B's Data based on Column A's Value then what will be the formula if I want to rearrange them in another two cells. I got a formula to sort Column A's Value =SORT(FILTER(A1:A8,A1:A8 <>0)) but I want to sort both columns in a single formula Image one for Existing Data and image two what I Looking for

I want to sort both columns in a single formula

Try: `=SORT(FILTER(A1:B7,A1:A7<>0),{1,2})` but there is no image two — Mayukh Bhattacharya, Jul 29 '23 at 11:10
Thank you so much for for your help @MayukhBhattacharya It works perfectly for me. — Alauddiin, Jul 29 '23 at 11:36

score 1 · Accepted Answer · answered Jul 29 '23 at 11:38

1

Since OP mentioned as the given formula is working for them hence posting it as an answer.

Try:

• Formula used in cell D1

=SORT(FILTER(A1:B7,A1:A7<>0),{1,2})

answered Jul 29 '23 at 11:38

Mayukh Bhattacharya

12,541
5
21
32

Need Help to find an excel formula

1 Answers1