Mr Sam Mathai Chacko Yes i make last comment ...!!
You start a discussion unutil only to draw attention? or just bothering I do not know how you use your time .... but mine is important Now yes.. I end up here Chilexcel 2012/8/3 Sam Mathai Chacko <samde...@gmail.com> > :) ending this here. No comments > > > On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel <chilexcel...@gmail.com> wrote: > >> 1) I'm trying to say is that no matter if 1 or 2 >> to response, if bad or good response anrterior >> just answer something to contribute and you! >> >> 2) yes is a copy of ( >> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html) >> You will not wait to draft all the text again, there is an effort by >> someone else, ..thanks for posting the link >> 3) I clearly understand the question, you are who do not understand >> rajan did not want links or anything ....He wanted an answer >> this reviewer Rajan...... is what matters !!! >> >> >> Chilexcel >> >> >> >> >> >> 2012/8/3 Sam Mathai Chacko <samde...@gmail.com> >> >>> 1. Your post came on top of my post, so there is no way of me proposing >>> 'another' solution. >>> >>> 2. It is not your answer ( >>> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html >>> ) >>> >>> 3. There is no reason to feel offended. I was only saying that it was a >>> different question, and you probably (apparently) didn't understand what >>> was asked. >>> >>> Sam >>> >>> >>> On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel <chilexcel...@gmail.com>wrote: >>> >>>> Mr.Sam Mathai Chacko >>>> >>>> I only answer queries or questions .. if you do not like my answer >>>> you propose another solution ...... and everyone happy!!! >>>> >>>> >>>> Chilexcel >>>> >>>> >>>> >>>> 2012/8/3 Sam Mathai Chacko <samde...@gmail.com> >>>> >>>>> Rajan isn't asking about Formula Auditing, which I am sure he is aware >>>>> of. His question is about the difference between Trace Precedents and >>>>> Trace >>>>> Error which are two separate features in Excel. >>>>> >>>>> Please read my post before. >>>>> >>>>> Regards, >>>>> Sam Mathai Chacko >>>>> >>>>> >>>>> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel <chilexcel...@gmail.com>wrote: >>>>> >>>>>> Rajan >>>>>> >>>>>> >>>>>> >>>>>> These tool in Excel allows us to Trace Precedents in a formula, Trace >>>>>> Dependents , Show formulas, Error checking and Evaluating formula in >>>>>> Excel. >>>>>> [image: Imágenes integradas 1] >>>>>> >>>>>> detail >>>>>> >>>>>> >>>>>> *Trace Precedents:* When you click this button, Excel draws arrows >>>>>> to the cells (the so-called *direct precedents*) that are referred >>>>>> to in the formula inside the selected cell. When you click this button >>>>>> again, Excel adds "tracer" arrows that show the cells (the so-called >>>>>> *indirect precedents*) that are referred to in the formulas in the >>>>>> direct precedents. >>>>>> >>>>>> *Trace Dependents:* When you click this button, Excel draws arrows >>>>>> from the selected cell to the cells (the so-called *direct dependents >>>>>> *) that use, or depend on, the results of the formula in the >>>>>> selected cell. When you click this button again, Excel adds tracer arrows >>>>>> identifying the cells (the so-called *indirect dependents*) that >>>>>> refer to formulas found in the direct dependents. >>>>>> >>>>>> *Remove Arrows:* Clicking this button (or the Remove Arrows option >>>>>> on its drop-down menu) removes all the arrows drawn, no matter what >>>>>> button >>>>>> or command you used to put them there. >>>>>> >>>>>> *Show Formulas:* To display all formulas in their cells in the >>>>>> worksheet instead of their calculated values (just like pressing Ctrl+`). >>>>>> • *Error Checking*: When you click this button or the Error Checking >>>>>> option on its drop-down menu, Excel displays the Error Checking dialog >>>>>> box, >>>>>> which describes the nature of the error in the current cell, gives you >>>>>> help >>>>>> on it, and enables you to trace its precedents. Click the Trace Error >>>>>> option on this button's drop-down menu to attempt to locate the cell that >>>>>> contains the original formula that has an error. Click the Circular >>>>>> References option on this button's drop-down menu to display a menu with >>>>>> a >>>>>> list of all the cell addresses containing circular references in the >>>>>> active >>>>>> worksheet. >>>>>> >>>>>> >>>>>> *Evaluate Formula:* Clicking this button opens the Evaluate Formula >>>>>> dialog box, where you can have Excel evaluate each part of the formula in >>>>>> the current cell. The Evaluate Formula feature can be quite useful in >>>>>> formulas that nest many functions within them. >>>>>> >>>>>> Chilexcel >>>>>> >>>>>> 2012/8/3 Rajan_Verma <rajanverma1...@gmail.com> >>>>>> >>>>>>> * * >>>>>>> >>>>>>> *Hi Group,* >>>>>>> >>>>>>> * * >>>>>>> >>>>>>> *Is there any difference in Trace Precedents and Trace Error in >>>>>>> Excel??* >>>>>>> >>>>>>> * * >>>>>>> >>>>>>> *I don’t need any link to see because I have already Google it.* >>>>>>> >>>>>>> * * >>>>>>> >>>>>>> *Regards* >>>>>>> >>>>>>> *Rajan verma* >>>>>>> >>>>>>> *+91 7838100659 [IM-Gtalk]* >>>>>>> >>>>>>> ** ** >>>>>>> >>>>>>> -- >>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> >>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>>> in signatures are prohibited. >>>>>>> >>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>> Forum owners and members are not responsible for any loss. >>>>>>> >>>>>>> >>>>>>> ------------------------------------------------------------------------------------------------------ >>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>> >>>>>>> To unsubscribe, send a blank email to >>>>>>> excel-macros+unsubscr...@googlegroups.com >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Visita ; http://sites.google.com/site/chilexcel/Home >>>>>> Visita ; http://www.youtube.com/user/timextag41 >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>> Advice will not get quick attention or may not be answered. >>>>>> >>>>>> 2) Don't post a question in the thread of another member. >>>>>> >>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>> measure. >>>>>> >>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>> >>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>> Forum owners and members are not responsible for any loss. >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------------------------------ >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> To unsubscribe, send a blank email to >>>>>> excel-macros+unsubscr...@googlegroups.com >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Sam Mathai Chacko >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> ------------------------------------------------------------------------------------------------------ >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> To unsubscribe, send a blank email to >>>>> excel-macros+unsubscr...@googlegroups.com >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Visita ; http://sites.google.com/site/chilexcel/Home >>>> Visita ; http://www.youtube.com/user/timextag41 >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>>> >>>> >>>> >>> >>> >>> >>> -- >>> Sam Mathai Chacko >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >> >> >> >> -- >> Visita ; http://sites.google.com/site/chilexcel/Home >> Visita ; http://www.youtube.com/user/timextag41 >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
<<Formula-auditing-Group-in-Excel-2007.jpg>>
