Array formula in a table

[xrajncajnx]

New question working with tables.

I have the following formula:

Please Login or Register  to view this content.

The formula works fine for the first cell, but when I copy it down the column it returns the results from the first cell to all of the cells.

[xrajncajnx]

Nevermind, I figured it out. By using a direct input method ti returned the results I was looking for. Here is the formula I used in it's place:

Please Login or Register  to view this content.