On Nov 18, 9:59*am, Pecoflyer
wrote:
Errrr, quite a bit to read !
Maybe posting a sample of your data will help understand easier?

--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile:http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=31096

Sorry! I thought I had posted some of the data, but in prose. :)

Worksheet: FAC1

A B C D
E F G H I J
3 Variable Benchmark Q1
Q2 Q3 Q4
4 % n
% n % n % n
5 100
110 107 113
6 90
95 94 97
7 10% 10 11%
12 9% 10 10% 11


Worksheet: FAC2

A B C D
E F G H I J
3 Variable Benchmark Q1
Q2 Q3 Q4
4 % n
% n % n % n
5 50
52 47 46
6 48
50 40 45
7 10% 5 11%
6 12% 5 10% 5


Worksheet: FAC3

A B C D
E F G H I J
3 Variable Benchmark Q1
Q2 Q3 Q4
4 % n
% n % n % n
5 36
30 40 32
6 35
30 35 31
7 9% 3 13%
4 5% 2 15% 5


Worksheet: Q1

A B C
D E F G
H
3 Variable Benchmark FAC1
FAC2 FAC3
4 %
n % n %
n
5 ='FAC1'!C5:D5
='FAC2'!C5:D5 ='FAC3'!C5:D5
6 ='FAC1'!C6:D6
='FAC2'!C6:D6 ='FAC3'!C6:D6
7 ='FAC1'!C7 ='FAC1'!D7 ='FAC1'!C7
='FAC1'!D7 ='FAC1'!C7 ='FAC1'!D7


I hope that helps!

Thank you!
Sydney