I don't know where this brain cramp came from but it is here to stay it seems!
I did this once before, and now for the life of me, I can't recreate it.
Here is what I'm trying to do:
I have a spreadsheet with one worksheet that has my database of students with 6 columns of codes which represent 6 different schools of choice. On another worksheet I have the comprehensive list of codes that exist. I've been trying to count up total number of times my college's code shows up in a particular column.
Can anyone help me with the formula that best fits this scenario?
Thanks in advance!!
I did this once before, and now for the life of me, I can't recreate it.
Here is what I'm trying to do:
I have a spreadsheet with one worksheet that has my database of students with 6 columns of codes which represent 6 different schools of choice. On another worksheet I have the comprehensive list of codes that exist. I've been trying to count up total number of times my college's code shows up in a particular column.
Can anyone help me with the formula that best fits this scenario?
Thanks in advance!!