PDA

View Full Version : Worksheet Functions


Pages : 1 2 3 4 5 6 [7] 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352

  1. Number of working days between two dates
  2. Advanced filter criteria; validation lists
  3. Re: Number of working days between two dates
  4. Can't move from cell to cell?
  5. Countif's With Multiple Criteria
  6. Multiple rows to single row by criteria
  7. File Save Macro
  8. Matching and deleting data
  9. Formulas
  10. New User Needs Help
  11. look for true, false, when an array is emty or not
  12. EXCEL PRINT PROBLEM
  13. Start a new line in cell within a function
  14. calculating the finish time/date from the start time/date
  15. Count records depending on enties in other cells
  16. Parsing
  17. Demos For Inventory
  18. Excell multiple lookup values
  19. Conditional format to hide #N/A
  20. Macro in excel
  21. Number of Digits in a Cell
  22. lotus 123 to excel
  23. copying and pasting
  24. Comparing 2 lists in Excel
  25. Saving Excel as text
  26. date problems and more
  27. Need help with a function
  28. Excel
  29. dates
  30. Vlookup-avoiding "N/A"
  31. Function calculate date in weeks
  32. Counting highlighted cells
  33. Copying condition formatting cells only
  34. Excel Template Function
  35. auto open specific worksheet
  36. Average of last X non-blank, non-contiguous cells
  37. links in excel
  38. When choosing landscape the doc still prints in portrait
  39. VB Password help
  40. IS THERE ANY excel EXPERT to SOLVE my Problem???
  41. Extracting data from alpa numeric string
  42. Conditional format other cells
  43. PMT Formula inExcel
  44. Leading Zeros
  45. Contains
  46. excell
  47. deleting a an excel workbook that's in a shared file
  48. Is there a function to covert numbers into text ?
  49. footnote?
  50. sorting zip codes
  51. Leading zeros
  52. Extracting Data (Updated)
  53. Formula
  54. How to figure years and months of service.
  55. lookup a sum of multiple values for a single date
  56. Pivot Table option is missing from toolbar
  57. Formulas
  58. Linking Error : produces a "0"
  59. MaxIF?
  60. Advanced Filter
  61. vertical text
  62. Formula
  63. Formula
  64. SUM returning # character in cell
  65. creating mailing labels
  66. Break up alpha numeric data
  67. LOOKUP PROBLEM
  68. Creating a Yes No Incomplete selection box
  69. Filtering Worksheets To Print Only What you selected
  70. Copy only visible cells
  71. if then statement
  72. Open Macro after Close
  73. Calculation of an Average
  74. Criteria in sumif function
  75. Combining multiple Workbooks into single file
  76. function
  77. Getting a month from a date NOT using month() function! HELP!
  78. worksheet matching
  79. Pounds & Ounces
  80. changig background color in excel 97
  81. Time Formula Result Exceeds 24 Hours
  82. excel print formula
  83. Re: Equation for a surface (i.e.an equation for 2 variables)
  84. Creating a Collapsible Tree Heirarchy in Excel
  85. Function FV for non constant Payment Pmt
  86. Lookup
  87. problem with date calculations
  88. Vlookup - Multiple columns - How do I do this in Excel?
  89. Summing over multiple sheets
  90. Calendars in Excel?
  91. Exporting Excel Sheet data into a Text File using Macro
  92. Cell references
  93. export excelsheet into text file
  94. count the production result and making the date in text format
  95. Complex formula
  96. Julian date
  97. importing a text file into Excel.
  98. Merging multiple cells with data
  99. SUMIF
  100. Re: Help With Formatting Cells - Is This Possible Anyone..?
  101. Cannot open large excel file
  102. format cell to view value not formula
  103. Trying to use functions
  104. How to add automated numbering on Excel Document
  105. Retaining results aftering copying and deleting original sheet
  106. Counting
  107. Protected Worksheets
  108. Excel XP array formuls not working?
  109. Help on Sorting multiples with formulas
  110. Radio Buttons and Dropdown List Boxes
  111. Re: Lookup will not work
  112. comparing and merging two sets of data
  113. problem adding button to an EXISTING dropdown menu on a Worksheet Menu Bar
  114. Date formatting in a formula??
  115. Merging excel books
  116. EXCEL macro with a msgbox
  117. Merging excel documents
  118. Conditional Formatting
  119. Grade Book project
  120. Countif
  121. Copy and Paste
  122. some problems in using function CELL( )
  123. Parsing the last name from a name string
  124. Two dimensional formula problem
  125. SUMPRODUCT
  126. SUMIF in Office XP
  127. Extracting Data
  128. Re: counting blank cells via pivot table
  129. Inserting A Hyperlink Automatically
  130. Date difference in WEEKS
  131. 4 digit display in excel?
  132. What is "extra bits"doing in formula?
  133. Lookups
  134. HELP - Need formula
  135. avoiding circualr reference
  136. "YIELD" function
  137. Re: Formula: If less than X but greater than Y...
  138. Multiple IF/OR stmts in a function
  139. help
  140. Indirect Funtion
  141. Convert number to negative based on code in neighbor cell
  142. Re: Index Match problem
  143. Mean direction through 360 degrees?
  144. macro - cell selection
  145. Output from Excel
  146. Macro won't close file w/o displaying box to save changes
  147. getting the standard error for the difference between two means
  148. Text to columns ?
  149. "dated if" statement
  150. rounding down only odd numbers in a column
  151. Re: Adding autocomplet to a cell that is validated
  152. problem with IF function with results from MATCH function
  153. Excel Financial Functions
  154. IF statement macro to use end down for empty cell
  155. Comments
  156. Rounding numbers to quarters after entry
  157. Checking for a date falling between two columns of dates (an array, maybe??)
  158. Description of Statistical functions in Excel 2002
  159. Time
  160. Make checkbox bigger
  161. Summing
  162. 24 hour Time Sheet
  163. Date of last file save
  164. looking for the location at the latest date
  165. Can I do this in EXCEL? - removing text from multiple rows so only specified codes remain
  166. EOMONTH
  167. Values
  168. Watermarked images, lattitude, longitude, cell references..
  169. Chart View
  170. Convert Time Formats
  171. Special formatting
  172. Cell color
  173. Re: Excel Time Formats
  174. Subtotalling two columns
  175. overtime computation
  176. Search and replace....
  177. Excel 2002 cell format
  178. Re: "Greater than but less than" formula
  179. Count certain characters
  180. how to show information
  181. z test in data analysis tools
  182. moving a drop down to another worksheet
  183. count the number of cells that have a particular fill colour?
  184. Retaining last months info when new month entered
  185. adding a price to an item in a drop-down list
  186. Absolute reference
  187. formulas
  188. finding and listing search result
  189. Macro to save data to database without user intervention
  190. ROUNDUP
  191. linked sheets, sum problem
  192. Truncated Picture?
  193. Rounding time to the quarter hour.
  194. Linking a new worksheet to an existing worksheet in a book
  195. Leveraging Data Analysis Functions (esp. Regression) in VBA Procs
  196. Macro to put data in next empty cell
  197. AutoSum
  198. Re: Vlookup - spaces
  199. Help with Dates!!!
  200. hh:mm not adding
  201. f(x) for totaling single cell
  202. Re: f(x) for totaling single cell
  203. export data problem
  204. dates and times, tracking using
  205. Best Books to learn VBA
  206. comparing values for matches
  207. Re: Sumproduct or Countif question --- multiple criteria
  208. syntax: linking cells to sheet names
  209. find the next empty row
  210. auto calculations
  211. Change "Company" field in File Properties
  212. Looking for the top 75%
  213. Linking Work Sheets
  214. Excel merge files that work like Word merge files
  215. Protection
  216. CALL() REGISTER()?
  217. calculation of 10 minute averages per day
  218. Excel date function
  219. VBA - copying excel data from a closed WB to another closed WB
  220. Multiple SUMIF Statements
  221. Using numbers from a pasted HTML table
  222. Header & Footer
  223. cut removes border as well as contents
  224. Cell References
  225. borders
  226. Vlookup with 2 reference cells
  227. This operation requries...
  228. Pivot Tables
  229. Macro Button & Change Name of Macro
  230. Conditional Sum Format
  231. Randomly distributed normal deviates
  232. Custom tool bar icons
  233. I need help or ideas
  234. Help with Script code
  235. Copy to another workbook
  236. code Help - Routing Recipients
  237. SunIf
  238. Open workbook for multiple people
  239. excel newb needs to merge a bunch of files
  240. need a function that returns an adjusted APY
  241. Re: Looping with SUMIF function
  242. Validation Pull-Down Lists
  243. Validation Pull-Down List
  244. Totals for tally sheet
  245. sort using cells that contain both letter and numbers
  246. Users cannot use pivot table options on published interactive HTM spreadsheet
  247. Transform data from various cells into a single column
  248. Macros
  249. multiple logical tests in an IF function
  250. Nested IF with AND Functions
Google