| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Isolate UNIQUE combination of Z cells from a range N that adds up
I have a range of N cells, all in one column and all unique numbers. I also
know that Z cells from this range adds up to a number R. This combination of Z cells is unique, i.e. there is only one combination of Z cells that adds up to R. How can I have these Z cells shown in a separate column? In other words, how can I isolate them? Thanks for any help!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to only show unique cells in range (e.g. B2:B20) | Excel Worksheet Functions | |||
| Sum of unique values within a range with blank cells | Excel Worksheet Functions | |||
| Is there a way to isolate individual cells? | Excel Worksheet Functions | |||
| defining unique range of cells for different sheets as the same n. | Excel Discussion (Misc queries) | |||
| how do I isolate cells to not print | New Users to Excel | |||
Threaded Mode
