Home > Excel Help Portal > Using Excel Formulas

<<  (Page 1)  Previous              Next  (Page 3)  >>

Using Excel Formulas

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to use Microsoft
Excel formulas.

51. Fill in the Empty Cells
52. How to Use the LOOKUP Function
53. Macro to Extract Data from a Chart
54. How to Automate Excel to Create a New Workbook from Delphi
55. Function That Uses the ActiveCell Property Returns Incorrect Result
56. How to Use VLOOKUP or HLOOKUP to Find an Exact Match
57. Prevent duplicate entries
58. Excel -- Data Validation -- AdvancedTechniques
59. Excel -- Data Validation -- Dependent Lists
60. Current Data Region and related items
61. Clear Constants from Selected Cells
62. Help using Excel - a VB module to generate HTML web pages
63. How to perform a TwoDimensional Lookup in Excel 2000
64. Using OFFSET to maintain formulas when inserting lines
65. How to Use Visual Basic Code to Total Rows and Columns in an Array
66. Custom Function to Turn Nonadjacent Cells into an Array
67. You cannot change a link path when an Excel AddIn is not loaded
68. How to Return Multiple Values from a Custom Function
69. Excel functions for investment appraisal
70. How to rank Duplicate Values Sequentially in Excel 2000
71. How to control the startup message about updating linked workbooks in Excel 2003
72. Relative and Absolute Formulas
73. Using Calculate Method May Not Calculate Certain Formulas
74. Saveas, Save each worksheet as a separate workbook
75. How to Use the FREQUENCY Function
76. How to Return the Address of the Cell with the Largest or Smallest Value
77. Excel Automation Fails Second Time Code Runs
78. Visual Basic Macro Examples for Working with Arrays
79. How to use New "Find and Replace" Dialog Box in Excel 2002
80. Lots 'o Little Code
81. How to Use the Registry to Override the Default Behavior When Excel Tries to Recover Data
82. How to Use a Custom Function in Another Workbook
83. How to Rank Duplicate Values Sequentially
84. How to correct rounding errors in floatingpoint arithmetic
85. Performing a Lookup with Unsorted Data in Excel
86. Excel RTD Function Cannot Return an Array
87. Charting Data From Different Sheets
88. How to check and Manage the Status of Links in Excel
89. Sample Visual Basic Macros for Working with Arrays
90. Error When You Concatenate String and Numeric Values
91. How to Determine Top/Bottom Used Cells in a Sparse Array
92. Microsoft Excel 2000 Specifications
93. How to Solve for New XValues Using INDEX and LINEST
94. Help using the Excel SUMPRODUCT() function
95. How to Create and Use TwoInput Data Tables in Microsoft Excel
96. Creating a Megaformula
97. How to use the Paste Options Buttons in Excel
98. How to view the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly
99. Visual Basic Macros That Add or Remove Hidden Apostrophes
100. Visual Basic Macro to Change Between Relative and Absolute References

<< (Page 1)  Previous              Next  (Page 3) >>