+ Reply to Thread
Results 1 to 4 of 4

Copy Formula pattern

  1. #1
    Registered User
    Join Date
    04-19-2016
    Location
    Pakistan
    MS-Off Ver
    2010
    Posts
    10

    Copy Formula pattern

    I have tagged excel sheet. There are 2 tabs. In 1st sheet"Khanewal" there is plan and actual locations visited. In sheet2 I have put countif formula to see how many persons were met.In sheet2, I wanted to drag the formula in such a way that it picks only plan and actual fro 1st sheet and not farmer visits and MD activities. Please help.
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Copy Formula pattern

    Try this in Sheet2, D3 and filled down/right

    =COUNTIFS(Sheet1!$B$5:$B$30,$C3,OFFSET(Sheet1!$C$5:$C$30,0,INT((COLUMNS($A:A)-1)/2)*4+(D$1="")),"=x")

  3. #3
    Registered User
    Join Date
    04-19-2016
    Location
    Pakistan
    MS-Off Ver
    2010
    Posts
    10

    Re: Copy Formula pattern

    Thanks a lot. Its perfect.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Copy Formula pattern

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy a formula based on a pattern
    By jonnops in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2015, 03:25 AM
  2. Copy down hypertext cell range pattern & cell reference formula pattern
    By Underexcelling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2014, 03:23 AM
  3. How to copy formula and it following a pattern?
    By salvi in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-22-2013, 03:23 AM
  4. formula to copy cells with a repeating pattern
    By jgaynor in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-20-2011, 09:58 AM
  5. Copy formula down rows based on pattern
    By briancb2004 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2007, 04:27 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