I have data presented in a matrix. I want to have a summary page that analyzes that data. On the Data tab, where the student name and class intersect, I input the period in which a student will take a class. On the analysis tab, I want to know how many classes a particular student has taken. See the attached example. Thanks for any help!!
in c3 of analysis sheet
=COUNT(OFFSET(Data!$C$4,0,MATCH(A3,Data!$C$1:$G$1,0)-1,10))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
@mdw's method is probably more efficient, here is another approach in case you have just a handful of data...
following CSE formula in C3 on Analysis tab:
and then drag-fill down.
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks