Hi Everyone,
I would like A Macro to Calculate the Following Please. I have Used 10
Sets of Numbers for the General Idea of what I would like to Achieve. I
can then Adjust the Macro for Larger Sets of Numbers if Required.
I have 10 Sets of Numbers in the Range C3:H10.
I have 10 Sets of Numbers in the Range J3:O10.
It is Basically Getting the Total Numbers Matched for Each Set of
Numbers in Cells J3:O10 with Each Set of Numbers in Cells C3:H10.
In More Detail :-
I would like the Total Numbers Matched for the Set of Numbers in Cells
J3:O3 with the Set of Numbers in Cells C3:H3, then the Total of Numbers
Matched for the Set of Numbers in Cells J3:O3 with the Set of Numbers in
Cells C4:H4 etc, the Last One Being for the Total of Numbers Matched for
the Set of Numbers in Cells J3:O3 with the Set of Numbers in Cells
C10:H10. The Output of Numbers Matched would be in Cells Q3:Q12.
Then I would like Exactly the Same thing But Using the Set of Numbers in
Cells J4:O4 Matched with ALL the Sets of Numbers in Cells C3:H10. The
Output of Numbers Matched would be in Cells R3:R12.
And so on Until ALL the Sets of Numbers in Cells J3:O10 have Been
Matched with ALL the Sets of Numbers in Cells C3:H10. The Output for the
Last Set of Numbers Matched would be in Cells Z3:Z12.
For Example, Matching the First Three Sets of Numbers in Cells J3:O10
with ALL the Sets of Numbers in Cells C3:H10 would be :-
Set 1 Set 2
Cells C3:H10 Cells J3:O10 Results
-------------------------------------------------
01 02 03 04 05 06 04 05 06 07 08 09 3 2 0
02 03 04 05 06 07 05 06 07 08 09 10 4 3 1
03 04 05 06 07 08 07 08 09 10 11 12 5 4 2
04 05 06 07 08 09 02 03 04 05 06 07 6 4 3
05 06 07 08 09 10 01 02 03 04 11 12 5 6 4
06 07 08 09 10 11 10 11 12 13 14 15 4 5 5
07 08 09 10 11 12 01 02 03 04 05 06 3 4 6
08 09 10 11 12 13 05 06 07 08 09 10 2 3 5
09 10 11 12 13 14 05 06 07 08 09 10 1 2 4
10 11 12 13 14 15 01 03 05 07 09 11 0 1 3
-------------------------------------------------
Thanks Very Much in Advance.
All the Best.
Paul
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!