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. formula
  2. Invalid function
  3. summing cells in a periodic order
  4. obtaining max value then ref
  5. Counting number of rows using autofilter
  6. Offset a vlookup
  7. Repeat top row
  8. Lookup in a table
  9. Sumproduct #Value! Error due to Text
  10. Formula
  11. Averaging minutes in pivot tables
  12. Getting info from drop down menu
  13. conditional format
  14. Count with multiple criteria
  15. SUM (not sumproduct) with 2 criteria
  16. Tricky function
  17. Drop down list. I need more options
  18. SQL.REQUEST with MS SQL stored procedures
  19. Lookup
  20. Changing Cell Values automatically
  21. Circular Reference??
  22. Text manipulation
  23. Matching values
  24. Complicated Counting Function
  25. SOLVER add-on problems
  26. Problem with formula/links
  27. VLOOKUP Troubles.
  28. add right function to SUMIF formula
  29. Possible To Average Letters?
  30. Does a tab exist or doesn't it?
  31. Using FV for investments
  32. ritriev more than one text value to one cell
  33. VBA for IF command
  34. Custom Format
  35. Checkbook register recalculation problems
  36. Second-Best
  37. Average time between dates
  38. formula help excel 2002
  39. Data Validation Lists and dependant formulas HELP!
  40. Need help - Looking for a formula to locate the last occurence and return a date
  41. Simple Question
  42. Adding x% to all the numbers in a column
  43. How do I get a date to pop up in another sheet
  44. SUM with conditions
  45. Median Function Help
  46. Preventing cells from being repeated
  47. error in formula if cell/item not used (SUMIF)
  48. Tabulate Survey Responses
  49. COUNTIF question
  50. Function or to address vlookup when some cells are blank
  51. Clearing cells / =IsBlank
  52. Struggling with complicated counts
  53. VLookup help...PLEASE
  54. select my criteria
  55. I think I need to use VLOOKUP and DATE, but how?
  56. Drop Down List -- More Choices?
  57. Formula that pulls a factor from a chart on sheet 2
  58. Help with matching lines in two excel files
  59. Drop-down menus
  60. Please Help Urgent
  61. simple question
  62. Poker database
  63. Auto select in a drop down box
  64. averaging groups of cells
  65. I need a formula to project inventory cover
  66. Adding up total amount earned for the day
  67. time
  68. vlookup - hit & miss!!
  69. Maximum value less than n
  70. If formula
  71. Vlookup string
  72. Compare a string in two columns, if match then append string from third column
  73. Error message
  74. Lookup Only The Current Data
  75. If value is lowest in a set of values make bold and Red
  76. Is there a percentage gain function?
  77. Look up a part of the content of a cell
  78. calcule target value and % based on increased volume
  79. And If Statement
  80. multiple lookup
  81. Automate process
  82. Difficulty getting columns into rows
  83. Can you answer this?
  84. left, right, and mid
  85. Help with PivotTables
  86. Linking two worksheets?
  87. Moving rows into a new sheet that match criteria
  88. Error.type - leaving a value in a cell if not an error
  89. function, but I don't know which function I need!
  90. Need to list all matching cells (no blanks!)
  91. Displaying Results found by SubProduct Formula
  92. SumProduct
  93. Need a solution to categorize financial text
  94. Formula
  95. Linking 3 Worksheets with Autopopulate
  96. Simple array formula not working
  97. SUMPRODUCT with two wildcards.
  98. Return value from another cell (lookup?)
  99. Multiple freezes
  100. Need some help!!
  101. If then statement question...
  102. How would I do this?
  103. Calculating Costs over varying shifts
  104. Drop Down list - is there another way?
  105. Referencing cells in conditional formatting
  106. countif help
  107. Saving a column of values by date
  108. Adding Quantites Across Worksheets
  109. Count by Cell Shade
  110. Pivot table help
  111. Need Icon Indicator for Sheet Protection
  112. counting entries in a given month
  113. MATCH() & negative #s
  114. Complicated Spreadsheet Question
  115. finding he median subject to certain criteria
  116. Copy formula to reference next worksheet
  117. Statistical Anomalies
  118. Return a value from a cell
  119. help with two criteria counting
  120. Sum Problems
  121. Solve
  122. OK beating my head against old age
  123. Nesting a countif function
  124. comparing a phone number to an allowed list???
  125. How can I set Microsoft Excel to display the day by inputting the date?
  126. Need help with MID function...
  127. [newbie] $B8 * 1.5?
  128. Counting unique pairs of values
  129. Calculating Rent
  130. Intersection of two lists
  131. ranking by weighted results
  132. Clock in/Clock out calculation
  133. Summing/Consolidated Multiple Sheets
  134. Lookup cell value in separate worksheet and return multiple matched values
  135. Vlookup
  136. SumIf using 2 criteria??
  137. Different results of LINEST in XP and 2003
  138. Conditional formula query
  139. Return Text String Through 12th Space
  140. Is there a way to quick calculate?
  141. Ranking
  142. who to write a formula
  143. Referencing Buttons & Checkboxes
  144. Return value from another worksheet
  145. average values if month equals?
  146. Cannot insert worksheet
  147. Sumproduct - current month
  148. Search higher cells function
  149. Getting Values from Other Excel Sheets
  150. Looking for a function for multiple conditions
  151. function assistance please
  152. Removing all character 2 places to the right of decimal
  153. Excel 2000 GETPIVOTDATA
  154. Rounding Function
  155. Auto-shading a cell
  156. Parsing and Separating Text
  157. Returning a grade.
  158. finding a string in a column, displaying YES on the same row
  159. if todays date then stamp a set of values.
  160. Creating a list and removing duplicates
  161. 0 = "*"
  162. Web Query Help
  163. formula
  164. Perplexing Excel question
  165. SUMPRODUCT question
  166. Formula
  167. Networkdays and Conditional Formatting
  168. Formula
  169. Using cell value to define range
  170. IF function within a function
  171. How to disable fnc acting on hidden rows
  172. YEAR function in a cell
  173. Sum Problem
  174. Auto fill formula
  175. Linking Names to Closed Workbooks
  176. Naming a range inside a formula using "Address"
  177. Is Countif capable of this?
  178. Formatting "Comments"
  179. Formula to use number in cell to left & ignore any empty cells
  180. Formula help...
  181. Drop down filter box.
  182. Retrieve data from Access
  183. Automating A Cell
  184. Selecting between worksheets with offset
  185. Subtracting Military Time, with output in minutes
  186. analyze
  187. Need something like "lookup" but for text, not values
  188. left and vlookup
  189. Sumproduct
  190. VLOOKUP with IF functions
  191. Sum of Product Multiple Columns/Multiple Sheets, Indefinite Range
  192. Retrieve Formulas like Hyperion Ones
  193. Excel linking issues - inconsistent and frustrating
  194. Finding the cell address of maximum value
  195. multiple lookup including date range
  196. copying data from cells
  197. Extract Street Names from Addresses
  198. Change some numbers to date
  199. Excel formula for number selection
  200. Ranking Issue
  201. SUMIF criteria = x or y or z?
  202. Report creation from worksheet data
  203. Excel 2007 Beta - Unable to type more than 1 letter/# in any cell
  204. Summing abolsute differences between losts of sources
  205. funtion help
  206. Additions
  207. help please : counting iterations based on multiple criterias
  208. Dates
  209. Conditionally adding contents of a cell.
  210. What is up with Row 14?
  211. require some help with text function
  212. Linking single cells to related groups of cells?
  213. VLOOKUP Question
  214. How many combinations?
  215. Concordancy/Correlations
  216. Match and Vlookup - Help
  217. Random pick (multi column) info for audit
  218. To pull figure from a matrix by using three criteria
  219. Winning Team Order
  220. Kindly Suggest Number Format
  221. Question on AVERAGES and LOOKUPS
  222. Trying to change an operator in an 'IF' function
  223. Randomly choosing between 4 numbers
  224. how to find and remove automatic links
  225. Using the name of a worksheet tab in a formula
  226. If & Then ?
  227. SUMIF has me wacky
  228. Combining Two Sheets into One.
  229. Changing data in an entire column?
  230. Array formula not working - Please Help
  231. formula linking problem
  232. lookup / match list help please
  233. IF and THEN function
  234. Working with STRING of Characters
  235. Match Limitations: not finding value in cells with alot of text.
  236. advanced series copying help needed
  237. Hour to Second Unit
  238. VLOOKUP for satisfying multiple inputs
  239. Sorting groups of columns to a related group of columns
  240. need help finding the right function
  241. Can I sort within a sort?
  242. data lookup
  243. Convert text string help!
  244. Countif help
  245. Calculated Fields within Pivots
  246. Combining filters on different worksheets?
  247. Help Needed: Working Out Price Bands..?
  248. Find first value not in array
  249. Permutation & Combinations
  250. Average & Std Dev from filtered list.