Sort
Closed
condadopr
Posts
1
Registration date
Friday December 4, 2015
Status
Member
Last seen
December 4, 2015
-
Dec 4, 2015 at 10:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 4, 2015 at 02:46 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 4, 2015 at 02:46 PM
Related:
- Sort
- Chrome sort bookmarks alphabetically - Guide
- Spotify sort by genre - Guide
- Water sort puzzle free download - Download - Puzzle
- Google drive sort by name - Guide
- Reverse sort linux - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 4, 2015 at 02:46 PM
Dec 4, 2015 at 02:46 PM
you can try sumproduct formula, it will return the count of rows where the match occured. This example is checking how many times the combo of A1 and D1 is found
=SUMPRODUCT(1*(A:A&D:D=A1&D1))
=SUMPRODUCT(1*(A:A&D:D=A1&D1))
