Home

* Your Work
* Your Career
* Your Passion
* Your Project

Delayed or derailed because your office software is letting you down.

If any of these phrases sound familiar to you, then we need to chat.

  • When did it get so complicated?
  • Technology was supposed to make our working life easier, instead I’m just frustrated.
  • We paid extra for this new software and it doesn’t solve my problem.
  • I seem to spend more time troubleshooting <insert tech here> than actually working on my business.
  • I’ve got this terrific idea for a presentation, but I don’t know where to start.
  • I need help with our office software, but I don’t want to hire another employee and our current staff are too busy.

Let My TechGenie help you.

Blog

Posted on

Excel – Find the Last Row and the AGGREGATE Function

Here is a common scenario for me. I like to apply alternate line formatting on spreadsheets, especially wide spreadsheets. It makes it easier to follow the correct row across the spreadsheet. Here a blue fill is applied to alternate lines. But in this spreadsheet, I wanted to do something a little different. I wanted the …

Continue reading “Excel – Find the Last Row and the AGGREGATE Function”