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.

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.