cell("prefix",reference) returns wrong results when in array formula

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top