## CELL Formula in Excel – How to Use CELL Formula and Examples

Posted on 14 November 2009

Table formulas were something that I discovered recently. Actually our reader m-b commented that he prefers to convert a range to a table and then employ table formulas instead of named ranges. That got me curious enough to explore them further and here's what I learnt.
A Table in Excel
A table is a feature in Excel that makes it easier to format and analyze a set of data points in a spreadsheet. Tables were introduced ...

Posted on 14 November 2009

Posted on 08 October 2009

Posted on 26 August 2009

Posted on 23 July 2009

Posted on 13 July 2009

Posted on 10 July 2009

Posted on 08 July 2009

Posted on 05 July 2009

Posted on 04 July 2009

Posted on 04 July 2009

Posted on 01 July 2009

Posted on 10 June 2009

Posted on 09 June 2009

Posted on 20 May 2009

Posted on 21 April 2009

Posted on 01 April 2009

Posted on 18 October 2008

Posted on 23 August 2008

Posted on 23 August 2008

- Export Excel as Fixed Width Text File Format using VBA
- DATE Formula Excel - How to use Excel DATE Function
- 3 Nifty Ways to Send Email Using VBA in Excel
- How to create waterfall chart in excel in 2 minutes
- Table Formula in Excel (Something I didn't Know Till Yesterday)
- VBA For Loop - For Next and For Each In Next
- Multithreaded VBA - An Approach To Processing Using VBScript
- Excel Waterfall Chart Template with Negative Values
- So How Many Of These Excel Shortcuts Do You Know, Punk ?
- Array Formulas in Excel - Excel Array Formula Syntax & Array Constants

- Excel Chart Maximum Y Axis Value and Axis Interval (Major Unit)
- Prevent Users Ctrl Break (ing) Your VBA Code During Execution
- Cricketing Heat Map
- Opera Anyone ?
- Multiple Scale Chart – Adding Customized Scale to Each Category in a Chart
- The Content Aggregator Called Excel
- Table Formula in Excel (Something I didn’t Know Till Yesterday)
- Multithreaded VBA – An Approach To Processing Using VBScript
- Named Range – A Few Quickies
- So How Many Of These Excel Shortcuts Do You Know, Punk ?

- Lamont: That's not to suggest cutting corners about the co...
- reza: hi iam student and need pso in excel or xloptimi...
- DEv: You genious, very helpful..solved my chart in one...
- Harrison Delfino: I use MarketXLS and it works great for me....
- Joao Wacho: A coment about the last coment, i3 will be zero, b...
- Joao Wacho: I was with the same problem of another guys, find ...
- hcordes: Can you tell me how to create a field/formula that...
- Jacob: So if I wanted to modify a piece of VBA code for a...
- Julian: In order to support my 64-bit system, how I need t...
- Harshita: I tried using export to excel, i.e. HTML to excel ...