Searching two columns and displaying a third
Closed
ahmetcandan
-
14 Jul 2018 à 03:50
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 16 Jul 2018 à 12:18
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 16 Jul 2018 à 12:18
Related:
- Searching two columns and displaying a third
- Searching in vim - Guide
- How to delete columns in word - Guide
- Spybot search and destroy - Download - Antivirus
- Display two columns in data validation list but return only one - Guide
- How to search for a word on a web page chrome - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
16 Jul 2018 à 12:18
16 Jul 2018 à 12:18
Hi ahmetcandan,
I've got a solution for you, although it might not be the best:
Reserve 2 extra columns.
Column G:
Enter '1' in G1 and drag it down.
Column H:
Enter formula in H1:
=SUM(($A$1:$A$8=$F$1)*($B$1:$B$8=D1)*($G$1:$G$8))
Confirm this formula by hitting Ctrl+Shift+Enter as this is an array formula.
Drag the formula down ( make sure the number of rows are correct ).
And finally the formula in column E:
=INDIRECT("C"&H1)
Drag the formula down.
Kind of a workaround. Keep in mind that column G and H can be placed out of sight, be hidden , text be made white or placed on a different sheet. To keep the same look.
Best regards,
Trowa
I've got a solution for you, although it might not be the best:
Reserve 2 extra columns.
Column G:
Enter '1' in G1 and drag it down.
Column H:
Enter formula in H1:
=SUM(($A$1:$A$8=$F$1)*($B$1:$B$8=D1)*($G$1:$G$8))
Confirm this formula by hitting Ctrl+Shift+Enter as this is an array formula.
Drag the formula down ( make sure the number of rows are correct ).
And finally the formula in column E:
=INDIRECT("C"&H1)
Drag the formula down.
Kind of a workaround. Keep in mind that column G and H can be placed out of sight, be hidden , text be made white or placed on a different sheet. To keep the same look.
Best regards,
Trowa