PDA

View Full Version : Excel 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 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449

  1. Sorts
  2. Unable to read file
  3. Adding time
  4. Ignoring Formulas within cells
  5. pulling back dates that meet certain criteria
  6. If referencing drop-down list
  7. Display Age
  8. turn the letters N and Y into numbers just for totals
  9. Looking up multiple values for a single name
  10. Summing periodic sales on a rolling basis
  11. CANNOT GET SECOND CHECKBOOK REGIATER TO DO MATH, wHY?
  12. sort column by colour
  13. excel should allow me Indian number grouping ##,##,##,###.##
  14. Round one cell depending on value of another
  15. Search text within cell
  16. Excel, function, result to be returned in another designated cell
  17. Replacing value in cell with answer of same cell
  18. Average Formula
  19. My excel spread sheets are dividing all numbers input by 100.
  20. help in nested if formulas
  21. how do i...
  22. Excel help
  23. Time difference calculation
  24. Extend Formulas
  25. Using the subtotal function on a prtected sheet
  26. How do I return a value based on multiple possible conditions?
  27. Need Help with Formula
  28. Excel
  29. How to average a column of numbers that are greater than 0?
  30. How do I use line guides
  31. Merge multiple cells
  32. Need Function for Text To Columns
  33. What gets XNPV to calculate correctly if initial values are zero?
  34. IF Statements using BUT - is there such a thing
  35. Help quick
  36. Sumproduct function?
  37. Scheduling task for Excel
  38. Lookup? Match? pulling rows from one spreadsheet to match a text f
  39. Days by month and IF statement.
  40. Hyperlink to a subprocedure in an other workbook
  41. How do I use more than one value in Conditional Formatting?
  42. work days function
  43. I was looking to get assistance with a formula in Excel 2002
  44. How do you remove the numbers from a street address in EXCELL?
  45. How do I create a hyperlink to a cell with the hyperlink function
  46. Cell value - detecting change
  47. Count coloured cells in range
  48. tally a range of dates
  49. Count date in every 4th cell down column
  50. How do I close excell worksheet without closing others still open
  51. Formatting Remooval
  52. Combining AND/OR in an IF statement
  53. pivot table not reading date formats
  54. excel protection
  55. delete extra space
  56. Last Modified
  57. Merging cells in the center of a worksheet
  58. Date Conversion
  59. item limit for a combobox?
  60. Count cells that contain "Y" in columnA IF contains"X" in columnB
  61. Working out interest lost on a loan
  62. making copied cells change with change in original cell
  63. Counting Non Blank Cells that Contain Formulas
  64. Summing based on criteria
  65. function
  66. Sorting to get the latest of a kind
  67. separating names
  68. CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA
  69. Multiple lookup function
  70. RE: Multiple lookup function
  71. Insert Signature
  72. Insert Signature
  73. How do I pick up only the rows with a non-null key column on a separate sheet?
  74. how to sum a repeated val only once and meet a certian criteria?
  75. copy cell from one workbook to another
  76. Converting Dates to Weeks
  77. Lookup formula in excel
  78. How can I evade the limit of 30 arguments in a function?
  79. "formula too long"
  80. Validation list that also allows user entry?
  81. Help with Networkdays Calculation
  82. IF(AND(etc., etc. ... problem
  83. How to sort the data entered in different columns (columnwise)
  84. Excel should have 300 columns, for use aluminium smelter industry
  85. Criteria for Countif
  86. convert yards
  87. a formular to remove spaces in a numeric cell (Phone No)
  88. Variable range in MAX-function
  89. Please help... only have 20 mins
  90. Default Tab Stops for Template
  91. Adding Color to a Cell
  92. insert a picture based on a formula
  93. Vertical Lookup from a List
  94. Problem with formulas
  95. Summing HLookup Values
  96. Fiveif statements in a formula
  97. Reference external worksheet whose name is in a cell
  98. Using an Excel VB-made form in cell-specific conditions.
  99. Creating a highlighting formula
  100. Summing Unique data values
  101. combine two macros
  102. What formula!?!?!
  103. how to use work date function
  104. How do I create a random number generator in excel?
  105. Dependent drop-down list??
  106. format cells
  107. How do I get correct results when LOOKUP with calculated numbers
  108. 2 different workbooks into one new book
  109. How do I uniformly change the values (numbers) of many cells? Exce
  110. Conditional Formats - Forumlas
  111. Formula question
  112. Negative numbers in an IF formula
  113. Populate current active cell - Help Please!!
  114. LINKING TOGETHER FOR TOTAL
  115. Turn vertical data to horizontal data automaticaly
  116. Simple Game and Puzzle - Very Difficult to Implement
  117. Filling Cells with one Static Cell
  118. Question on functions various Excel versions support
  119. determining & returning least and greatest dates
  120. array formula: return next date from list
  121. return previous date from list
  122. If then color of cell
  123. Top 5 plus Other in Pivot table
  124. MS Query
  125. conditional format for text
  126. Sumif with multiple criteria
  127. How do I count nonblank cells that meet criteria in another cell?
  128. Giving value to a letter
  129. How do i print roman letters in the foot note
  130. Help please, cell formatting only works after I double click the cell
  131. Concatening a text and a date
  132. convert number to month and year in formula
  133. My Find and Replace function in Excel is not working?
  134. Excel If Statements with more than one Solution
  135. Lookup_Validation
  136. showing multiple results to a formula
  137. roll up a calendar in excel
  138. Round Problems
  139. Excel, how to count every 4th cell in column to see if occupied?
  140. if statement
  141. Shortening a formula
  142. Average of a row of numbers not counting 0's
  143. Combining information from multiple tabs
  144. Sumif with two criterias
  145. Vlookup returns value in the adjacent row
  146. HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?
  147. cells
  148. =if statement
  149. How do I use a formula to create a new line of text in a cell?
  150. This is kinda urgent. Need help with matrix stuff.
  151. Searching and adding a value.
  152. The Row Height Autofit command does not work.
  153. Cut &paste clears numbers after the decimal point
  154. Real time in worksheet
  155. Complicated work! Any idea??
  156. Using "*xxx*" in an array formula
  157. How do I calculate the mode of a column of IP addresses?
  158. How to count the number of Excel cells with text formatted Italic
  159. The picture is too large and will be truncated
  160. Copying a linked worksheet
  161. Cannot autosum after import
  162. About Data Table & Scenario Manager.
  163. Automatically insert a date value based on the value from another cell
  164. sumproduct of columns
  165. Lookup with multiple criteria... please help!
  166. IF Function and msgbox
  167. How do I copy and paste a formula I create to subtotals only?
  168. items disappearing from pivot dropdown when not selected
  169. items disappearing from pivot dropdown when not selected
  170. items disappearing from pivot dropdown when not selected
  171. =LOOKUP(MONTH)
  172. Cell protection
  173. Conditional Formatting
  174. Simple If formula but can't get my head around it!
  175. match in excel
  176. Need Formula HELP
  177. How do I link 4 columns to each other
  178. 3 logical condition if statement
  179. Finding current week and if any item has somthing due
  180. Creating a complicated formula
  181. enter item code in one column, automatically get description in ne
  182. SUMIF - counting across different spreadsheets
  183. Double Clicking on link w/i workbook does't bring me to souce.
  184. Stamp Duty
  185. Simple AND formula
  186. dynamic summary table
  187. LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE
  188. PIVOT LEARNER - Field Entry
  189. Comparing and sum'ing data
  190. how do I automatically jump to the present date in a roster?
  191. Column of Text Shown = Total Times Shown?
  192. How I can set all cell in the worksheet rounddown automatically?
  193. [Pivot Table] Add Value
  194. Copy worksheet to another worksheet and the date is plus 1 day.
  195. Refering to Cells
  196. Formula
  197. nper function calculation
  198. Counting Values
  199. Selecting Multiple Results
  200. Formula Assistance Please
  201. Currency vs. Accounting Format
  202. Can I set up where Employee types name and computer records time?
  203. Needing Help Very Bad
  204. how do I find the last value of a range....
  205. Complex Date Formula
  206. Why does a simple frequency distribution count out of range data?
  207. Linking dates to different workbook, then data.
  208. Holiday Planner show holiday taken?
  209. Adding Worksheet
  210. Unable to get examples to work for lookup etc
  211. HELP: can no longer open protected file in XP
  212. highlighting problem in excel
  213. Split a Cell?
  214. NOW() and SECOND() not refreshing
  215. Workbook Create Date fx
  216. Moving Data
  217. How do I round off times in Excel?
  218. Convert HTML to number
  219. Formula Assistance Please
  220. Workday calculation - not working
  221. Relative references for condtional formatting within a Pivot Table
  222. Simplify changing directories
  223. A formula for monthly tracking?
  224. SUMIF ??
  225. help with formula
  226. How do I calculate times each word occurs in a column of cells?
  227. How do I setup a formula to insert the rate?
  228. Conditional Validation
  229. How do I permanently remove Template Help?
  230. Extremely Vlookup, help me pls, ths much
  231. How to create data tables and is there a payback period function
  232. work with multiple workbooks on separate monitor for 2003 edition
  233. Performance IF(IF or IF(AND
  234. Duplicate Value warning
  235. calculating
  236. Keyboard shortcut or selecting entire column
  237. Restricted value sequences in rows
  238. ISERROR
  239. HELP WITH FORMULAS
  240. Forecast and Trends
  241. view 2 different worksheets within the Wrkbk
  242. CountIf Function
  243. view 2 different worksheets within the Wrkbk
  244. CountIf Function
  245. If functions and dates
  246. Run when exit
  247. Extracting tab names
  248. Using cell value in filenames
  249. Display multiple tabs in current worksheet
  250. repeating a formula