Forum Discussion

pratik0545's avatar
pratik0545
Copper Contributor
Jul 09, 2021
Solved

How do I obtain the corresponding headers of the values that are responsible for a particular sum

How do I obtain the headers (in the row 1) that are responsible for the result obtained in the cell AV3. Say for all the values that sum up to 780 (cell AV3), sum not exceeding 1000, I want the corr...
  • HansVogelaar's avatar
    HansVogelaar
    Jul 09, 2021

    pratik0545 

    The attached version contains a custom VBA function.

    The workbook is now a .xlsm workbook, so you will have to allow macros when you open it.

Resources