If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using a list of charges to create a specific sum.
I am trying to separate a list of expenses into two categories. I have
totals for the two categories, but individual charges are not categorized. For example: I know that business expenses total $5500 dollars and personal expenses total $3000. I have a list of 30 individual charges that total $8500. How can I have Excel give me a list (or multiple lists) of those charges that total $5500. I swear I've done this before, but I can't remember how. Any help is appreciated. |
#2
|
|||
|
|||
Hi
there's no build-in function for this. And if you want every matching list this is quite complicated as you have to calculate MANY different possible lists -- Regards Frank Kabel Frankfurt, Germany "ravenkills" schrieb im Newsbeitrag ... I am trying to separate a list of expenses into two categories. I have totals for the two categories, but individual charges are not categorized. For example: I know that business expenses total $5500 dollars and personal expenses total $3000. I have a list of 30 individual charges that total $8500. How can I have Excel give me a list (or multiple lists) of those charges that total $5500. I swear I've done this before, but I can't remember how. Any help is appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I want to randomly fill an array of cells with values from a list I create | shadestreet | General Discussion | 2 | June 21st, 2004 11:59 AM |
Cannot create a new list under mail merge wizard | ccjcic | Mailmerge | 1 | May 5th, 2004 08:40 AM |
Create chart from List Box | Brenda | Charts and Charting | 5 | November 25th, 2003 02:31 PM |