S Sheri Beri Jan 18, 2010 #1 I wish to find which cells in a range of data add up to a predetermined value.
H Héctor Miguel Jan 19, 2010 #2 hi, Sheri ! I wish to find which cells in a range of data add up to a predetermined value. Click to expand... following is in spanish, but I guess you might want to give a try (?) http://www.teladearana.es/seccion/excel/137-localizar-sumas.html two versions (each with downloadable workbooks): - a vba procedure using solver - an UDF (based on Jimmy L. Day algorithm: -> http://tinyurl.com/3qglnn) hth, hector.
hi, Sheri ! I wish to find which cells in a range of data add up to a predetermined value. Click to expand... following is in spanish, but I guess you might want to give a try (?) http://www.teladearana.es/seccion/excel/137-localizar-sumas.html two versions (each with downloadable workbooks): - a vba procedure using solver - an UDF (based on Jimmy L. Day algorithm: -> http://tinyurl.com/3qglnn) hth, hector.
G Gary''s Student Jan 19, 2010 #3 See: http://www.tushar-mehta.com/excel/templates/match_values/index.html
