Perhaps you did not apply control+shift+enter to the suggested formula.
| A | B | C | D | E |
---|
Invioce No. | Total | | | | |
Invioce No. | Sum Total | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
<COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]11760[/TD]
[TD="align: right"]90.03[/TD]
[TD="align: right"][/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]11105[/TD]
[TD="align: right"]77.63[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11105[/TD]
[TD="align: right"]139.29[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]11173[/TD]
[TD="align: right"]74.92[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11173[/TD]
[TD="align: right"]147.8[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]11871[/TD]
[TD="align: right"]83.29[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11306[/TD]
[TD="align: right"]123.9[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]11334[/TD]
[TD="align: right"]96.34[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11334[/TD]
[TD="align: right"]192.06[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]11908[/TD]
[TD="align: right"]61.27[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11468[/TD]
[TD="align: right"]86.76[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]11961[/TD]
[TD="align: right"]67.38[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11760[/TD]
[TD="align: right"]90.03[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]11105[/TD]
[TD="align: right"]61.66[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11766[/TD]
[TD="align: right"]69.41[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]11334[/TD]
[TD="align: right"]95.72[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11871[/TD]
[TD="align: right"]83.29[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]11766[/TD]
[TD="align: right"]69.41[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11905[/TD]
[TD="align: right"]68.37[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"]11468[/TD]
[TD="align: right"]86.76[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11908[/TD]
[TD="align: right"]61.27[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]11173[/TD]
[TD="align: right"]72.88[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11961[/TD]
[TD="align: right"]67.38[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"]11306[/TD]
[TD="align: right"]69.9[/TD]
[TD="align: right"][/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]11905[/TD]
[TD="align: right"]68.37[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]11306[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</TBODY>
=IF(ROWS($D$3:D3)>$D$1,"",MIN(IF(ISNA(MATCH($A$2:$A$16,$D$2:D2,0)),$A$2:$A$16)))
Control+shift+enter: Press down the control and the shift keys while you hit enter key. If done correctly, Excel itself puts a pair of { and } around the formula in recognition.