Forum Discussion
What is the best way to count a set of data
Hello guys! I encounter the following problem. I need to count number of occurrence of OFF, MC, AL and etc day for James, Jane and John for the set of date range. (as per sample data) Date...
Hi Leow,
For data as here
that could be
=COUNTIF(OFFSET($A$1,1,MATCH(G$1,$B$1:$D$1,0),COUNT($A$2:$A$1000)),$F2)
in G2, drag it down and to the right.
Attached
- Dear Sergei,
Thanks for your tips. It works wonderfully!!Leow, your are welcome
