| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find a code in Excel
I have been left a spreadsheet with has a formula linked to a 'code'. Is
there any way of locating or 'recalling' the code which presumably been assigned with Ctrl, Shift, Enter? Any help greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find a code in Excel
What do you mean by 'code' - is there a macro or User-defined function
in there? Ctrl-Shift-Enter is used to set up an array formula, and if you think there are any in your worksheet then you will see curly braces { } around the formula when viewed in the formula bar. The word CODE is a valid function in Excel. Post back with a bit more explanation of your spreadsheet and problem. Hope this helps. Pete On Apr 27, 1:12 pm, Terranoman wrote: I have been left a spreadsheet with has a formula linked to a 'code'. Is there any way of locating or 'recalling' the code which presumably been assigned with Ctrl, Shift, Enter? Any help greatly appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find a code in Excel
An example of the code for the array is:
=IF(B339="","",SUMPRODUCT( ( LEN( B339) - LEN( SUBSTITUTE( LOWER( B339), LOWER( Code), "" ) ) ) / ( LEN( Code) + ( LEN( Code ) = 0 ) ), load)) "Pete_UK" wrote: What do you mean by 'code' - is there a macro or User-defined function in there? Ctrl-Shift-Enter is used to set up an array formula, and if you think there are any in your worksheet then you will see curly braces { } around the formula when viewed in the formula bar. The word CODE is a valid function in Excel. Post back with a bit more explanation of your spreadsheet and problem. Hope this helps. Pete On Apr 27, 1:12 pm, Terranoman wrote: I have been left a spreadsheet with has a formula linked to a 'code'. Is there any way of locating or 'recalling' the code which presumably been assigned with Ctrl, Shift, Enter? Any help greatly appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find a code in Excel
On May 14, 9:07 am, Terranoman
wrote: An example of the code for the array is: =IF(B339="","",SUMPRODUCT( ( LEN( B339) - LEN( SUBSTITUTE( LOWER( B339), LOWER( Code), "" ) ) ) / ( LEN( Code) + ( LEN( Code ) = 0 ) ), load)) "Pete_UK" wrote: What do you mean by 'code' - is there a macro or User-defined function in there? Ctrl-Shift-Enter is used to set up an array formula, and if you think there are any in your worksheet then you will see curly braces { } around the formula when viewed in the formula bar. The word CODE is a valid function in Excel. Post back with a bit more explanation of your spreadsheet and problem. Hope this helps. Pete On Apr 27, 1:12 pm, Terranoman wrote: I have been left a spreadsheet with has a formula linked to a 'code'. Is there any way of locating or 'recalling' the code which presumably been assigned with Ctrl, Shift, Enter? Any help greatly appreciated.- Hide quoted text - - Show quoted text - 'code' could be referring to a named Range. Go to Insert-Name- Define and see if there is a range called 'code' defined in there. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find a code in Excel
Thats excellent I found it.
Thankyou very much. "Edward" wrote: On May 14, 9:07 am, Terranoman wrote: An example of the code for the array is: =IF(B339="","",SUMPRODUCT( ( LEN( B339) - LEN( SUBSTITUTE( LOWER( B339), LOWER( Code), "" ) ) ) / ( LEN( Code) + ( LEN( Code ) = 0 ) ), load)) "Pete_UK" wrote: What do you mean by 'code' - is there a macro or User-defined function in there? Ctrl-Shift-Enter is used to set up an array formula, and if you think there are any in your worksheet then you will see curly braces { } around the formula when viewed in the formula bar. The word CODE is a valid function in Excel. Post back with a bit more explanation of your spreadsheet and problem. Hope this helps. Pete On Apr 27, 1:12 pm, Terranoman wrote: I have been left a spreadsheet with has a formula linked to a 'code'. Is there any way of locating or 'recalling' the code which presumably been assigned with Ctrl, Shift, Enter? Any help greatly appreciated.- Hide quoted text - - Show quoted text - 'code' could be referring to a named Range. Go to Insert-Name- Define and see if there is a range called 'code' defined in there. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database to Find customer by zip code | Excel Discussion (Misc queries) | |||
| Why code for find() is not working | Excel Discussion (Misc queries) | |||
| to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
| can't find custom function code | Excel Worksheet Functions | |||
| Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
Hybrid Mode
