如何重新排序或排序基于一列的列数 [英] How to Rearrange OR sort Number of columns based on one column
问题描述
亲爱的先生，
晚上好。我需要你帮助的人在excel做以下安排。同一张表中有两组数据。 First Set仅为A列。 Seond set是C列到I列。现在第二组数据需要像列A
一样排序/排列（A列和D列应匹配）。预期产出也给出。请帮助。感谢您的努力。
Good evening. I need help from you people to do the following arrangement in excel. There are two sets of data in the same sheet. First Set is column A only. Seond set is column C to I. Now the second set of data need to be sorted/arranged like column A (column A and column D should match). Output expected is also given. Kindly help. Thanks for your efforts.
A
A
B
B
C
C
D
D
E
E
F
F
G
G
H
H
我
I
10MAT31
C1
10CSL37
69
56
67
45
82
10CS32
C1
10MAT41
78
60
41
45
36
10CS33
D2
10CS35
65
66
60
49
82
10CS34
C1
10CSL38
72
80
72
58
81
10CS35
D3
10CS34
40
12
25
20
47
预期输出
EXPECTED OUTPUT
A
A
B
B
C
C
D
D
E
E
F
F
G
G
H
H
我
I
10MAT31
C1
10MAT31
47
51
41
44
51
10CS32
C1
10CS32
44
40
46
36
47
10CS33
F1
10CS33
48
43
26
27
48
10CS34
D3
10CS34
40
12
25
20
47
10CS35
D2
10CS35
65
66
60
49
82
10CS36
E1
10CS36
45
46
40
40
47
推荐答案
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.
这篇关于如何重新排序或排序基于一列的列数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
