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. Functions with DB Query Reference
  2. Using the 'NOW' function within an 'IF' statement
  3. DATEDIF function not working for YD in EXCEL2007?
  4. Column problem
  5. Rank if??
  6. Dependent Validation
  7. MAX and Selection Criteria
  8. sum until value greater
  9. How do i apply multiple criteria in a formula?
  10. Total sum keeps showing as 0.00
  11. Two conditional validation
  12. Compare cells
  13. Greater than, equals, less than, All in one cell?
  14. Subtracting a number from the next highest multiple of 10.
  15. Formulae
  16. additional column
  17. Using ISTEXT to search the same column
  18. Sales Function Req.
  19. Freeze Variable Cell to a Permanant Number
  20. Date formatted in text and age problem
  21. textbox fill color
  22. Advanced Filter
  23. identify the LAST value in a subtotal in a Pivot Table
  24. Counting cells and displaying results
  25. Updating Stock Prices
  26. insert a picture
  27. trailing zeros
  28. Countif Formula
  29. How Many Services in A Month?
  30. If Formula question
  31. Sorting account codes
  32. how to make a column become color
  33. Copying Excel sheets with all formulas
  34. return last number in column
  35. Referencing to another worksheet
  36. Sumif
  37. Vlookup question OTHER THAN #N/A
  38. Text function
  39. Nested IF Statement
  40. Getting values from same cell on multiple sheets
  41. changing text format
  42. Remove 1st digit
  43. Keep formatting during import
  44. Functional Issue
  45. retrieving values which are not 0 from an array
  46. more than one criteria vlookup
  47. adding up numbers with multiple conditions
  48. sum of absolute values
  49. function??
  50. log to excel
  51. creating a button that adds/subtracts
  52. Conditional formatting based on another sheet
  53. Copying a portion of a Table.
  54. Attach a macro to a hyperlink
  55. Automatic formatting when opening CSV Files
  56. Where is active cell on a sheet?
  57. Req. Formula for converting a letter to a number
  58. easy forumula countif?
  59. multiple matches
  60. Counting instances of "N" within a date range
  61. Nth root question
  62. Drop down menu lists items from a table
  63. Comparing multiple cells
  64. using V lookup on multiple occurences of numbers
  65. Clear data but keep cell values
  66. Reference tab name based on cell value
  67. Calculate
  68. IF Cell Contains Text That Begins With....
  69. Lookup function
  70. I suppose I use a web query?
  71. Identifying and moving(copying) cloumns
  72. Multiple data per cell? Data validation question
  73. count < or > 15 days from current date
  74. Autofilter - Selecting multiple values
  75. Can you hide tabs within a Workbook
  76. Automatic Sorting Alphabetically in an Array
  77. Separate column in pivot table
  78. Count question
  79. FormulaArray size in macro
  80. Standard Deviation of database
  81. How to do a count for a Group
  82. Index function
  83. Extracting letters from names
  84. Monthly customer billing question
  85. Counting specific characters
  86. Income formula/function
  87. Need best way to handle summary
  88. Get If function to return a drop down menu
  89. Selecting from List
  90. Column Data Conversion
  91. How to calculate Total Units * time per unit
  92. left()
  93. Multiple users of one excel sheet
  94. add cells that meet certain criteria
  95. Vlookup not retrieving data....???
  96. Vlookup or Index Match on 2 matches
  97. Spreadsheet function
  98. Referencing Next Column Over
  99. Named Ranges and INDEX/MATCH
  100. Attempting to subtract time for a 24 hour period
  101. How do I drag the sequence of letters/numbers?
  102. Offset formula
  103. When is MATCH not a MATCH = #N/A
  104. Can I use colour
  105. Array Formula with nested IFs
  106. Adding users initials automatically
  107. Spliting a name cell
  108. Adding % to a Range of Prices???
  109. short in in code
  110. VLOOKUP Stinks
  111. SUMPRODUCT - wanting additional results
  112. Conditional Protection of worksheet's
  113. Finding the closest number on a column
  114. Removing Chinese Characters from a spreadsheet
  115. Average non range problem
  116. Vlookup Not Retrieving Data
  117. SubTotals Or Pivot Table
  118. Date + 7 but only if populated
  119. function/formula question
  120. Match or Search formula
  121. Variable cell references
  122. Modify links with calculations
  123. Basic IF function
  124. how to get the cell reference instead of its value?
  125. Looping question
  126. Looking up values.
  127. Count rows which meet criteria
  128. Populating a cell in a column from another sheet
  129. Replacing/Rearranging cell entry
  130. SUMIF using server path
  131. IF Statement formula problem
  132. Find data on previous worksheet
  133. countif in a range?
  134. Worksheet Links Issue
  135. ISERROR/OFFSET formula
  136. DSUM Function Problem
  137. Another IF Formula
  138. digit to word conversion
  139. divides the amount of an item by how much i have across all 6 groups
  140. Time Calculation
  141. If statement
  142. VLOOKUP Returns Zeros When Data is Plainly There
  143. Premier League Stats
  144. enter 123 it displays in cell as 1.23
  145. sumif
  146. ISBLANK & ISERROR In One Formula
  147. Countif funtions problem
  148. hyperlinks on cd's which chg root drive designations won't work??
  149. Splitting a multiple line cell
  150. Counting Services
  151. Linear Interpolation between non constant intervals
  152. Formula to convert milliseconds into minutes
  153. Repeated values
  154. Formula or Macro?
  155. advanced formula
  156. Duplicate Detection
  157. Statistical Formula Question
  158. writing a formula to return non-empty cells
  159. IF Function
  160. A template problem
  161. vlookup and interpolation
  162. skip row if cell=?
  163. Formating with color cell that content Text
  164. multiple criteria in count function
  165. How do you automatically update content between excel documents
  166. Can Sumproduct Return Text Value
  167. Subtotal question
  168. Problms w/ named cells
  169. importing data
  170. SumIf problem
  171. Display $ Value for "today" automatically on open
  172. insert row if
  173. ??? Counting Months In a Column
  174. Formulars getting too complex
  175. Comapring Ranges
  176. Stuck - multiple argument formula COUNT
  177. formating data exported into Excel into a workable format.
  178. Extract data from middle of a cell...
  179. Data Comparison
  180. Colored Cells
  181. Tidal Calculation
  182. Text Random selection from a range?
  183. Combining 2 Formulas
  184. Moving Lookup Function - A solution you might want to use
  185. changing multiplier IF......
  186. 24 hour time problem
  187. Isnumber Format Problem I Think
  188. Filtering
  189. Inserting a cell without altering forumlaes
  190. Circular referance problem
  191. Vlookup, combining 2 sheets into 1.
  192. Sorting data by cell format
  193. If Statement Logical Statements
  194. Sum numbers in a row where cells also contain text.
  195. Pointing
  196. Apply a single formula on multiple cells
  197. Begins With Function??
  198. Find matches between lists
  199. Duplicates based on 3 columns on different worksheets
  200. Combining two IF Functions
  201. Making a database
  202. OBDC Grouping
  203. how to create a drop down list
  204. Want to create a forumla on daterange
  205. array not working as a macro
  206. VLOOKUP issues
  207. Find Matching entries
  208. Automatic generation of a report sheet.
  209. Define name formula
  210. Rounding down to 0.50
  211. question about data entry
  212. Conditional Adding
  213. How do I fill in formulas?
  214. Anyway to add up an entire coloumn?
  215. Solving as x?
  216. DB refresh causing errors
  217. Auto-Updates from a URL
  218. Data Validation
  219. between function
  220. count cells in a range based on another cell
  221. Conditional fromatting to another sheet...
  222. Filtering a column with vals from another column
  223. Cell To Show Current Week No.
  224. Using a cell as a variable
  225. Translation issue with NETWORKDAYS
  226. Round to nearest 0.5
  227. Subtotals with countif not possible
  228. Automatic update of data coming from other worksheet
  229. auto fill question...
  230. convert cubic centimeters to fluid ounces
  231. Formula for Conditional Formatting in a PivotTable
  232. Auto Functions/Template
  233. Nested IF
  234. Counter but not for beans!
  235. Not sure how to transfer data then sort it.
  236. adding multiple cells from same column
  237. Searching for text within a range of cells
  238. Extracting numbers from a cell
  239. Formula help
  240. Vlookup problem
  241. Removing of too many digits
  242. DSUM using critera in non-consecutive cells
  243. Counting Using Criteria From Two or More Columns
  244. Find a value and show it's location
  245. Index function
  246. Double quotes in concatenation?
  247. Counting different lines
  248. Countif a number is between two numbers
  249. Combined Months of a year into a year
  250. Is it possible?