| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MATCH values on a subtotalled worksheet
Hi
I have 2 worksheets; one of which is made up of subtotals. I want to cross check these subtotals with values in another worksheet. I have tried the MATCH functions and nested IF statements, however, it is including all the data which makes up the subtotals in the calculations. I only require the actual totals themselves, as these match 1:1 with the second worksheet. can any one help ? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete value on worksheet 2 that match values on worksheet 1 | Excel Discussion (Misc queries) | |||
| Printing a subtotalled worksheet | Excel Discussion (Misc queries) | |||
| Sort a Subtotalled List? | Excel Discussion (Misc queries) | |||
| How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) | |||
| Adding a row to a subtotalled range | Excel Programming | |||
Threaded Mode
