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.
=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.