Rob Weeks

Main menu

Skip to content
  • Food
  • Geeky
  • Gaming
  • Education
  • Professional
    • Software Development
    • Programme Management
    • Tips & Tricks
  • About Me
    • My Education
    • Work History
    • Curriculum Vitae

Tag Archives: microsoft excel

Sick of having to update VLOOKUP formulas with a new Index after inserting another column?

October 9, 2013

The third parameter to the V/HLOOKUP functions in Microsoft Excel take the column index from the table array to return. For years I specified this parameter by counting the columns and hard-coding the number, which is a pain if a … Continue reading →

Posted in Tips & Tricks | Reply

How to do multiple criteria VLOOKUPs in Excel

October 7, 2013

One of the most powerful features within Excel are the LOOKUPS (VLOOKUP and HLOOKUP), they allow you pull values from other parts of the work book (or other work books) based on some lookup criteria. Here’s a quote from the Excel … Continue reading →

Posted in Tips & Tricks | Reply

Using Regular Expressions for sub strings in Excel

September 30, 2013

Ever wanted to extract a sub string from a cell in Microsoft Excel using a Regular expression? Here’s a Visual Basic snippet that will do just that. Function getRegexGroup(inRegex As String, inValue As String, inGroup As Integer) Set myRegExp = … Continue reading →

Posted in Tips & Tricks | Replies: 2

How to query Microsoft Excel with SQL

September 27, 2013

There have been a few occasions in the office where someone has presented me with an Excel Workbook which really should be a database; multiple sheets, all referring to another and a question like “I need to know the Sum … Continue reading →

Posted in Tips & Tricks | Reply

Tag cloud

PS5 android visual basic linux wordpress battlefield 3 six sigma music microsoft excel rsync java Rogue Company microsoft project requirements backup pasta web hosting italian tomato php

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Powered by WordPress and Foghorn