Forum Discussion
Calculate max sales volume in a given range of data from the last year daily data
I attached that I believe you can use as an example. You should be able to adjust the range references as needed.
Also, the formulas are array formulas and generally require you to hit Ctrl+Shift+Enter. But, the latest version of Excel may not require it, so if you hit Enter and get an error, go back into the formula bar and hit Ctrl+Shift+Enter.
I attached that I believe you can use as an example. You should be able to adjust the range references as needed.
Also, the formulas are array formulas and generally require you to hit Ctrl+Shift+Enter. But, the latest version of Excel may not require it, so if you hit Enter and get an error, go back into the formula bar and hit Ctrl+Shift+Enter.
Brilliant solution. Yes, it works. Thank you very much for your great help. Truly appreciate the quick response.
- You're quite welcome.
