I am hoping that someone may be able to help with an Excel query (Shaun maybe?). I spent quite a bit of time creating a spreadsheet some months ago (attached) alongside a demo from the excel help guide. However, I need to revisit and do some more work on it but I can't for the life of me remember how I did it or what it is called! The columns represent no. of items sold and the rows a % of income retained. Excel then performs the calculation. I've certainly learned a lesson in that I should either print the helpsheet or at least how to find it again.
Doh - I've remembered what it is called - a 'two-variable data table'. Simple really, but until I hit on the correct name I couldn't get to the help page I wanted. Another senior moment passed!
