Forum Discussion
Solved
count value in a column based on another column value
Hi, I would like to ask some help regarding this, I want to count the value of column1 base on the value of column2. I want to know how many BM in column1 which is SHS in column2.
| Column1 | Column2 |
| BM | SHS |
| BM | SHS |
| IT | SHS |
| IT | SHS |
| ENGG | SHS |
| ENGG | SHS |
| BM | TER |
| BM | TER |
IT | TER |
| IT | TER |
| ENGG | TER |
| BM | TER |
Thanks, in advance!
2 Replies
- Mahesh0016
Super User
thanks for the help.
but how about if the data is like this and i want to show the result in a card like BM=2(SHS)
Column 1 Column2
BM SHS
BM SHS
BM TER
IT SHS
IT SHS
IT TER
ENGG SHS
ENGG SHS
ENGG TER
Thanks, in advance!
