It looks like for some reason you've entered the formula in an array of
cells. Instead, enter the formula in H2 only, confirm with
CONTROL+SHIFT+ENTER, and then copy/drag down and across. Also, since
Column G contains no data, adjust the ranges accordingly. Post back if
you need further help...
In article <jmumby.27i92q_1147119010.3468@excelforum-nospam.com>,
jmumby <jmumby.27i92q_1147119010.3468@excelforum-nospam.com> wrote:
> Hey,
>
> Thanks for your help!
>
> I am pretty sure I followed your instructions word for word but I just
> seem to get blank cells now?
>
> You can find the actual spreadsheet here
> http://labtrack.dpn.homeip.net/number_thing.zip
> if you get an opportunity perhaps you can tell me where I am going
> wrong?
>
> Thanks,
>
> Jason
Bookmarks