I am trying to create a tool for users to view the $ value of each of the 10 most recent customer orders.
My accounting data is on sheet2: column A contains the customer number, Column B contains the order number, and column C contains the $ value
On sheet1 I have a drop down box in cell A1, this drop down box looks up a unique list of customer numbers contained on sheet3.
On sheet 1 In cells B1:B10 I want each of the 10 most recent $ values of each order. B1 is the most recent, B2 is the second most recent, B3 third most recent, etc.
I can use the maxif formula to find the maximum order number for a given customer, I know that is my most recent order.
However, I dont know what the second most recent order number is for this particular customer.
Im not sure if this is possible to do without a macro. The drop down will be used rapidly to change between customers. I need the results to update as the customer is changed.
Do I need a macro that is triggered by changing my combobox drop down?
My accounting data is on sheet2: column A contains the customer number, Column B contains the order number, and column C contains the $ value
On sheet1 I have a drop down box in cell A1, this drop down box looks up a unique list of customer numbers contained on sheet3.
On sheet 1 In cells B1:B10 I want each of the 10 most recent $ values of each order. B1 is the most recent, B2 is the second most recent, B3 third most recent, etc.
I can use the maxif formula to find the maximum order number for a given customer, I know that is my most recent order.
However, I dont know what the second most recent order number is for this particular customer.
Im not sure if this is possible to do without a macro. The drop down will be used rapidly to change between customers. I need the results to update as the customer is changed.
Do I need a macro that is triggered by changing my combobox drop down?