J
jefhal
Thanks Harlan for your help on the cell function. Is there any other wa
to tag a cell that would work in an array formula? I know with a macro
can identify a cell's font properties, but I would like to use
worksheet function and they seem more limited.
Here's how it would be put to use: When the secretary finds out whic
colleges a student has been accepted to, she needs to somehow mar
those college name that are already in the worksheet as "accepted"
This has to be in a way that the "get accepted colleges" function find
the SAT average only for those cells that are "marked". It could be bol
face, italic, different font, color, or a prefix or suffix to the name
I tried adding a tilde to the front of the college name and used th
following array formula, but again, all I get is zeros:
{=AVERAGE(IF(AND(LEFT(StudentNames!$D$2:$R$300,1)="~",MID(StudentNames!$D$2:$R$300,2,25)=CollegeNames!$A4),StudentNames!$T$2:$T$300))}
Best,
Jef
to tag a cell that would work in an array formula? I know with a macro
can identify a cell's font properties, but I would like to use
worksheet function and they seem more limited.
Here's how it would be put to use: When the secretary finds out whic
colleges a student has been accepted to, she needs to somehow mar
those college name that are already in the worksheet as "accepted"
This has to be in a way that the "get accepted colleges" function find
the SAT average only for those cells that are "marked". It could be bol
face, italic, different font, color, or a prefix or suffix to the name
I tried adding a tilde to the front of the college name and used th
following array formula, but again, all I get is zeros:
{=AVERAGE(IF(AND(LEFT(StudentNames!$D$2:$R$300,1)="~",MID(StudentNames!$D$2:$R$300,2,25)=CollegeNames!$A4),StudentNames!$T$2:$T$300))}
Best,
Jef