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. Color
  2. How do I delete all but one page on a worksheet?
  3. looking for simplified formulas
  4. A formula maxif, similar with sumif or countif
  5. Compare row contents w/Sumproduct or Array formula?
  6. Sum Function Needed
  7. If Function - Date Problem
  8. sum cells in table using column and row conditions
  9. Delete rows if specific criteria not met.
  10. Inserting blanks or changing dimensions
  11. formula help
  12. two formulas in one cell
  13. how to make a formula ignore blank cells
  14. Linking cells with text to each other
  15. On protected Excel sheet users be able to group/ungroup rows/colum
  16. Calculate polynomial curve
  17. From B0101 to 101
  18. SUM Product
  19. I get some negative numbers when I use the RAND() function--Why?
  20. SUMIF(AND()
  21. formulas and drop down lists
  22. Counting cells based on formatting
  23. "&" in Excel footnote as text
  24. Is the equation: =COUNTIF B:B, <9/31/2005 AND >9/1/2005 possible?
  25. New Excel function SUMABOVE
  26. Retrieving a specific cell from multiple worksheets
  27. VLOOKUP specific data for month required via dropdown list
  28. Counting Months
  29. I'm looking for a formula to calc # of days left in a month
  30. VLOOKUP specific monthly accounting data by selecting drop down li
  31. What if Formulas
  32. How to generate sets of random numbers without having duplicates
  33. Set an array on based on duration of months
  34. Conditional Formatting With Grades
  35. comparing text cells
  36. Importing from Password Protected Sheet
  37. If then statements
  38. Split numbers in cell
  39. I want to use sumif( > a cell reference) and not a value. How?
  40. carrying over a column formula from one sheet to another copied sh
  41. Using WORKDAY function
  42. offsetting values of multiple cells!
  43. Moving information to a different page
  44. Look up Help!
  45. using option button to highlight cells
  46. @vlookup returns the formula instead of the value - why?
  47. converting concatenated text strings into formulas
  48. Cell Propogation
  49. IF and AND statements
  50. How to move a formula from one sheet to another
  51. Solving for discount rate in present value calculation
  52. Trying to total payments for months, need help with my function
  53. click/unclick a box and make other info. appear?
  54. multiple conditions sum
  55. Counting instances based on two criterias
  56. Locking portions of a formula
  57. formula help
  58. Color Fill for a cell does not appear on Excel screen
  59. Can you round up numbers to the nearest multiple of ten?
  60. How can I project the values of intersection of curves in chart on
  61. I would like to Count values in two columns.
  62. Circular Reference
  63. sorting two columns at the same time
  64. Pivot tables
  65. macro sheet position
  66. A validated List which link to selected cells according to what is selected on the list
  67. Defining a range using a cell reference
  68. The Autofilter misses some numbers
  69. Macro wont update after file "read only"
  70. conditional formatting
  71. Hiding/Unhiding Columns
  72. what are the new features of excel 2003?
  73. date formula
  74. How do I use ISERROR in functions to hide error values
  75. Link cell between WS w/o dest display 0-jan if no entry at source
  76. Formulas IF()
  77. how to insert an email hyperlink in an excel header
  78. hiding column using VB
  79. Translation Exercise ...
  80. excel sales invoice template
  81. Excel function help Please
  82. E-mail a worksheet
  83. shortcut ALT +0252 doesn't bring up the check mark symbol?
  84. How to copy personal.XLS macros to a Cd for use on all XP compuers
  85. How can I nest ISTEXT and IF functions?
  86. autoupadting a counta
  87. Expiring
  88. sum with text in cell
  89. FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT
  90. Count with 2 conditions, second one OR
  91. Sort does not preserve string of additions
  92. Auto dates
  93. SUMIF with only Month
  94. Adding time
  95. repair outlook inbox
  96. What is DBRW as used in Excel cell formula ie =DBRW(
  97. check for duplicate names in spreadsheet
  98. insert a new row in VB
  99. Combining two formulas
  100. reference to a cell which then changes its place?!
  101. Using SUMIF function with multiple criteria for Aging
  102. Combining an IF and MAX function
  103. SUMIFS() error?
  104. table to xyz list
  105. Formula for amount owing subtract amount paid
  106. How does one sort a block of inter-related information in Excel?
  107. Countif Using Multiple Logic Tests
  108. Looking for excel spreadsheet for account receivable cust. histor
  109. two formulas per one cell
  110. How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash
  111. Delete specific text in spreadsheet
  112. ColorIndex
  113. Is this possible?
  114. How do I specify a tab order in a sheet
  115. Formula help
  116. retrieve filenames from given directory into excel
  117. unable to delete page break on Excel spreadsheet
  118. VLOOKUP, correct funtion?
  119. ranking a colum of numbers
  120. Help! Current Date in a column
  121. Is there a easy way to delete blank lines to clean up worksheets?
  122. 1st,2nd OR3rd EQUALS $10,$15 OR $25
  123. How do I set up a column
  124. help needed
  125. Sum with array problem using SRC/BusinessObjects software
  126. adv filter wont accept criteria
  127. Please help...
  128. alternative to VLOOKUP
  129. Using an IF function for a total
  130. rank problem
  131. Delete (') from Excel cells
  132. How to count last number
  133. Creating a Search Field?
  134. Have payroll sheet and having trouble subtracting 1AM from 5PM
  135. how can i set a static date and time in excel
  136. Unprotecting worksheets
  137. Summing columns in Excel?
  138. Getting column value based on month
  139. taking two worksheets together
  140. ? sort data in a drop down box w/ initial cell entry
  141. two worksheet reference formula help
  142. sorting a range with conditional formatting
  143. formula/function that prints only positve numbers
  144. SumProduct + cells
  145. reference current worksheet name (tab name) in a formula
  146. 2 days of frustration....Please help
  147. Excel worksheet slows computer
  148. Bless you, Debra Dalgleish & Pejo Sjoblom!
  149. Help with Sum if (or something else not sure)
  150. drop down list of a drop down list
  151. Disabling click and right-click on the Picture I inserted in an Excel document
  152. In Excel - can I create a formula based on a filter?
  153. validation - anyway to select multiple choices in the pull down?
  154. Formula help
  155. $ or !
  156. How do I fix my formulas in Excel?
  157. How do I make letters not show up in a alpha-numeric string?
  158. Link worsheets in Excel
  159. Running total formula
  160. Extract Specific Text
  161. Is there a way to find a value in a set of cells?
  162. Lookup multiple workbooks
  163. Excel Lookup
  164. creating excel macros
  165. if function
  166. Copying a link
  167. UDF to sort array with multiple columns
  168. averaging times
  169. splitting cells
  170. Track progress to lookup percent complete on another worksheet.
  171. Costom format -> 0.0061 to 6.1
  172. bank cal for interest on cd
  173. Hidden Function?
  174. Unprotect use 2 passwords possible??
  175. Spell Numbers
  176. My formula cell has stopped adding the preceding cells.
  177. Formulas
  178. Copying Formulas
  179. July - UK Excel User Conference
  180. Can I use the Goal Seek function on multiple cells simultanously?
  181. SET SATURDAY AS WORKING DAY IN EXCEL
  182. Forms in Excel 2007
  183. How to make a cell trigger a Sound in Excel
  184. Search for dublicates
  185. Setting up tasks by a conditional roster
  186. How do I format a cell to blink or Flash?
  187. Show's #N/A please to showblank.
  188. Identifying adjacent cells
  189. Auto complet is checked
  190. Need help with Countif function
  191. formula cell value multiply by percentage
  192. HELP NEEDED FOR IF Function Inside a Macro
  193. find text in a string formula
  194. Summarizing field quantities for specific records
  195. Excel Formula
  196. SUBSTITUTE
  197. *Tough Math Question*
  198. why wont my formulas copy all the way down my excel spreadsheet???
  199. Vlookup Please Help
  200. VALIDATION IN EXCEL
  201. Two Criteria with the COUNTIF function or somthing else?
  202. SHARING EXCEL WORKBOOK
  203. Mid function returns odd results.
  204. WHAT FUNCTION 2 ENTER SO THE CELL TURNS RED AFTER CURRENT DATE
  205. scan a document and pull into excel spreadsheet to edit
  206. Weighted moving average
  207. Re: Weighted moving average
  208. Compare lists for additions and subtractions
  209. conditional formatting 2 cells
  210. Transpose Mailing List to Columns
  211. help with formula
  212. WildCard Characters
  213. Remove Punctuation?
  214. Extract just numeric part of mixed text/number entry?
  215. How do I use section breaks in excel?
  216. HERE'S A REAL BRAIN TWISTER:
  217. Counting ranges, please help
  218. Display Unique Values Question
  219. Interest calculation
  220. DELETE ROWS BY USING A IF/THEN QUERY
  221. HELP - Excel 2003 formulas don't work-as if cell values aren't num
  222. How do I get excel to generate Random nos for my data?
  223. i need a number total derived from words
  224. matching formula
  225. EMERGENCY!! PLEASE HELP!!
  226. Is there a way to limit the content of a cell to 5 choices?
  227. How do I use a logical IF statement with TEXT in EXCEL
  228. Summing a function
  229. If And
  230. #value!
  231. Not able to Paste into other cells
  232. Two criteria for CountIf?
  233. Updating links
  234. Enhancement Request: Give us ability to lock/freeze tabs in Excel
  235. Sum a range but exclude and negative values
  236. Sum a range of absolute values
  237. In MS Excel 03, how do I determine an end date (with weekends)?
  238. problem
  239. wild card with if logical function
  240. wild card with if logical function
  241. Help with SUMIF function
  242. SUMIF function help
  243. If Function
  244. Comparing two different Worksheets
  245. compare cells of different external documents
  246. vlookup and hlookup simultaneously
  247. Urgent SUMIF problem
  248. I can't type in a column in excel it's frozen
  249. Can XLS automatically insert file properties fields into a header
  250. convert cell content to filename