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. unwanted space
  2. Mixed Text and cell ref - Problem with date formatting
  3. Find Duplicate from Different Columns
  4. Too many IF statements
  5. Skipping blank cells in a list to create an uninterrupted list
  6. Excel countin formula problem
  7. Converting date to Work Week
  8. data compiling problem
  9. Rounding
  10. Count Formula
  11. A Shortcut to Inserting Rows
  12. freezing multiple areas within a worksheet?
  13. Naming the month
  14. Sum not working
  15. Conditional Formating
  16. Average problem
  17. finding the N! routes in excel
  18. Ranking
  19. Week # Date function
  20. calculating interest
  21. Query and sum based on multiple parameters
  22. Frequency count
  23. calculate net working days
  24. function to find name related to highest value
  25. Adding 4 sector times to show lap total
  26. How to copy some columns from sheet1 to sheet2 or sheet3
  27. Averaging data in one column corresponding to specific names in another column
  28. SUMIF in a given month
  29. Sorting data
  30. Calculate how many times something appears in a worksheet
  31. build formula using 2 cells, evaluate that formula in 3rd cell?
  32. cricket batsman highest score from list
  33. Date "condition" to bring up a value in a specific cell
  34. Working with nested if's.
  35. Equivalent of countifs function for Excel 2003?
  36. Blank cells and LOOKUP
  37. Quickly switching currencies in a worksheet
  38. Look up text and return cell address which can be used for calculations
  39. Figuring out checksum formula..
  40. Data Validation Custom with Formula
  41. evaluate a concatenated formula.
  42. Programmatically Searching Formulas for Sheet References
  43. another vlookup q
  44. linear interpolation 2-way table
  45. vlookup & #N/A
  46. Problem with M S Excel, copying to floppy
  47. Suggestions for linking drop-down lists and other data
  48. Data Validation - Dependent Lists
  49. IF Formula limits
  50. summing times error
  51. Corresponging cell against Max Vaule
  52. Max Function
  53. calculating aged days
  54. 1/100ths of a second rounding up
  55. Using a returned cell reference in a function
  56. Isblank
  57. excel vlookup blahness
  58. Index/Match Question
  59. getting rid of the first 3 characters of a number
  60. mergeing 98 sheets into one
  61. VLOOKUP advice
  62. Summing question
  63. Error message question
  64. Find a MAX value, then take the name 3 cells over
  65. If statement + assign number to string
  66. Fixing Contact Numbers
  67. Improving column navigation
  68. complex contact list formatting...
  69. Reset Formula without Editing Formula?
  70. Average days per month
  71. Combine 4 worksheets into 1
  72. Dates Excluding Sundays
  73. training date experations
  74. Drop Down Box with auto-fill on other cells
  75. Data Analysis Assignment
  76. If & Match
  77. Dynamic name range in excel 2007
  78. Finding the first amount in a cell
  79. cell placement
  80. Problem with INDEX & MATCH formula
  81. Letters Numbers and dashes
  82. Additional selection
  83. converting numbers
  84. Using INDIRECT to Link to Other Spreadsheets
  85. Formular to add 12% to my entry
  86. Input range only and calculate Average of that range in another cell
  87. Display Formula in A1, Result in A2
  88. User defined rules for autofill of functions
  89. Report latest value in column
  90. Counting number of unique entries in a specified range
  91. Change cell value with checkbox
  92. Match name and return recordID
  93. Converting seconds to the excel date value.
  94. Formula to limit the minimum waste
  95. Enter Value From Dropdown List And Have Values Update
  96. Counting consecutive non-zero values
  97. Adding Hours
  98. Clearing data in protected worksheets
  99. Cosine Squared?
  100. saperating colored cells
  101. SUMPRODUCT to add incremental dates?
  102. sorting
  103. Nested if other options
  104. Updating a Web Query on Protected Sheet?
  105. Index, Match and if
  106. Convert time
  107. Vlookup Error
  108. Returning Cell Address based on a Lookup Function
  109. interest rate issue
  110. OFFSET drama
  111. VLOOKUP question
  112. Output of a cell as the condition for a filter
  113. Inserting Text Cell References in Hyperlinks???
  114. correcting sorting function.
  115. Making an values in hours into a number for the purspose of a calculation
  116. Merge Seconds to H:mm
  117. Three excel questions
  118. Countif function
  119. triple-if function help???
  120. lookup
  121. Formula recognizing date range?
  122. pivot
  123. Column totals to remain when deleted
  124. Sorting and hoping to change a line number
  125. Sort function
  126. Adding Percentage in formula
  127. Find & Replace only a portion of a cell
  128. GoalFinder/Macro question
  129. Formula for vacation accruals
  130. VLookup: can I use an If statement for the column?
  131. sort list by last character
  132. Sort email address by domain
  133. Lookup then update?
  134. matching columns and producing results
  135. Copying Formula's
  136. Data between different worksheets
  137. Multi-Level VLOOKUP
  138. If then function
  139. How to paste content in multiple cells?
  140. Cell that links to two possible hyperlinks?
  141. auto number fill with 2 criteria
  142. max with double criteria in a range
  143. fx to calculate seconds from minutes
  144. 2 Criterias, 2 Sheets lookup?
  145. What is this formula, and where is it getting data from?
  146. Dedicated cell for search
  147. not able to copy worksheet
  148. Transposing Formula
  149. Track Changes with conditional formating?
  150. Easy-#N/A error Which fix to use:iserror/na()/ISNA/ (in Index, Match string)
  151. Selection of data on different worksheet
  152. Not same randoms
  153. Using ABS function?
  154. Finiding unique items in a list
  155. Sheet with consolidated data
  156. Reference data cell populate a number corresponding to data in another cell
  157. conditioned check function
  158. Counting down fractions
  159. refrence a cell from one sheet to another issue
  160. Tally letters as a number
  161. Cell flash
  162. count a
  163. relative references
  164. Cell data functions
  165. #value!
  166. Inserting Rows
  167. MATCH INDEX For looking up lowest date
  168. LOOKUP Function
  169. Y-T-D averages
  170. Payroll Spreadsheet
  171. multi column table of area codes per state
  172. exclusive/shared
  173. counting bet downs in tote board
  174. Add "X" amount of months....any way?
  175. Look up
  176. Echo from external workbook++
  177. Countif with multiple criteria crises
  178. Conditional sorting
  179. minutes into seconds
  180. COUNT function?
  181. Convert Text to Value
  182. Conditional Formatting
  183. replacing 2 letters in a field
  184. delete numbers and semi coolns from data
  185. OFFSET function
  186. How to read from a particular cell
  187. Count problem
  188. Date arithmetic - not giving me what I want
  189. Save Date And Time
  190. sumproduct not adding correctly
  191. Macro/GoalFinder question
  192. Result of Roundup used in a calculation
  193. index/match
  194. if cell A1=x then cell A2=y
  195. Drilling through worksheets
  196. sort a set of data based on another set of data
  197. subproduct/if
  198. extract part of a cell value in another cell
  199. Vlookup from a seperate workbook (or maybe a database)
  200. cell colour
  201. Vlookup Query
  202. how to generate date in Excel
  203. compare 2 colume
  204. Another IF with calculating formula
  205. Advanced formulas (nesting match and vlookup?)
  206. Using formulas to display data on new sheet
  207. IF with calculating formula
  208. Copying data between Excel documents
  209. Is there a way to speed this up?
  210. Exporting Data from one file to another
  211. same lookup function working in some cells not others
  212. multiple lists
  213. if range question
  214. Find function <0
  215. Problem with sum
  216. Color IF
  217. Sumproduct
  218. Advanced Sorting Question
  219. Counting text in range subtracting from par
  220. Calculation - Table Query?
  221. String Functions
  222. NETWORKDAYS not working
  223. calculate the number of working hours between two dates
  224. INDIRECT(ADDRESS(...)) in ranges
  225. Extract Numbers with (- +) sign
  226. Running Total
  227. Offset and count function
  228. "Vlookup"ing the MAX value
  229. Enable conditional formatting
  230. embeding an image into a cell
  231. Validation
  232. average/if
  233. copying values from multiple worksheets
  234. Sumif Functions?
  235. using multiple criteria with sumif
  236. dates (increments of) and formulae
  237. Summarizing Data (Sum if? Count if?)
  238. Nesting IF's and AND's...
  239. If function with rounding
  240. Count, If statements and aged count
  241. Summary Sheet using date range
  242. Combined If/And not returning expected value
  243. Pivot table question
  244. incorperate two formulas to create one
  245. Multiple If Conditions
  246. Count depending on the condition
  247. If statement
  248. SUMPRODUCT across Multiple Sheets in the same workbook
  249. Trying to create database & spreadsheet
  250. Linking a list to a report