I have 20,000 data in excel. If I add some numbers I will get sum 694,569.
Its very difficult to find out in such a big sheet.
Is there any formula/Macro to know those numbers?
This is permutation and combination related.
regards
vishu

when you say 'add some numbers' do you mean like with a sum if???

example
your numbers are ( 1,2,3,4,5,6,7,8,9,10 )

BUT you only want to add ( 3,4,5,8,9 )

so your total is 29

and you want to know what numbers were added??

If this is correct, Make a pivot table. it can group the numbers how you
want to add them, then if you double click a total (aggregation) Excel will
put ALL the numbers that made up the total on a new worksheet.

"vishu" wrote:

I have 20,000 data in excel. If I add some numbers I will get sum 694,569.
Its very difficult to find out in such a big sheet.
Is there any formula/Macro to know those numbers?
This is permutation and combination related.
regards
vishu

Let me put it in correct way.
Say for example: I have numbers (50, 52,53,62,,92, 93, 95, 96, 94, 25,
125,135, 139, 157, 252, 296, 365, 355, 452, 453)
You can add any numbers. But Total should be 1,200.
I want know all combination of all numbers.
Please tell me how do I get all combinations.
regards
vishu

"TomHinkle" wrote:

when you say 'add some numbers' do you mean like with a sum if???

example
your numbers are ( 1,2,3,4,5,6,7,8,9,10 )

BUT you only want to add ( 3,4,5,8,9 )

so your total is 29

and you want to know what numbers were added??

If this is correct, Make a pivot table. it can group the numbers how you
want to add them, then if you double click a total (aggregation) Excel will
put ALL the numbers that made up the total on a new worksheet.

"vishu" wrote:

I have 20,000 data in excel. If I add some numbers I will get sum 694,569.
Its very difficult to find out in such a big sheet.
Is there any formula/Macro to know those numbers?
This is permutation and combination related.
regards
vishu