提取个尾的“尾”组合(Extract the tail "tail" combination)

q771021738

New Member
Joined
May 28, 2019
Messages
13
EXCEL表格:https://1drv.ms/x/s!AiDf3QxUtCLkavUxZeMNKZL7DRM

题目:
①计算结果以H2为首个单元格
②计算过程如下:
(1)在G:G区域,数值取尾
(2)A2:F2区域,尾数分别相加,结果取尾
(3)假设RIGHT(A2 + B2)= RIGHT(G2)则把A2与B2的尾数,同放在一个单元格
③组合去重复:例如G4取尾是0 ,A4:F4区域,尾数相加等于0的,只有4和6,有两个4,因此形成46 46两个组合,最终保留一个46组合就可以
④A2:F2例举:
(1)G2是135取尾是5
(2)在A2:F2中,两个尾相加,然后取尾的,只有右(D2 + E2)=右(G2),D2尾是5,E2尾是0,则最终提取05尾,顺序没要求
(3)由以上,得出符合条件的组合是:“05”
 
Re: 提取个尾的“尾”组合(Extract the tail "tail" combination)

我认为“有些词汇”的翻译不是很标准,我哭了。
 
Upvote 0

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Re: 提取个尾的“尾”组合(Extract the tail "tail" combination)

[QUOTE = AlanY; 5286193]还有一个去

https://drive.google.com/file/d/1lWryuzH7LjFOo7YTJkFHh4KuaAHelLjN/view?usp=sharing

一个CdËFGH一世Ĵķ大号

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]102[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]103[/TD]
[TD="bgcolor: #DDEBF7, align: right"]12[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]104[/TD]
[TD="bgcolor: #DDEBF7, align: right"]13[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]105[/TD]
[TD="bgcolor: #DDEBF7, align: right"]14[/TD]
[TD="bgcolor: #DDEBF7, align: right"]23[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

[TD="align: center"]五[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]109[/TD]
[TD="bgcolor: #DDEBF7, align: right"]36[/TD]
[TD="bgcolor: #DDEBF7, align: right"]45[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]223[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="bgcolor: #DDEBF7, align: right"]72[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]10[/TD]
[TD="bgcolor: #DDEBF7, align: right"]46[/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]
[TD="bgcolor: #DDEBF7, align: right"][/TD]

</tbody>
Sheet4

[/引用]

Just saw this form. This is no problem.
Thank you very much!
 
Upvote 0
Re: 提取个尾的“尾”组合(Extract the tail "tail" combination)

問題解決否?
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,304
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top