确定一组重复，并找到它的最大值/最高值

Unsure if the solution is VBA/Macro or a formula in excel. However the goal is copying Value of the Highest/Max Term # within a group of accounts having the same account name to it's corresponding AValue. [Image below]

不确定解决方案是VBA/宏还是excel中的公式。然而，目标是在一组帐户中复制最高/最大项#的值，这些帐户名称与对应的AValue相同。(下图)

Note: The accounts are already sorted and cannot be sorted to another format as it deals with 7000+ entries

注意:帐户已经被排序，不能按照其他格式排序，因为它处理7000多个条目

1 个解决方案

#1

You can solve your problem through 2 ways:

你可以通过以下两种方式来解决你的问题:

1: You can sort your data based on column A and column B both ascending. then you can insert the following formula in cell D3 and copy it down.

1:您可以根据A列和B列的升序对数据进行排序。然后你可以在单元格D3中插入以下公式并将其复制下来。

=IF(A3=A4;"";C3)

2: You can also use the following formula in cell D3 and copy it down:

2:你也可以在cell D3中使用以下公式，并将其抄下来:

{=IF(MAX($B$3:$B$15*IF($A$3:$A$15=A3;1;0)) = B3;C3;"")}

Note that first you must enter

请注意，首先必须输入

=IF(MAX($B$3:$B$15*IF($A$3:$A$15=A3;1;0)) = B3;C3;"")

=如果(MAX(B美元3:B 15美元*如果(一个3美元:15美元美元= A3;1;0))= B3;C3;" ")

in cell D3 and after finishing the formula and while you are in edit mode, you must press Ctrl+Shift+Enter together. Excel automatically generate the above formula. If you write "{" and "}" manually, the formula won't work.

在单元格D3中，完成公式后，在编辑模式中，必须同时按Ctrl+Shift+Enter。Excel自动生成上述公式。如果您手工编写“{”和“}”，公式将不起作用。

#1