Merge rows of similar data
Solved/Closed
Jay
-
Mar 30, 2010 at 10:21 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 30, 2010 at 11:51 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 30, 2010 at 11:51 AM
Related:
- Merge rows of similar data
- Transfer data from one excel worksheet to another automatically - Guide
- Digital data transmission - Guide
- Download tiktok data after ban - Guide
- Tmobile data check - Guide
- How to be offline in whatsapp when data is on - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 30, 2010 at 11:51 AM
Mar 30, 2010 at 11:51 AM
you can try this
copy the unique value to a new sheet( use advance filter)
The you can use this formula
=MAX(SUMPRODUCT((Sheet1!$A$1:$A$6=$A1) * (Sheet1!B$1:B$6)))
copy the unique value to a new sheet( use advance filter)
The you can use this formula
=MAX(SUMPRODUCT((Sheet1!$A$1:$A$6=$A1) * (Sheet1!B$1:B$6)))