Closed Thread
Results 1 to 2 of 2

How to force excel

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2010
    Posts
    6

    How to force excel

    This is my formula:
    =DCOUNT(timeg15w!$A$1:$F$3909, "WPC",Criteria!A1:C2)

    My question concentrates on this part of the formula:...Criteria!A1:C2

    When I drag down the formula, it changes, as usually, adding 1 to the cells address, like this:
    Criteria!A1:C2
    Criteria!A2:C3
    Criteria!A3:C4

    BUT, I want the formula dragged down, adding 2 instead of 1, changing like this:
    Criteria!A1:C2
    Criteria!A3:C4
    Criteria!A5:C6

    How can I achieve this result?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: How to force excel

    Please read the forum rules.
    This is a duplicate post AND the same question has been posted in another forum.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Force destination formatting
    By krumel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:31 PM
  2. Download excel files through excel, force savepoint?
    By Vihral in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-06-2013, 09:01 AM
  3. Force to open in Excel not IE6
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2008, 08:31 AM
  4. how to force end an excel application
    By francoiss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2007, 08:10 PM
  5. Replies: 0
    Last Post: 11-01-2005, 03:32 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1