I hv d excel sheet of students info there is one col called attendence i want to count no of prenet and absent students?
It depends on how your Excel workbook is structured. Can you post an example workbook?
Can you send some dummy excel , so that we can tell you the solutions.
it is saying new users cant upload attachments…
Harsh,99,present…like dat only
Use select query to get the count of Absent and Present
Attached solution. It uses hasib08’s solution, but you use
.Length instead of
Processusvierge.zip (20,7 Ko)
Hey @Anthony_Humphries…Got the answer…thanks
Actually the excel is like this
Student Name,1st feb,2nd feb,3 rd feb,4th feb,Total A,Total P
Attached a solution for getting the count based on rows.
Processusvierge.zip (26,4 Ko)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.