mir994stan
New Member
- Joined
- Jul 18, 2021
- Messages
- 42
- Office Version
- 2016
- Platform
- Windows
Greetings,
I don t know if i made good title, but i have no other idea how to call this question I tried search with some keywords, but with no luck. I was wondering if its possible to write a code to do reverse SumIF, to return all values from colum A whose sum is equal to value is some cell.
I have a table, (not pivot table) with 3 column A, B and C and x rows. In column A are serial numbers, column B have names, and column C have amounts for each serial in column A, all values are in ascending order. What im trying to achive is if i enter a name that exist in column B, in cell lets say L2, and in cell M2 i write a number for example 540. Macro should search for all names in column B and sum all values in column B until its that sum is matched with value from cell M2, and for those sum return all values from column A in order smalles to largest? I made example of how that should work ( i made it manually).
Thanks in advance. If its unclear what i would like to achive, feel free to comment. God bless you.
I don t know if i made good title, but i have no other idea how to call this question I tried search with some keywords, but with no luck. I was wondering if its possible to write a code to do reverse SumIF, to return all values from colum A whose sum is equal to value is some cell.
I have a table, (not pivot table) with 3 column A, B and C and x rows. In column A are serial numbers, column B have names, and column C have amounts for each serial in column A, all values are in ascending order. What im trying to achive is if i enter a name that exist in column B, in cell lets say L2, and in cell M2 i write a number for example 540. Macro should search for all names in column B and sum all values in column B until its that sum is matched with value from cell M2, and for those sum return all values from column A in order smalles to largest? I made example of how that should work ( i made it manually).
Thanks in advance. If its unclear what i would like to achive, feel free to comment. God bless you.