How do I freeze a data range when I drag it to a new cell?
I'm trying to use the formula he =ISNA(MATCH(J2,B2:B347, FALSE))
To analyze list when I drag this formula into a new cell it automatically
adjusts the range B2:B347 to B2:B348, and so on.
The trick is that I want it to automatically adjust the search value, J2 to
J3 ....
What do I need to freeze this range.
Thanks
|