Forum Discussion
How to find and calculate cells which make up given amount?
Hi Asad,
If simply find the cell you may filter your range or use Find from ribbon menu with Look in Values options. Or you mean something else?
I know the filter method but I want formula.
I have a large range of values and my desired value is 15000. Now I want ot identify the cells and calculate them so they make up this 15000, I already have?
When i didn't catch. You'd like to find the cell with some value (INDEX/MATCH, VLOOKUP, etc.) and after that make some calculations with result; or you'd like to change some cells to make the result as targeted (Solver, etc.); or what?
What exactly "identify the cells" means?
Hello,
I am sharing one snapshot of my data I have. I have a list of values and one target less that total sum. I don't know the vlaues which make up target. I want to find those cells which make up target value. I need the formula which I put in formula bar and get result.
Thanks,
