Hi all- first time posting on here. I'm in a new role that requires much more Excel use than I'm used to and very excited to comb the forums to learn more!
I have a retail sales data set where I'm looking at the customer purchase quantity (e.g., customer purchased 2 units in a transaction) for a large number of different items.
I'm trying to identify the first number > 75% under the cumulative units column (Column H) , then return the associated customer purchase quantity (column B). I can do this (formula is listed in column M), but I need to adjust the INDEX array to only consider rows associated with a specific item number (e.g., item 500 should be limited to rows 2 to 8).
The formula for item #600 should return "6", which is the customer purchase qty associated with the first cumulative units % > 75%.
How can I adjust the function so only rows associated with item number 600 are considered?
Thank you for the help!! i'm very excited to leverage this forum to build my excel skillset.
Bookmarks