| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep a set range in a Search function
I am using the following function to look at numerous worksheets and count
how many times a certain number shows up: =SUMPRODUCT(--ISNUMBER(SEARCH(A2,'Site #02-Maine Medical Center'!G2:G42))) However, when I try to copy the function in the next cell, it always changes my search range (ex. G2:G42 goes to G3:G43). How do I keep the range from increasing? I always want to search this range for this particular spreadsheet. -- ~Connie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to keep a set range in a Search function
Connie wrote:
I am using the following function to look at numerous worksheets and count how many times a certain number shows up: =SUMPRODUCT(--ISNUMBER(SEARCH(A2,'Site #02-Maine Medical Center'!G2:G42))) However, when I try to copy the function in the next cell, it always changes my search range (ex. G2:G42 goes to G3:G43). How do I keep the range from increasing? I always want to search this range for this particular spreadsheet. Change to absolute references. $G$2:$G$42 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for value in a range | Excel Worksheet Functions | |||
| search within a range of cells? | Excel Discussion (Misc queries) | |||
| Search range for text not in another range | Excel Discussion (Misc queries) | |||
| How do I create a function to search a range for a number and... | Excel Worksheet Functions | |||
| how do you search a range of cells... | Excel Discussion (Misc queries) | |||
Linear Mode
