更新时间:2022-12-12 11:52:41
Use a column of formulas. In B2:
Use a column of formulas. In B2:
=MATCH(D2,A:A,False)
=MATCH(D2,A:A,False)
(IFyou don’t have headers, adjust for use in row 1)
(IFyou don't have headers, adjust for use in row 1)
Copy that down, convert the formulas to values, then sort B:I based on B Ascending.
Copy that down, convert the formulas to values, then sort B:I based on B Ascending.