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. Automatic Text to Column?
  2. Button that inserts part of a formula?
  3. Hide & Unhide Rows
  4. Calculating the Percentage Completed
  5. What function to use
  6. Comparison Problem for tender bids
  7. Universal Constant
  8. eliminating records!
  9. Formulas change when column/row is deleted... how can i stop that?
  10. To count strings
  11. Offset??
  12. vlookup table help
  13. + 3 each day
  14. Formula help
  15. Trying to match year with data
  16. Create my own function/macro for validation
  17. max/large vlookup function ?
  18. Auto copying cells between worksheets
  19. sheet name as cell value
  20. Tricky Extraction Problem
  21. Excel formula
  22. How to keep a high water mark
  23. Need headers on 2nd sheet to match lists from first sheet
  24. Using a Worksheet as customer interface
  25. Cascading Drop Down Menus? Is this possible?
  26. Replace if condition is met
  27. Formula help
  28. Lord, they've updated my computer with Office 2003
  29. Delete Duplicates based on the Value of 2 Cells
  30. Copying worksheet references
  31. V-lookup
  32. Indirect(vlookup)
  33. Summing Ranges help
  34. Cell Referece retreval
  35. Yes, I need formula help please
  36. Lookup Formula help
  37. match and align cells in two columns?
  38. If function help
  39. Need help to sort out duplicate data
  40. Help With IF Function
  41. Calculate totals with an IF statement
  42. Finding the first entry in an array
  43. Last positiv number
  44. final date function
  45. updating a value using a macro
  46. Simple, I HOPE...
  47. SUMIF with mutliple critera
  48. Extract numbers only
  49. Sort all Data in EACH worksheet At Once
  50. Setting up an If Function
  51. Copy formula from one row to another
  52. Vlookup and find the total for a part number
  53. All formula
  54. Protection and Filters
  55. More help please with contact list....
  56. Vlookup help
  57. Switching words around in one cell
  58. % formula
  59. Concentrating several sheets in one master sheet
  60. help required
  61. calculate range
  62. VB code for formatting
  63. #value!
  64. Copy and Paste ALL search Results
  65. Extending Series Help
  66. Formula Help
  67. IF Function
  68. Count information on a table using multiple criteria
  69. SUM a group from LEFT or RIGHT
  70. Sorting Items by Length for a target length list.
  71. Combining "IF Statements
  72. Vlookup()
  73. Networkdays
  74. Criteria Between two ages problem
  75. Protect Sheet Causes Problem...
  76. Referencing a specific character in a cell
  77. Formula question
  78. Calculating conditional averages
  79. MATCH, LOOKUP, OFFSET, INDEX,...or what??
  80. Need help on rearranging data
  81. Counting subsets in a string
  82. Using the Worksheet name in a formula
  83. Using the ADDRESS function to refer to part of a range
  84. I want a value in a row that is not an error
  85. Point me to a Macro website for beginners.
  86. isblank i think?
  87. newbie queries
  88. Monitor excess time used for a service.
  89. can you?
  90. What's the formula for this..?
  91. Can anyone help figure it out?
  92. Help..Which Function
  93. 2 criteria to meet
  94. Sort Button to Sort a Column?
  95. Anyone can help figure this out?
  96. Help with my "=if" assumption
  97. FIND / SEARCH find nonnumeric
  98. converting digit to hour
  99. Help with copying rows to worksheets
  100. Help with naming tabs
  101. Performing hypothesis tests
  102. Help with VLOOKUP
  103. Rounding formual needed
  104. This array formula won't work?
  105. If functions and possibly or
  106. This should be easy...
  107. Finding * in cells
  108. anchor within sheet
  109. Conditional format for year
  110. Find string from the right
  111. Counting strings in string
  112. Combining Cells
  113. Barry Staples
  114. Formating query
  115. Array Formula - Concatenate
  116. need help with a scheduling program for nurses
  117. Concatenate not working! ARGH!
  118. Returning Values for 2 Non-Adjacent Cells
  119. conditional formatting
  120. VLOOKUP Help?
  121. Current cell formula
  122. Cross column conditional counting
  123. Function Formula using cells in named Range
  124. COUNTA Ignore cells to left
  125. < > vlookup
  126. Lookup Help..
  127. How to do a weighted median?
  128. CONCATENATE not working
  129. Summing 'n' values in a spreadsheet
  130. Column Match
  131. Difference function.
  132. Multiple if statements
  133. Keep borders from being deleted
  134. I need help please
  135. Sorting
  136. Lookup, True, IF ?
  137. Magical formula for suggesting a value?
  138. SUMIF function
  139. Sustituting formula references
  140. looping thru all columns in a worksheet
  141. Find and Replace Instances of a Word in a Cel
  142. CountIf with filters
  143. Array..I think??
  144. Populating one column with row data
  145. If function for multiple options?
  146. Insert row based on criteria
  147. help! on sumif w/ date using multiple criteria
  148. Timesheet Regular Time and Overtime w/Account Codes
  149. Cell Required Feild
  150. How to Prevent Worksheet from Deleting
  151. Function Help Please
  152. Time and Conditional Formatting Problem
  153. Offset??
  154. Link one workbook to another workbook?
  155. Returning null values/cell formatting as criteria?
  156. Using If, Or, or something like that.
  157. Need Help ASAP - Comparing Multiple Columns
  158. surveys on use of Excel
  159. Protecting Drop downs
  160. Formula with one changing variable: The Worksheet to which the formula is linked
  161. Help with Excel Formulas
  162. Displaying formula syntax
  163. math operators ><=
  164. Worksheet VLookup Newbie Help
  165. Grabbing data from columns B-F into A
  166. advanced (i think) if statement help
  167. SUMIF and show blank if zero on timesheet
  168. Adding "?_" to all cells in a colum?
  169. adding to this formula
  170. Formulas and Filters
  171. IF formula
  172. Please help with date commands
  173. How to optimise IFISERROR
  174. Trying to add numeric values in range
  175. Comparing Three Cells
  176. Using IF Function with conditional formatting
  177. Subtotalling specific criteria
  178. how to approach this?
  179. The IF Function
  180. Countif using 2 criteria
  181. Formula in Conditional Formatting
  182. Calculating the average of every value in every, say, 12th cell
  183. Date series-help!!!
  184. Trying to design a double entry book-keeping ledger i need some help!
  185. If and Or Function???
  186. VLOOKUP Help
  187. Copy and pasting formula question
  188. writing conditions for validation lists
  189. Function not returning correctly please look
  190. Formula not working. Please help
  191. if function returning false instead of my selection
  192. Removing spaces in a blank cell
  193. Not quite VLOOKUP?
  194. kinda complicated need help
  195. Similiar to VLOOKUP?
  196. Can I convert a column of data (e-mail addresses) into a comma dilimeted format?
  197. Macros
  198. Spell Check
  199. Number Formating
  200. Compare and extract
  201. adding numbers to a vertical column
  202. Combining multiple lines of text
  203. I'm sure this is simple...but doesn't work
  204. How do you return the 5 most recent dates from a list?
  205. List of categories
  206. Adding specific criteria
  207. sum - region wise
  208. Excel If Function
  209. Help please with comparing cells
  210. Vlookup + Indirect
  211. display contents of array in cell
  212. Add '$' to all formulas?
  213. Finding Average if today's date has arrived
  214. Automatic Date Input
  215. Number formatting with multiple conditions
  216. Formula
  217. Formula too long - Nested IF statement with VLOOKUP
  218. VLOOKUP or INDEX AND MATCH?
  219. sum of column Q when column P = current month
  220. ADVANCED: Extracting unique records
  221. Conditional Formatting...?
  222. Help
  223. Please Help!
  224. Looking For Simple Solution to adding up hours.
  225. letter grades based on percentages
  226. Multiple Conditional @IF Statement Not Working?
  227. Counting Problem
  228. Timesheet calculation
  229. Difference between todays date and a future date minus the weekends?!
  230. help with a formula for working out commission earned...
  231. Conditional formatting
  232. Need help solving this problem
  233. =INDEX(..) need help!
  234. Displaing related text under a heading (from a set choice)
  235. Calculating someone's age today based on DOB in another cell
  236. How to make text in a cell to disapear when i click on it?
  237. FILTER - how to filter numbers ending with 00
  238. error message
  239. Sumif...
  240. Looking up against a variable named range??
  241. problem with Activecell
  242. CraCk thIs Nut!
  243. How to split an address field into two columns
  244. how to delete the blanks in the worksheet?
  245. CONCATENATE w/Dates
  246. Find the Formula used to Convert A to B
  247. SUMPRODUCT and SUMPRODUCT?
  248. Date Data Management
  249. Problems With =COUNTIF()
  250. problem FINDING & Deleting links?