Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros for sorting entries
Being moderately proficient at general Excel commands, I am looking for help
for setting up a macro to sort entries. My goal is to have one Excel worksheet (ledger) for one bank account, which contains multiple funds within that one account. I have set up the worksheet (ledger) with each fund owning it's own unique number (i.e. 01, 02 03, etc.). Therefore, if an individual gives a designated gift to missions (with the fund number being 03), the formula read something like the following: If column G = 03, then column H (the actual amount given) would be added to J5 (J5 being an arbitrary cell to show the total amount of fund 03). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros for sorting entries
Oops, just found it: SUMIFS
"working4lvg" wrote: Being moderately proficient at general Excel commands, I am looking for help for setting up a macro to sort entries. My goal is to have one Excel worksheet (ledger) for one bank account, which contains multiple funds within that one account. I have set up the worksheet (ledger) with each fund owning it's own unique number (i.e. 01, 02 03, etc.). Therefore, if an individual gives a designated gift to missions (with the fund number being 03), the formula read something like the following: If column G = 03, then column H (the actual amount given) would be added to J5 (J5 being an arbitrary cell to show the total amount of fund 03). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate entries in single column w/o sorting? | Excel Worksheet Functions | |||
Sorting entries out | Excel Discussion (Misc queries) | |||
Sorting numeric and alpha entries | Excel Discussion (Misc queries) | |||
sorting columns with more than 2 text entries | Excel Discussion (Misc queries) | |||
Sorting lists to remove double entries | Excel Discussion (Misc queries) |