Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is MATCH a volatile function?
I have the following formula: =IF(ISNUMBER(MATCH(B2,'1 31 07 FAS sheet
1'!$AG$2:$AG$65536,0)),"Matched",IF(ISNUMBER(MATCH (B2,'1 31 07 FAS sheet 2'!$AG$4:$AG$58232,0)),"Matched","Unmatched")) If I manipulate other data outside the ranges in the above formula, the whole workbook recalculates. I've never seen MATCH referred to as volatile. Thoughts? -- Brevity is the soul of wit. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is MATCH a volatile function?
Check out this link...
http://www.decisionmodels.com/calcsecretsi.htm The entire site is actually a really good read and worth bookmarking. -- HTH... Jim Thomlinson "Dave F" wrote: I have the following formula: =IF(ISNUMBER(MATCH(B2,'1 31 07 FAS sheet 1'!$AG$2:$AG$65536,0)),"Matched",IF(ISNUMBER(MATCH (B2,'1 31 07 FAS sheet 2'!$AG$4:$AG$58232,0)),"Matched","Unmatched")) If I manipulate other data outside the ranges in the above formula, the whole workbook recalculates. I've never seen MATCH referred to as volatile. Thoughts? -- Brevity is the soul of wit. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is MATCH a volatile function?
This is helpful thanks. According to the link, the formula below must have
become volatile because it refers to other worksheets and I was inserting columns. -- Brevity is the soul of wit. "Jim Thomlinson" wrote: Check out this link... http://www.decisionmodels.com/calcsecretsi.htm The entire site is actually a really good read and worth bookmarking. -- HTH... Jim Thomlinson "Dave F" wrote: I have the following formula: =IF(ISNUMBER(MATCH(B2,'1 31 07 FAS sheet 1'!$AG$2:$AG$65536,0)),"Matched",IF(ISNUMBER(MATCH (B2,'1 31 07 FAS sheet 2'!$AG$4:$AG$58232,0)),"Matched","Unmatched")) If I manipulate other data outside the ranges in the above formula, the whole workbook recalculates. I've never seen MATCH referred to as volatile. Thoughts? -- Brevity is the soul of wit. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
is MATCH a volatile function?
In 2003 inserting columns will force a calculation (2003 was the first to
allow you to aggregate based on whether the cell was hidden or not). It will not make the function volatile. However by inserting a row you may have changed the dependant range which will dirty the cell with the match and force the recalc. -- HTH... Jim Thomlinson "Dave F" wrote: This is helpful thanks. According to the link, the formula below must have become volatile because it refers to other worksheets and I was inserting columns. -- Brevity is the soul of wit. "Jim Thomlinson" wrote: Check out this link... http://www.decisionmodels.com/calcsecretsi.htm The entire site is actually a really good read and worth bookmarking. -- HTH... Jim Thomlinson "Dave F" wrote: I have the following formula: =IF(ISNUMBER(MATCH(B2,'1 31 07 FAS sheet 1'!$AG$2:$AG$65536,0)),"Matched",IF(ISNUMBER(MATCH (B2,'1 31 07 FAS sheet 2'!$AG$4:$AG$58232,0)),"Matched","Unmatched")) If I manipulate other data outside the ranges in the above formula, the whole workbook recalculates. I've never seen MATCH referred to as volatile. Thoughts? -- Brevity is the soul of wit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
MATCH function, exclusion question | Excel Discussion (Misc queries) | |||
MATCH function | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |