| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal help!! ASAP!!!!!!!!! Report due by noon!!!
I am not certain that I can correctly explain what I am looking for so if
this does not make sense please let me know!! :o)) Ok I have 3 columns Account number Account Name Linked account 123456 XYZ Customer 123456 123456 XYZ Customer 654321 The 1st column are my sold to account numbers (billing) and the linked column are my ship to account numbers(shipping locations). What I need to do is get the total linked account numbers, BUT I do not want to count the account number if it is the same as what is in column 1. I have done a subtotal to count at each change in account numbers in column 1 and 3. Does this make sense?!? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUBTOTAL ERRORS - PLEASE HELP ASAP | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| not able to create subtotal summary report | Excel Worksheet Functions | |||
| space after subtotal in report | Excel Discussion (Misc queries) | |||
| move to another cell within a subtotal report within a macro | Excel Worksheet Functions | |||
Threaded Mode
