COUNTING ENTRIES WITHIN A COLUMN

[Twyne]

How can I calculate number of entries within a single column in SIMS marksheet and display the outcome on another column?

[Esteban_Child_of_the_Sun]

In short you can't easily, what are you trying to achieve? Usually each row is a student's data, so displaying a column count for a marksheet would continually get changes as different people open different marksheets for the same pupil (e.g. class teacher and head of department viewing the course marksheet) Edited January 23, 2017 by Esteban_Child_of_the_Sun

[vikpaw]

Aren't there some functions that rely on number of entries?

You could turn on summary data and that shows you average per column which includes number of entries I think. Not sure how to get that displayed in another column.

I thought there were some average type functions that need this info.

Also if you right click a column and view grade distribution this uses that info.

[Esteban_Child_of_the_Sun]

There is a Position formula which will tell you where in the marksheet a grade falls, but this will give a different value per student. Yes there are plenty of ways of finding the info, just not storing it in a column

[vikpaw]

If Position ignores empty cells, can you do a MAX(Position(ColA)) to get the number of entries in ColA , even if it takes 2 separate formulae?

[RootsSchImp]

I think MAX can only work 'horizontally' looking at one student's result in lots of columns, rather than 'vertically' in one column for lots of students. What's your overall objective here @Twyne? Maybe there's another way?

[vikpaw]

Hmm. Forgot that. I thought there was a way to see the max value in a column for class analysis or some such.

[Twyne]

It seems like its not possible in SIMS. I actually need that to be stored in an aspect for reference on students report card(@ individual reports section). I think I may just have to use manual Data Entry.