Forum Discussion
Solved
Two values in a cell
Hello, I was looking for write two values in a single cell to count them. For example, the attached image shows cell1 having values 1 and 2; cell2 only 1 and cell3 3 and 1. I want excel to count ...
=COUNT(SEARCH(1,D6:D8))Maybe with this formula if you want to count the number of occurrences. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=COUNT(SEARCH(1,D6:D8))Maybe with this formula if you want to count the number of occurrences. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- It works!! I appreciate.
