Results 1 to 3 of 3

Thread: Formula Will Not Copy Correctly When I Pull The Formula Down the Worksheet

  1. #1
    Neophyte ExcelHelpNeeded's Avatar
    Join Date
    Jul 2019
    Posts
    5
    Articles
    0
    Excel Version
    Excel 365

    Formula Will Not Copy Correctly When I Pull The Formula Down the Worksheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    When I try to drag this formula down the column the formula does not populate correctly.

    =IF(AB4="","",IF(COUNTIF(O$4:Y$4,AB4)=0,"L","W"))

    What happens is the O$4;Y$4 stays the same all the way down. What I need it do to is to change to O$5;Y$5, O$6;Y$6, O$7;Y$7,etc.

    I have never seen this before so I am kinda confused on what is going on here. Thanks for your help.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,515
    Articles
    0
    Excel Version
    Office 365 Subscription
    So remove the anchors:

    =IF(AB4="","",IF(COUNTIF(O4:Y4,AB4)=0,"L","W"))
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    8
    Articles
    0
    Excel Version
    2019
    You are using fix reference to row by using $ jusf before row number so it will keep fixed.

Posting Permissions

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