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