Forum Discussion
Contar una frase en toda el libro
Hi, I am trying to count how many times the content fo a cell appears in the whole excel workbook. I have an array where column A has different phrases and in column B I need the count. Any Ideas?
Thanks for your comments.
To be more specific, I want to measure how many hours I am spending on each activity as the year goes on. I have a sheet for every week. If a new activity appears, I'll add it to the table on the right before using it on the table to the left so that the match will be exact. Real table measure activities each "half hour", 8 hour a day.
| Week 1 | day 1 | day 2 | day 3 | Activity | hours spent | |
| hour 1 | team meeting | seminar | O&P Meeting | team meeting | 1 | |
| hour 2 | project 1 | seminar | project 2 | project 1 | 4 | |
| hour 3 | project 1 | project 1 | project 2 | project 2 | 3 | |
| hour 4 | project 1 | report | project 2 | report | 3 | |
| hour 5 | report | vendor visit | report | vendor visit | 1 | |
| O&P Meeting | 1 |
Try the attached: