Archive for the ‘ Microsoft ’ Category
So let’s say you’re working in Excel 2007. You’ve got a workbook with many worksheets inside, and you need to create a cell reference from one sheet to another. But what happens if you have hidden rows in the sheet you’re referencing from? Depends on how your options are set. One of the things I noticed [ READ MORE ]
Way to go, Microsoft… hiding shit from me. So as part of this new database development project I’ve been working on, I’m having to normalize and unwind an unwieldly Excel sheet that’s chock full of intermixed data within the same columns. Values, ranges of values, integers, currency, percentages, and text. Yeah. As part of the conversion process [ READ MORE ]