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

ExcelHelpNeeded

New member
Joined
Jul 21, 2019
Messages
10
Reaction score
0
Points
0
Excel Version(s)
Excel 365
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.
 
So remove the anchors:

=IF(AB4="","",IF(COUNTIF(O4:Y4,AB4)=0,"L","W"))
 
Back
Top