| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I freeze a data range when I drag it to a new cell?
Try =ISNA(MATCH(J8,$B$2:$B$347, FALSE))
Sandy "James" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| Drag cell from A1 : A (Value here) | Excel Discussion (Misc queries) | |||
| How to drag and autofill a non consecutive range of cells? | Excel Discussion (Misc queries) | |||
| Drag down method for getting data from another worksheet at every Nth cell | Excel Worksheet Functions | |||
| cell drop and drag | Excel Worksheet Functions | |||
Hybrid Mode
