All articles with 'OFFSET()' Tag

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Published on Feb 2, 2010 { 7 Comments }
Data Validation using an Unsorted column with Duplicate Entries as a Source List
Continue »

Top X chart – Show Top X values of a chart Interactively

Published on Nov 12, 2009 { 3 Comments }
Top X chart – Show Top X values of a chart Interactively
Continue »

Excel Links of the week [After a long time edition]

Published on Nov 9, 2009 { 1 Comment }
Excel Links of the week [After a long time edition]
Continue »

Making a chart with dynamic range of values

Published on Oct 15, 2009 { 6 Comments }
Making a chart with dynamic range of values
Continue »

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Published on Aug 24, 2009 { 7 Comments }
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Continue »

Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]

Published on Aug 17, 2009 { 2 Comments }
Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Continue »

Calculate Moving Average

Published on Apr 28, 2009 { 28 Comments }
Calculate Moving Average
Continue »

Visualizing Search Terms on Travel Sites – Excel Dashboard

Published on Jan 19, 2009 { 10 Comments }
Visualizing Search Terms on Travel Sites – Excel Dashboard
Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 { 21 Comments }
Advanced Data Validation Techniques in Excel [spreadcheats]
Continue »

vlookup(), match() and offset() – explained in plain english [spreadcheats]

Published on Nov 19, 2008 { 72 Comments }
vlookup(), match() and offset() – explained in plain english [spreadcheats]
Continue »

Make your VBA macros work anywhere: Enable Relative References

Published on Nov 18, 2008 { 1 Comment }
Make your VBA macros work anywhere: Enable Relative References
Continue »