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/ex...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



--
Regards,

Peo Sjoblom



"FLORERO" wrote in message
...
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/ex...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

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

"Peo Sjoblom" wrote:

Did you enter it with ctrl + shift & enter as it says?

There are better ways of doing this btw



--
Regards,

Peo Sjoblom



"FLORERO" wrote in message
...
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/ex...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

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

On Thu, 21 Jun 2007 14:54:01 -0700, FLORERO
wrote:

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/ex...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