Forum Discussion
Keyamo
Nov 07, 2021Copper Contributor
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
- Nov 07, 2021
See attached file.
Keyamo
Nov 07, 2021Copper Contributor
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
OliverScheurich
Nov 07, 2021Gold Contributor
See attached file.
- KeyamoNov 07, 2021Copper ContributorI managed to figure that one out which is nice shows im learning a bit. I dont wanna be a bother but i posted another discussion about how i wanted it to calculate how often i win with different combos. Do you think this would be possible?
- OliverScheurichNov 07, 2021Gold Contributor
Glad it helped. I forgot the 3 unit combo formula.
- KeyamoNov 07, 2021Copper ContributorThanks alot ill try and mess around with it see if i can work up the 3 Unit combo formula. Appreciate the help alot.