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