Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Offset (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the General forum. See all tags in the site
  • Re: Accessing an element of a named range

    You can use the OFFSET function to provide you with the result of a cell from a location you either know or calculate (eg you may determine the column according to a year value, and the row according to the month - totally depends on your dataset of course). So if you want to return the value in cell...
    Posted to General (Forum) by Adam Vero on Mon, Aug 3 2009
  • A twist on the old Countif on Two conditions problem

    I'm doing analysis on a large data set, it's of the form below, however there are sufficent coloums to mean it has to split over several worksheets, and transposing the data would not help... this asside for now we'll assume only one worksheet p1 p1 p2 p2 p2 p3 a 3.59 2.55 3.07 1.17 3.84...
    Posted to General (Forum) by Teppic_ on Fri, Apr 3 2009
  • I want to create a standard deviation bell graph

    Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
    Posted to General (Forum) by vanse@hotmail.co.uk on Sun, Mar 30 2008
  • Re: macros

    Jerry There are several ways ActiveCell.Offset(1,0).Select Is just one
    Posted to General (Forum) by Nick Hodge on Fri, Mar 28 2008
Page 1 of 1 (4 items)
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.