Instead of entering the formula with just ENTER, press the CONTROL and
SHIFT keys, then while you have those two keys pressed down hit the
ENTER key. Excel will then place braces {} around the formula, which
will tell you that you've entered the formula correctly.

Hope this helps!

In article ,
"Aviator" wrote:

Domenic,

Thank you for your help. The first question you answered worked out great. I
am still having problems with the other two. Have have played with multiple
combonations of formulas which you sent. Examples below:

=IF(COUNT(E5:E555),INDEX(B5:B555,MATCH(LARGE(IF(MO D(ROW(E5:E555)-CELL("row",E5
)+0,2)=0,E5:E555),2),E5:E555,0)),"Open")

This gives me a value but it's not doing every second row.


=IF(COUNT(E5:E555),INDEX(B5:B555,MATCH(LARGE(IF(MO D(ROW(E5:E555)-CELL("row",E5
)+1,2)=0,E5:E555),2),E5:E555,0)),"Open")

This returns "#NUM!"

Could I be missing an add-on or something? What do you mean with
".... confirmed with CONTROL+SHIFT+ENTER."
Maybe I am doing something wrong. Can you help.

Thank you,

Aviator