Posts tagged with 'Excel', page 1 of 5

Excel

Articles tagged with Excel mean they deal with Excel-related topics such as formulas, functions, or procedures specific to Excel.

Improve VLOOKUP

March 29, 2012 by JP

Comments

vlookup image

It's VLOOKUP Week, apparently. So let's get to it.

Continue Reading »

Filed Under: Excel

Tagged With: Excel, formula, vlookup

A simple Pacman game for Excel

February 23, 2012 by JP

Comments

David Sobrinski from Sobrinski Painting sent me a spreadsheet he's very proud of — it's a Pacman game for Excel.

Continue Reading »

Filed Under: Excel

Tagged With: Excel, game, Pacman

Percentage Possible vs. Percentage of Total

September 2, 2011 by JP

1 Comment(s)

Are you using the correct formula to calculate percentage? Did you know there are two different versions of the "percent of total" you can use to get a slightly different look at your data?

Filed Under: Excel

Tagged With: COUNTA, COUNTBLANK, Excel, percentage, total

How'd They Do That: Points to Reach Next Level (Actual)

August 31, 2011 by JP

Comments

In How'd They Do That: Points to Reach Next Level (Simple) we reviewed a simple method for determining current ranking level, next ranking level, and the number of posts needed to reach that level.

In this post we'll go over the actual ranking system used at VBAX and how we can calculate current and next ranking level.

Filed Under: Excel

Tagged With: Excel, Level, position, Rank