Excel, how can fast match the content of the two cell quickly, for example, in the cell content with top bottom, need another cell and c2 content such as one-to-one correspondence, best can marked,
At present, it is depend on the number of, in the tag, too easy person made a mistake,

CodePudding user response:

Everyone a great god, urgent for solving online

CodePudding user response:

What do you think I understand right,

Such as C1 - C100 100 cell, corresponding to the 100 Top/Bottom

If this is the case,
New TXT documents:
The first line, reproduction C1 - C100, comma
The second line, copy 100 Top/Bottom with comma
Save

The new excel, data & gt; Since the text & gt; Choose just TXT documents to import data, data use commas,
Excel in two lines
The first line of C1 - C100
The second line corresponds to the Top/Bottom

CodePudding user response:

refer to the second floor H4Rr7 response:

what do you think I understand right,

Such as C1 - C100 100 cell, corresponding to the 100 Top/Bottom

If this is the case,
New TXT documents:
The first line, reproduction C1 - C100, comma
The second line, copy 100 Top/Bottom with comma
Save

The new excel, data & gt; Since the text & gt; Choose just TXT documents to import data, data use commas,
Excel in two lines
The first line of C1 - C100
The second line corresponds to the Top/Bottom

Thank you, it is a way,
Finally, how can is the bottom of the c1 - c100 respectively with corresponding to different cell