Marklarbear
Board Regular
- Joined
- Nov 6, 2003
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
Hi wizards - hopefully this makes sense....
Below is a sample set of a process that I need my team to follow. We run on a 5 week cycle and record the numbers of products sold within a particular week in the cycle (range A2:B16). What I want is a formula in the 2nd table (range A21:B25) that returns the most up to date product sold for that week within the cycle - so it automatically updates the product sold. formulas to go in cells B21 down... hope that makes sense....
Below is a sample set of a process that I need my team to follow. We run on a 5 week cycle and record the numbers of products sold within a particular week in the cycle (range A2:B16). What I want is a formula in the 2nd table (range A21:B25) that returns the most up to date product sold for that week within the cycle - so it automatically updates the product sold. formulas to go in cells B21 down... hope that makes sense....