View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James James is offline
external usenet poster
 
Posts: 542
Default 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