I am looking to see if there is a funstion available in Microsoft Excel 2010. I have a balancing issue and want to make the figures balance.
Current I have a colum of cells (P) with 1786 rows. The total for the column is totaling 31,942.93. I want to find out what combination of these cells/figures could be used to make 54.17. Is there a formula availabvle to do this.