Been trying to do exactly what you posted. However I keep getting a error message saying "The formula you typed is incorrect", I have tried doing the CTRL+SHIFT+ENTER before and after putting in the formula, but no luck. I do have to admit I had only just three days ago heard of the Array formulas so I do not have much understanding of this.
Thank you for your time and patience, I am sure that we will get there eventually
Steve
|