ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro for Excel (https://www.excelbanter.com/excel-discussion-misc-queries/42435-macro-excel.html)

Saurabh

Macro for Excel
 
Hi, i am a MS office excel user, i wanted a macro for a particular function.

What it exactly needs to do is In a population of say 20, 10 items would
total up to a particular number so the macro should identify those 10 numbers
which would total up to that one particular number. IN other words i would
like to know what items, sum of which would give me a specific total.





Herbert Seidenberg

It would take at least
=COMBIN(20,10)*0.05/3600
hours to run the macro.
Are you willing to wait that long?



All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com