Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Totals Please
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Grand Totals with Nested Sub Totals | Excel Discussion (Misc queries) | |||
how to enter totals and sub totals from receipts into excel. | New Users to Excel | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |