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. random question
  2. PivotTable
  3. searching within a cell
  4. Displaying cell depending on Date
  5. Calculating the closest score
  6. Trouble Using COUNTIF and AND
  7. VLOOKUP returning #N/A
  8. Convert Formatted Number to String
  9. How to copy out filter data
  10. Removing Alpha characters formula
  11. Pi Notation
  12. How to leave value alone if condition is false?
  13. Forcing Uppercase
  14. Lookup / count ?
  15. Conditional Formatting
  16. Alarms?
  17. Can you record the highest value in one cell?
  18. Two criteria SumIf functions?
  19. refering to a blank cell in a formula
  20. Last value in a range
  21. Date calculation problem
  22. Vlookup Problem
  23. Calculating angles
  24. Using EXACT function without case-sensitivity?
  25. Converting text to values
  26. Validation lists as a result of an IF Formula?
  27. invoice spread sheet
  28. copy and sort data to new cells automatically...by function or macro maybe?
  29. Insert CheckBox
  30. Autofill failure
  31. Excel Slow
  32. Automatically Calculate Race Places
  33. Summariizing from one sheet to another
  34. Using RANDOM to generate a name from a list
  35. formula that does simple math a specific number of times
  36. Worksheet name formula
  37. If/Then Relating-2 cells from 2 worksheets
  38. Using the Previous cell
  39. Web Query & Graphing daily data
  40. change column heading into a drop down box
  41. Sum total for names
  42. check sum
  43. if date falls within week, count...can it be done?
  44. Remove empty cells
  45. IF Function
  46. Total (or summing) only 'select' row(s) into a list ???
  47. multiplication formula error
  48. Incriment only 1 specific part of a formula..??
  49. Rounding
  50. offset function
  51. calculation with a row value and percentage
  52. Total Lowest Scores
  53. dynamic name range that copies formula from previous row to new row
  54. counting cells with conditional formating
  55. IF Function
  56. Average excluding negative values
  57. Datedif Calculation between to dates?
  58. Calculate time and salaries
  59. getting position of a word in a string
  60. pivot table function?
  61. INDEX and MATCH on two columns
  62. Converting number to opposite sign (Negative to Positive)
  63. find first negative number in a list
  64. Excel Code Generator
  65. Locating Row
  66. Average
  67. Using Dates
  68. Item Count
  69. Multiple column count
  70. How Do I make a formula look up a column by its Header Row??
  71. If statement confusion
  72. CONCATENATE the contents of cell VERTICALLY
  73. Relating Worksheets
  74. Displaying an Automatic Error Message
  75. Search text string for value
  76. worksheet function
  77. count number of entries per week
  78. Sumproduct Formula
  79. auto filter
  80. Index Match Error
  81. excel sumif sorting
  82. Cell Column name arithmetic
  83. address value
  84. Average needed, but want to exclude some values
  85. blank instead of 0
  86. Rounding
  87. Lookup by text in Row1?
  88. calculating dates & averages
  89. If Functions and sum
  90. hiding formulas
  91. Network Question
  92. Create a dynamic list from multiple sheets
  93. Multiple Lookup Values/Criteria
  94. drop down menu that will fill in some other firlds based on choice
  95. Running average formula
  96. Indirect with Named ranges - Control cell
  97. Printing images from Excel without squeezing them?
  98. Correcting a value error in VLookup
  99. Multiple IF statement with CONCATENATE
  100. Lookup type problem
  101. Simple Cell Shading with different than default colors?
  102. Compare, finding a write list
  103. How to creat error bars on chart
  104. calculating depreciation
  105. Countif formula
  106. Date Not calculating correctly
  107. find max value based on value of another cell?
  108. FALSE result from Averageif formula
  109. Multiple Contingency functions
  110. Replace All
  111. Assistance with AND functions (i think!)
  112. Select a Cell to show the last entry in a column
  113. data entry determines value?
  114. Paste Values Keyboard Shortcut Key Combo???
  115. double formula
  116. count the frequency of cell entries
  117. Count unique numbers with an AND condition????
  118. Changing file name in formulae
  119. Transpose multiple columns into one column
  120. Export Excel 2003 Worksheet Functions and Formulas?
  121. 'On time' Formula
  122. Calculating with Dates
  123. copying of data
  124. Material Management
  125. Add error Bars
  126. Excel Code Generator
  127. Data Validation=> List . source from another workbook??
  128. If statement
  129. format or copy/paste(if)
  130. File name in a cell
  131. Graphing already found STDEV
  132. dynamic list
  133. dynamic table_array in vlookup
  134. Dropdown List without Duplicate Values
  135. Cell Referencing
  136. Convert Date to year?
  137. link to dynamic tab
  138. Special criteria formula
  139. Auto Calculating Formula
  140. running and saving a scheduled query in ms query
  141. Wrap text using a function
  142. Migrating Coloums
  143. summary sheet
  144. Formula with multi-cell answers
  145. Sumproduct issue
  146. Search and sum multiple worksheets based on criteria
  147. time in time out no idea how to calculate
  148. Minus Function?
  149. LOOKUP Function (Matrix)
  150. IF statement
  151. Expense budget problem with functions
  152. Worksheet Change Event
  153. relative formula
  154. Top Ten list
  155. Easy cell address (or filter?) question
  156. Join Text
  157. SUM(IF) Question
  158. Conditional MAX statement
  159. Vlookup for area code to state
  160. Disregard empty cells?
  161. Validation List Criteria
  162. Calculating Elapsed Time - but not overnight.
  163. Lookup
  164. Excel Worksheet always prompt cell/chart need to be unprotected error during save as
  165. [ASK] If Statement using And/Or
  166. Protection
  167. IF statements using DATES
  168. Form (Prompts)
  169. Combining Spreadsheets
  170. Max(if) Question
  171. Sumnproduct formula
  172. counting time over date
  173. Big sheet..neeed to jump from place to place
  174. Increasing invoice number.
  175. Multiplying cells by various fixed values...
  176. Nested VLOOKUP, IF, AVERAGE Function
  177. Format
  178. Renaming worksheet - "xls]..."
  179. rounding up a column in Excel
  180. Looking for a Percent formula.
  181. Linking Sheets
  182. Date Function
  183. zero to return
  184. Angling TEXT BOX and the TEXT
  185. Can't describe....
  186. SUMPRODUCT formula
  187. Calculating a cost from hh:mm:ss
  188. Automatic ranking of values?
  189. Can I merge Tabs?
  190. SOLVER Function Problem
  191. IF Statement.
  192. Vlookup #N/A Error
  193. copying formula pattern
  194. Pivot and Sumproduct Combination
  195. Lookup results
  196. Find the first negative number in a column?
  197. Varible cell address in a cell
  198. Single Pivot Table off Multiple Sources?
  199. if,then column searches
  200. count if question
  201. formula or conditional formatting
  202. Variable Cell ID
  203. Cumulative Total between workbooks
  204. Negative Datedif
  205. Turn on a visual reminder
  206. which formula?
  207. vlookup problem
  208. Trying to make a cell look at another cell to create and answer
  209. Counting Text in Multiple Columns
  210. Conditional Format for cells containing the same word (but in different phrases)
  211. Sports Stat Leaders\Leaderboard
  212. Multiple drop-down lists to select different values from a table
  213. Removing Duplicate values within a column
  214. Indirect Sumproduct
  215. countif question
  216. Message Warning Box/Data Validation
  217. another conditional format
  218. Change color of text if conditions are met.
  219. min & max
  220. Cross Posted >> IF AND function
  221. Data matching
  222. Relative And Fixed Adressing
  223. Mailmerge
  224. If statement with 2 reasons
  225. Sheet Reference from Cell
  226. return values for a sum?
  227. incrementing date
  228. Two-Column Lookup
  229. If statement with date range
  230. How do you call data from different tabs?
  231. Data entered in cell...entire row to new sheet
  232. Time Value of Money
  233. Potential bug with Data Tables in 2007
  234. Querying text ranges
  235. Sum within validation
  236. Is it possible too...
  237. Vlookup for multiple criteria
  238. Date function
  239. Using Index, Indirect and Rand functions.
  240. Not sure....
  241. Funtionality
  242. Subtotal Copy Problem
  243. Getting data from several sheets
  244. Blended Rate Formula
  245. Returning the first value in a column of values
  246. If/Array
  247. Due Date
  248. Sum of alternate columns & rows
  249. Automatic Number change
  250. Using SUMPRODUCT and then subtracting a cell value