Navi_G
Board Regular
- Joined
- May 30, 2018
- Messages
- 94
- Office Version
- 2016
- Platform
- Windows
Hi,
In Illustration i see duplicates and i want to make a list with formula.
other if possible to sum of list idividual with same column like
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
11105 $139.29
11173 $147.80
11334 $192.06
11306 $123.90
Please help on Duplicate and unique list formula and sum of duplicate of total.
I think you better understand my problem.
Thanks
Navi_G
In Illustration i see duplicates and i want to make a list with formula.
other if possible to sum of list idividual with same column like
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
11105 $139.29
11173 $147.80
11334 $192.06
11306 $123.90
Please help on Duplicate and unique list formula and sum of duplicate of total.
I think you better understand my problem.
Thanks
Navi_G