Find Unique list updatable

[Navi_G]

Hi,


In Illustration i see duplicate and unique values. i want to make a Unique list with formula.
other if possible to ignor duplicates Question Table

Invioce No. Total
11760 $90.03
11105 $77.63
11173 $74.92
11871 $83.29
11334 $96.34
11908 $61.27
11961 $67.38
11105 $61.66
11334 $95.72
11766 $69.41
11468 $86.76
11173 $72.88
11306 $69.90
11905 $68.37
11306 $54.00


Desired Result Table

Invioce No.Sum Total
11760 $ 90.03
11871 $ 83.29
11908 $ 61.27
11961 $ 67.38
11766 $ 69.41
11468 $ 86.76
11905 $ 68.37

Please help on how Duplicate value igonr and unique values find with formula list formula.
I think you better understand my problem.

Thanks
Navi_G​

 

[farmerscott]

Have a look at- https://www.mrexcel.com/forum/excel-questions/460780-array-formula-remove-duplicates-list.html

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1057838-find-duplicate-formula-make-idividual-list.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.