Dont miss this - Offset function made simple

787 views 3 replies
User Avatar

Financial Analyst
276 Points Joined July 2008

Check this link to know how to work with the Excel Offset function. 


Reply Share Follow
On 20 May 2011 at 00:36 Report
Replies (3)
User Avatar

SIEMPRE AHÍ PARA TI
15607 Points Joined December 2008

Thanks for d useful post.

Reply
On 20 May 2011 at 02:09
User Avatar

www.aubsp.com
15630 Points Joined October 2009

 

Formula Tips

 

A formula to calculate a ratio

Alternatives to nested IF functions

Automatic list numbering

Avoid error displays in formulas

Calculate the day of the year and days remaining

Calculate the number of days in a month

Calculating a conditional average

Change cell values using Paste Special

Change the formatting of your subtotal rows

Compare ranges by using an array formula

Converting non-numbers to actual values

Count AutoFiltered rows

Counting distinct entries in a range

Creating a "megaformula"

Dealing with negative time values

Delete all input cells, but keep the formulas

Displaying AutoFilter criteria

Force a global recalculation

Hiding your formulas

Identify formulas using Conditional Formatting

Locate phantom links in a workbook

Perform math operations without formulas

Perform two-way table lookups

Referencing a sheet indirectly

Round values to the nearest fraction

Rounding to n significant digits

Sum the largest values in a range

Summing times that exceed 24 hours

Text and values in one cell

Transforming data with formulas

Using Data Validation to check for repeated values

Working with pre-1900 dates

 
Reply
On 20 May 2011 at 07:14
User Avatar

CA IN PRACTICE
16719 Points Joined May 2011

thanks for the good post

Reply
On 20 May 2011 at 14:50


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading