+ Reply to Thread
Results 1 to 3 of 3

Resetting a formula every 43 rows

  1. 01-05-2013, 10:39 PM #1
    Insert Name
    Insert Name is offline
    Registered User
    Join Date
    07-08-2012
    Location
    NA
    MS-Off Ver
    Excel Starter/Sometimes Excel 2010
    Posts
    33

    Resetting a formula every 43 rows

    I would like to find the standard deviation of many numbers in column b. I Cannot just drag down the formula because I need it to reset it every 43 cells, for each new group. Is it possible to write the formula so that it resets it self?

    Help is greatly appreciated thank you.
    Reply With QuoteRegister To Reply
  2. 01-05-2013, 11:04 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Resetting a formula every 43 rows

    never mind
    Last edited by protonLeah; 01-06-2013 at 07:49 PM.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 01-06-2013, 07:24 AM #3
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Resetting a formula every 43 rows

    Hi Insert Name

    May be something along these lines!
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    And copy down.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1