Today’s author is Bob Umlas, an Excel MVP since 1994, and author of This isn’t Excel, it’s Magic , a book that is filled with tips and tricks for getting the most out of Excel. This tip is a formula which enables you to access a list of values interspersed
Read More...
Today’s author, Ben Rampson, a Program Manager on the Excel team, talks about cleaning up spreadsheets. I often receive files demonstrating issues customers are experiencing with Excel. Recently I have noticed a common problem in some of these files that
Read More...
I thought this would be interesting to share to see how other Excel folks might have solved this problem. I got a question recently from a customer asking how to automatically take a set of values in one column, say: 1000 5000 600 and repeat each value,
Read More...
