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. Combining multiple lists into one !
  2. Numeric calculation
  3. CELL Function: cell reference by formula
  4. Can't consolidate non-data (ie text) cells from worksheets
  5. Working Merchandiser Schedule...
  6. Copying & Filling in data from One file into another.
  7. Saved excel workbook does not open from desktop icon
  8. Trimming cell contents?
  9. Find / compare result with list
  10. Conditionally summing cells based on conditions in other rows
  11. Use multiple criteria with COUNTIF: between dates and not blank
  12. Rounding up/down
  13. Calculating in a list
  14. Simplifying a formula
  15. Can I create an IF statement that looks for part of a string of te
  16. protecting ceels to copy -paste action
  17. dates, 1 month prior
  18. how do i setup a table of daily income and expenses
  19. can i calculate the number of occurances of a partucular value?
  20. Grouping According to Sets of Rows
  21. Making formulae function throughout worksheet
  22. return a list
  23. Pass variable to NORMINSV function to get only mean value
  24. Auto-create separate worksheets...
  25. formula to obtain difference between two dates.
  26. Two Workbooks into 1 File??
  27. how do I add Drop down menues in Excel?
  28. How do I write this formula in Excel?
  29. Formula
  30. Web Query (Excel 2003)
  31. Variable File Name
  32. IF or IF(AND Function
  33. How do I find unknown interest rate using TVM functions
  34. Another Date related question....
  35. Relative, absolute & mixed references in many cells
  36. SUMIF variation?
  37. add and subract in one sum
  38. Formula for calcing dates
  39. how to look up values with two independent variables
  40. VLOOKUP Query
  41. adjusting decimal place in protected worksheet in excel 2007
  42. adv filter
  43. Queation about monthly and weekly averages
  44. Please help me (urgent)
  45. Fixing some bugs
  46. A "ConcatenateIF" Function in Excel
  47. Extremely frusterated. 3 quick questions
  48. TROUBLE RENAMING A WORKSHEET IN EXCEL 2000
  49. how do I calculate minutes when given two times?
  50. How do I get rid of an extra page before printing on an excel sp.
  51. Can vlookup be used to search in more than one worksheet?
  52. sumif, countif, sumproduct?????
  53. A Tricky One......
  54. I love this forum! need help again!
  55. Help!!
  56. Problem understanding dependant lookups
  57. dynamic lookup
  58. How do I change color pattern based upon a formula within a cell?
  59. IF Statement
  60. I am getting a strange round off error in excel
  61. Relative references
  62. Inventory Spreadsheet
  63. DATE function clarification
  64. cell math to decrement/increment a cell
  65. VLOOKUP
  66. comparison
  67. Reset Worksheet Size
  68. validation from two columns
  69. Lookup table for two conditions
  70. excel cannot accepted the password and finily cannot open file
  71. How do you add figure with a word in?
  72. on excel file cannot acceted the password
  73. Combining spread sheets
  74. Error: The text string you entered is too long.
  75. Can anyone help please?
  76. Hyperlinks in pull downs . . .
  77. condtional format to
  78. If A1 has a #, that is displayed, if D1 has a # that is displayed
  79. Question about having the date autofill for schedule sheets
  80. Merging 3 workbooks when they are not exactly the same
  81. Formula bar doesn't have an equal sign
  82. Data downloaded with green triangle(indentation)
  83. Add to an IF statement
  84. Linking in the same workbook
  85. Extracting multiple entries in a cell into their component pieces
  86. Using Error Message as test Criteria
  87. Lookup Value in Range/Array and Return Column Header Value
  88. delete all values in column?
  89. Frequency of occurence
  90. find and paste formula
  91. Use concatenated text as name in formulas
  92. [sorting rows]
  93. data validation
  94. If Statement - With Formated text
  95. Using Replace command for replacing a character by an ALT+ENTER
  96. Finding unique entries among two columns of alphanumeric data
  97. vlookup or #N/A
  98. help with lookup please
  99. Counting unique records
  100. Re:Final days - London Excel Conference Registration giveaway
  101. Formula using INDEX and MATCH
  102. Data in Cells
  103. Calculate due date from a starting day
  104. custom validation
  105. count coloured cells
  106. Excel find/replace should allow values to be pasted in.
  107. countif criteria
  108. How to find avg for step size?
  109. help needed for Internal rate of return
  110. Time (Hours) calculation
  111. "Show all" button not work in protected worksheet
  112. Starting another program out of Excel VB??
  113. Average of lowest 5 of 20 values?
  114. web query help.. delay?
  115. finding duplicate rows
  116. How do I make a date appear in a cell only when I mouseover it?
  117. Adding category totals
  118. Contitional formatting help
  119. Find & Search Function
  120. "IF" functions for Excel?
  121. How to spread 15,000 into 12 months at 10% ?
  122. Display cell based on multiple cross-references
  123. Excel should let me set print gridlines as a default
  124. time calculations
  125. lookup error!
  126. Copy sum formula to Other columns not working
  127. How to change data in a cell, based on the date
  128. Function to sum a list of rows with different text except for one
  129. how to calculate the area under the curve in the excel?
  130. excel 2003 If function
  131. VLOOKUP using another table for comparison values
  132. complex average formula
  133. #N/A in mode worksheet function
  134. how to select cells with keyboard if the arrows don't let you go out of the formula
  135. Nesting Functions in a worksheet
  136. Nesting Functions in a worksheet
  137. Help... in excel.
  138. How do I make the cell flash on and off ?
  139. Excel: want neg numbers to show red/pos green via if-then formula
  140. Working spreadsheet highlighting function for Excel 2007
  141. how do I lock values in excel
  142. calculating adjacent columns in a work schedule
  143. Intersection of row and column based on input
  144. Sumif Across multiple worksheets
  145. tagging unique items in a list
  146. RE: calculating adjacent columns in a work schedule
  147. Excel Formula or access ?
  148. RE: calculating adjacent columns in a work schedule
  149. using vlookup between two separate sheets
  150. Double lookup without using vlookup?
  151. Adding one month to noncontiguous cells
  152. Formula for computing day of the week and time
  153. Beetween Sheets
  154. Creating a formula using RAND
  155. convert column values
  156. How do I set up a formula to throw out the 2 lowest scores?
  157. I AM TRYING TO USE BETWEEN IN IF THEN ELSE
  158. Assistance with Formula
  159. Simple SUMIF, I think...
  160. Need help with averaging a time but dates are messing up the result I am trying for.
  161. HELP WITH A FORMULA
  162. if or problem
  163. DATE ISSUE!
  164. indirect function within sumif to reference other sheets
  165. Inserting variables within file names
  166. Is there any File Auto Save Function for Excel and Word 2007 (Bet
  167. How i can create a formula that combine subtotals and sumif
  168. If this and this, then do a) b) or c)
  169. Filter formula
  170. Need to make a mark up table with more than 7 if statements
  171. Variable Cell Referencing
  172. remove #DIV/0!
  173. use the OR function inside an IF function
  174. Need step by step instructions to try, not a demo. Can't remember
  175. Need step by step instructions to try, not a demo. Can't remember
  176. How To Pick Winning Stocks
  177. vlookup on non-contiguous ranges
  178. Use of IF function
  179. how to hide worksheet using VB
  180. Extend series
  181. count criteria excell
  182. spreadsheets and auto General Journals postings
  183. vlookup help!!
  184. Difficult IF Function (For me at least) help
  185. Keeping the hyperlink address hidden in a cell.
  186. lookup latest entered match
  187. Copying information from 1 WB to another and loosing style
  188. matching values
  189. excel, can put name in one cell and get ther# in the next cell?
  190. how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
  191. How do I avoid duplicating names in excel?
  192. IF function with date
  193. Deleting blank worksheets
  194. Migrating information into another sheet.
  195. Need help with an embedded IF statement
  196. Insert Picture
  197. paste only subtotals, not individual date that makes up subtotal
  198. What is the formula used to calculate the 1st and 3rd quartile?
  199. EXCEL - PASTE SPECIAL COULD HAVE AN OPERATION TO REVERSE ORDER
  200. Protect my formulas!
  201. locked cells with 2 different passwords?
  202. Import Cell Data
  203. I need help with the IF function
  204. VLOOKUP in 4 work sheets
  205. Networkdays formula
  206. MATCH and OFFSET
  207. Yet another issue
  208. How do i find the counts of data with a condition of other cells
  209. is it possable to run an macro or script at start up as you could
  210. Double if statement
  211. IMPORTANT! HELP PLEASE! Formula
  212. How can I make the box remain empty instead of N/A#
  213. variance %
  214. formula question?
  215. How do I make the column & row heading bold Type
  216. Questions should be simple please help
  217. How do I break down a number by multiples in Excel?
  218. Help with cell formatting
  219. function help needed
  220. merge workbooks
  221. Formula Please help
  222. Remove dash(s)
  223. Sending automatic e-mails by date from Exel
  224. create 2nd list dependent on 1st list
  225. Using formulas to source a value based on 2 variables
  226. lbs ounces drams
  227. How do I color code the "SHEET1" Tab in Excel?
  228. "Too many different cell formats" error in Excel
  229. div/0 and #num!
  230. using a calculation in a list on another worksheet
  231. Paste Links not updating automatically.
  232. Complicated formula please help asap!
  233. changing dates.
  234. Using countif with a name of a range
  235. Please help - formula works in some cells but evaluates to #value in others
  236. Convert cubic centimeters to fluid ounces and cubic centimeters
  237. Matching Picture to Reference
  238. Worksheet numbering
  239. Filter isn't working with a VBA Code
  240. lookup field and copy the row across
  241. IF Function
  242. Check Box Macro to hide and unhide a column
  243. How to replace a cell if value is alphabetic
  244. Please Help With Days Elapsed And Days Remaining Calculation
  245. How do I select a value from a table based on 2 conditional refs?
  246. vary the vlookup array depending on the value in a cell
  247. How to insert rows in transposed data table?
  248. dynamic print area based on cell value
  249. Can a function do this?
  250. Help Please, Worksheet Change