Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

Daily Dose of Excel » All Tags » Worksheet Functions (RSS)

Browse by Tags

Daily Dose of Excel

Home

Syndication

Recent Posts

Tags

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Good Row Bad Row

In the office, I sometimes deal with a table of values. In that table, there are good rows, and bad rows. I want to quickly put the good rows to the top of the table, and leave the bad rows at the bottom of the table. So I take the first unused column, give it a rubbish [...] Read More...

Published Wed, Jul 07 2010 5:28 AM by Daily Dose of Excel

Filed under: Formulas, List and Table Functions, Sorting, Worksheet Functions
VBA Rounding

When comparing values from various systems, I’d sometimes notice $0.01 differences. I put the differences down to rounding, but it seemed that no matter which approach I took, the differences could not be reconciled. It’s one of those things that really bugged me, and I’d feel guilty if I spent too much time on the problem… after [...] Read More...

Published Thu, Jul 07 2010 11:40 PM by Daily Dose of Excel

Filed under: VBA, Worksheet Functions, VBA Functions and Keywords
Formula Tokenizer

A few years ago, I wrote a Formula Formatter add-in to present a long formula for easier reading. It does it through a process called Tokenizing, which is basically a process of putting the components of a formula into labelled boxes. That add-in was compatible with Excel 2003 formulas, but Excel 2007 brought us extra formulas [...] Read More...

Published Sat, Dec 12 2009 3:38 PM by Daily Dose of Excel

Filed under: Formulas, Worksheet Functions

Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.