Calculate Percent Diff p.66
If you use the fill handle to copy the formula in cell F6 to other cells, Excel automatically copies the formula to cells in hidden rows you drag over. This doesn't really matter, though, since we're only interested in the consolidated numbers and will keep the hidden rows hidden.
Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
