I need to thank Joe Chirilov and Danny Khen, from the Excel team at Microsoft for this tip. We were discussing some Excel things while we were having dinner during the summit, and I was bemoaning the fact that it
The last couple of times I've taught, I've received a question about how to deal with the following scenario: You have a table of data, say in A1:A10 In A11, you have the following formula:Â =sum(A1:A10) Someone highlights row A11,
Introduction How many times have you built a table of data, and put totals on it. You ship it out the door, and another user comes along and inserts a new row right before the totals row? If you have
There are three types of spreadsheets built in the world today: The "quick 'n' dirty for your eyes only" type spreadsheet. It doesn't need to be pretty, and doesn't need a ton of time spent making it readable or understandable
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
