Merge rows of similar data
Solved/Closed
Jay
-
Mar 30, 2010 at 10:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 30, 2010 at 11:51 AM
rizvisa1 Posts 4478 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
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Data transmission cable - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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)))