PDA

View Full Version : Arrays, one works one doesnt.



Trigger6
10-14-2007, 07:08 PM
There are 2 files located in the Array.zip file.
These are very simplified excels and need no direction whatsoever.

1. Progress Report.xls (The array Works but is showing duplicate values, dont know why)

2. Master Progress Report.xls (Does not work, however it is the exact same code.)

My question is a 2 part question.

1. Why does Progress Report.xls show duplicate values, and if possible can you offer suggestions to help correct it?

2. Why does Master Progress Report.xls not work , when it is the exact same code?

These are stripped down versions of the real excel files, as you will notice by the formatting.
I have spent hours staring at the 2 formulas and wondering why one works and one doesnt.
Thanks for any help in advance.

~Ryan