Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Highlighting data (as opposed to formulas)
The following method can be used after the fact to format the inputs. Use GOTO (either F5 or Cntrl G or Edit, Go To), click on SPECIAL..., then select Constants and clear the boxes with Text, Logical and Errors, thus leaving only Numbers. Click OK. All the cells with numbers (presumably all...- Wickus
- Post #9
- Forum: -Engineering spreadsheets
-
Polynomial Trendline parameter Extraction
Dear RGCook The method explained by PMOVER works exactly as he describes. Don't be too single-minded about the LINEST function. It normally does LINEAR regression but it does POLYNOMINAL regression when invoked as an array function. It's all explained by PMOVER. As an example, if you need a...- Wickus
- Post #10
- Forum: -Engineering spreadsheets
-
links
Links can also be contained in NAMES, or defined ranges, styles and sometimes even in deleted graphs, which the methods described above can not detect. To find the offending links in NAMES, navigate Insert, Names, Define which then shows a window with defined names. Pick each name and see at...- Wickus
- Post #4
- Forum: -Engineering spreadsheets
