Hi,
I have a data set that repeats on same tab of excel with certain information for ex. For given range of dates, I want to see what all items had transactions in system and their respective quantities used in months of a year.
So, data repeats per item and has quantity values for each month depending on the months that had transactions for that item.
Said that, I want to sum these quantities at item level dynamically by using indirect references as I don't know which item will have Qty in which month.
So, its sum of dynamic range in loop.
Has anyone worked on such example before? Can this be achieved by a formula or will it need a macro?
I have a data set that repeats on same tab of excel with certain information for ex. For given range of dates, I want to see what all items had transactions in system and their respective quantities used in months of a year.
So, data repeats per item and has quantity values for each month depending on the months that had transactions for that item.
Said that, I want to sum these quantities at item level dynamically by using indirect references as I don't know which item will have Qty in which month.
So, its sum of dynamic range in loop.
Has anyone worked on such example before? Can this be achieved by a formula or will it need a macro?
