DESCRIPTION Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? See Mr Excel and excelisfun use two methods to create Dynamic Range For Last Ten Numbers in Coulmn: 1. OFFSET function to create dynamic [Read More >>>]
Formula To Report Cell Reference 5 Examples DESCRIPTION See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand [Read More >>>]
Existing Customers In Prospect List? DESCRIPTION See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP [Read More >>>]
The right and very useful place to enhance knowledge
In the above example is it possible, on another sheet, to have the months as shown in column A. Then in B1 input Disk Drives or CD Drives or DVD Drives etc… and then display the numbers for the corresponding title alongside the months?