If logical value problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run the formula containing the
=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)) function from this
Microsoft Office Help link:
http://office.microsoft.com/en-us/excel/HA012260381033.aspx?pid=CL100570551033


The problem however is that it doesn't work. When I step into the formula
the problem that it tells me it has is that the logical value for
$A$1:$A$7=A10 cannot be calculated since a range cannot be used. My question
is: Is it not working for me only? First I thought I had an outdated version
of EXCEL but I do have 2003 and apparently this formula should work with
2003. Please let me know
 
Did you enter it with ctrl + shift & enter as it says?

There are better ways of doing this btw
 
Have you entered the formula using CTRL + SHIFT + ENTER as instructed?

It is an array formula so needs the above.


Gord Dibben MS Excel MVP
 
Thank you very much. Can you tell me what are the better ways to do this
please. I really need some help.
 

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

Back
Top