- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Excel - Solve for List of Numbers

Subject: | Excel - Solve for List of Numbers |

Posted by: | Brian (blimbe…@stateindustrial.com) |

Date: | 14 Oct 2003 |

Good afternoon - I'm stuck with the highly prized role of correcting

someone elses mistakes, which are numerous. Is it possible that there

is some type of Excel add-in or VBA that could highlight which numbers

in a block of numbers sum to another number?

For example, I have a cell range that contains a block of number eg

A1 - 1

A2 - 20

A3 - 15

A4 - 36

A5 - 47

and I want Excel to highlight or tell me which combination of cells

add up to another number.

For example, if I'd like to solve for 21, I'd like Excel to highligh

cells A1 & A2. If I'd like to solve for 46, Excel would highlight

cells A1, A2, A3.

Any thoughts?

Brian

- Re: Excel - Solve for List of Numbers posted by Bob Umlas on Tue, 14 Oct 2003