zerokreap
05-31-2011, 01:09 PM
It has been years since I have done any programming, so I apologize in advance for my ignorance.
I have an Excel function that I would like to write, but do not know VBA commands or syntax at all.
I need a function that will scan a set of selected sells in one sheet, and produce output in another. In this column of cells I would have courses listed. For example:
EN102
EN400
SP101
EN102
POLI330
SP101
The function would go through this list, and produce a "de-duped" list of sorts (courses listed more than once in the original, would be listed only once in the output with a "-" and the number of times it appeared next to it. For example, the output for the list above would look like this:
EN102 - 2
EN400
SP101 - 2
POLI330
I assume this would use a loop that would compare the text string in the first cell to all other cells, then the second cell, and so on.
Any ideas on this?
Thanks in advance!
I have an Excel function that I would like to write, but do not know VBA commands or syntax at all.
I need a function that will scan a set of selected sells in one sheet, and produce output in another. In this column of cells I would have courses listed. For example:
EN102
EN400
SP101
EN102
POLI330
SP101
The function would go through this list, and produce a "de-duped" list of sorts (courses listed more than once in the original, would be listed only once in the output with a "-" and the number of times it appeared next to it. For example, the output for the list above would look like this:
EN102 - 2
EN400
SP101 - 2
POLI330
I assume this would use a loop that would compare the text string in the first cell to all other cells, then the second cell, and so on.
Any ideas on this?
Thanks in advance!