
Announcements
Hello,
I'm looking for a effective way that can get rid of CountIf functions.
I'm building an app presenting the attendance of classes. Curently I have 2 SP lists. First one is the class information which defines the dates taking classes. Second one is the record that certain student is shown. I build up an example in excel, see the pic below.
There is a dropdown list for class selection, then the "Dates" can be populated easily by using Split function.
The next step is transforming the StuRcd into the data format I need, and here comes my question. I'm now using lots of CountIf function to determine the column value should be a "V" or an "X". Wondering that is there a better way to do the job? Say if I have 30 students and 20 dates, I then have to CountIf 600 times for a single table. Kind of a waste.
The data structure can be changed also, just need a way to achieve the result table.
Any suggestion would be appriciated.