Hello,
I have been on this my whole day. Still could not figure out a way.
I need to lookup some values from a list for instance: A2:A10 based on the value of B2. The value of B2 must be the sum total of the filtered values. In the below example, I need to filter out the data whose sum total will be 30. Eventually, the output should be 10, 15 and 5. Is this possible using Excel formula? If not, can you please share a VBA code to do this?
Thank you in advance!
I have been on this my whole day. Still could not figure out a way.
I need to lookup some values from a list for instance: A2:A10 based on the value of B2. The value of B2 must be the sum total of the filtered values. In the below example, I need to filter out the data whose sum total will be 30. Eventually, the output should be 10, 15 and 5. Is this possible using Excel formula? If not, can you please share a VBA code to do this?
Thank you in advance!
Attachments
Last edited: