Forum Discussion
Solved
I am trying to make the Cell W15 Calculate when the words in V2 and W2 appear in the same row
I am trying to make the Cell W15 Calculate when the words in V2 and W2 appear in the same row between Column B and F and then do the same with V2, W2, X2 but for X15
See attached file.
OliverScheurich I attached my spreadsheet. Seems to be only identifying when a row has 1 of the variables rather than all of them
Which Office version do you work with? If you don't work with Office365 or 2021 you have to enter arrayformulas with ctrl+shift+enter. After doing this formulas return 5, 15 and 22.
- I am Using Office 365. The Value should be that for every time it finds the 2 or the 3 values it counts as 1. So W15 should be 5 as Landy and Carmina re in the same row 5 times and X15 should be 3 as Landy Carmin and Kise are in the same row 3 times
See attached spreadsheet with my suggestion.
- It works but is there anyway i can make the names changable since i tested it and it only works with the names Kise Carmin etc but not when i change it to the cell name