-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
tracing
-
E
Tracing Formula Frustrations — due to complex cell referencing
Suffering some apparent limitations of Excel. Excel cell referencing (i.e. $A$6) can become a major pain when I have to make changes to a complex spreadsheet. Multiple formulas to update etc. Tracing the formula is a major pain! I.e. Vlookup(A3, ProductMaster!$A$1:$D$25, 3, false) verses...- excelspark
- Thread
- formula pain reference cell tracing vlookup
- Replies: 1
- Forum: Excel Questions
-
R
Excel - Mapping External Links with Flowchart
I'm working on updating a file from my work predecessor that has some external links. As I opened each external link, I find that each of those files have external links and this continues for about 5 levels deep. Is there a way or program that will map all the external links back to the...- rjamb
- Thread
- external links flowchart mapping precedents tracing
- Replies: 0
- Forum: Excel Questions
-
O
Performance Tracking
I want to track performance of my service techs. I want to measure them monthly by service request turnover and average age of service requests. Turnover is how many new requests were generated during the month and how many were closed. Target is 100% Average age of service requests is how many...- obirobkenobi
- Thread
- metrics performance tracing
- Replies: 0
- Forum: Excel Questions
