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. Lookup for Multiple Values
  2. Automating Spreadsheet
  3. Help..Not sure which formula to use & How.
  4. Help with IF
  5. Look up and return a vlaue from mulitple criteria
  6. [SOLVED] count function
  7. View Data in a table
  8. Placing a formula in a cell from VB
  9. Multi-Speadsheet information merge!
  10. Help with a formula please
  11. column sorting
  12. Ignore other formulas when referencing a cell
  13. how to show 0.00 instead of #DIV/0!
  14. Rows misplaced when using multiple Subtotals
  15. Pivot Table percentages
  16. lists of permutations
  17. Error Message when inserting row ????
  18. Error Message when inserting row ????
  19. Vlookup Issue
  20. [SOLVED] Addition Formula
  21. Dependant Validation List
  22. [SOLVED] return MAX based on criteria
  23. Adding specified text to the result of a formula
  24. Cell to show blank until data entered ?
  25. SUM formula with Autofilter possible?
  26. Vlookup Help
  27. maximum capacity of a list
  28. SUMIF Help
  29. vertical lookups and matching within a range
  30. Looking up from a list and return from a range
  31. Can SUMPRODUCT do OR statements?
  32. Selecting a number of requirements from a large list
  33. Function to sum certain values in a list?
  34. Multiple INDEX's and MATCH Functions
  35. Subtract time w/Contraints
  36. DATEIF Function
  37. username formula
  38. Need a way to add diferent set of columns
  39. Calculating a Dynamic Array across columns
  40. Saving and/or emailing a worksheet
  41. Need Function For Find + Return
  42. Returns value based on value in other cells?
  43. Index-Match
  44. If Then Concatenate
  45. imputed income table 1 rates
  46. True / False problem
  47. More on weeks!
  48. vlookup across multiple worksheets
  49. Populating a matrix from a list
  50. Recording data in sequential rows without overwriting
  51. Taking info from 1 spread sheet to another
  52. Too Many Arguments
  53. COUNTIF with Relative Cell Reference
  54. IF blank, look at other cell and if it's >74, return "1"
  55. custom formula data validation
  56. #n/a
  57. VLookup Help
  58. Summary sheet for 10 other worksheets to auto update
  59. Excel Time question
  60. Centering on a Hyperlinked cell
  61. Subtract day and time w/o weekends or holidays
  62. If statements to reach a goal
  63. can I automatically import .csv file?
  64. Calculating Regular Time, Overtime, Double Time
  65. Sum value in a date range
  66. Highlight Duplicate Cells in Different Colors
  67. Confirming array formula (CTRL+SHIFT+ENTER) doesn't work
  68. Help with complicated AVERAGE formula
  69. Comparing columns
  70. How to add 0:15 after every 2:00?
  71. sumproduct and conditional formatting problem
  72. Filter question
  73. How to extract New data from old
  74. Copying Sub totals
  75. create condition formula
  76. Mass Copy Hyperlink Data
  77. division and decimal placement
  78. Help with spreadsheet
  79. average number of orders per day
  80. index&Match v vlookup
  81. Fixing column references in vlookup
  82. Worksheet Protection and User Rights
  83. Recognising dates for formula output
  84. if formula to show blank or show instead of displaying the running total
  85. Index and Match
  86. change celll value depending on range?
  87. Export data to word?
  88. south african excel useful link
  89. Is there an operator to look for any number in a range?
  90. if emtpy function
  91. Format individual cell to divide it's own contents.
  92. create a fuel table
  93. How do you get a cell to notify you when a certain date/condition is reached?
  94. Pivot Table Case Sensitivity
  95. Creating a dated column for 1 year
  96. IF, THEN Questions
  97. Vlookup with file location in different cell
  98. How to sort data by two criteria?
  99. looking up values
  100. VLOOKUP return multiple matches in columns
  101. how do I add values prefixed with a letter
  102. How to repeat a pattern?
  103. lookup (reverse lookup?)
  104. Formula to calculate specific cells
  105. spliting numbers
  106. Skip Column
  107. Ranking
  108. Insert rows and formula
  109. Using a Cell to Hide/Unhide a Work Sheet
  110. Missing columns
  111. Finding names in one list in another
  112. Lookup
  113. Converting Dates into periods
  114. Adding via formula then sorting - fix?
  115. Self-adjusting formula according to # of columns
  116. Exponential calculation
  117. Sumif/Sumproduct one column but not the other
  118. countif() then list all values
  119. SumIf
  120. Figuring out pay rate.
  121. nested if then functions
  122. Excel Formula Needed Please
  123. Average based on multiple criteria
  124. Linking challenge
  125. Retrieving Value From Another Wksht
  126. Sum If
  127. Macros including column width....
  128. Counting Formula
  129. Filling in a field based on values in another field in same row
  130. formatting cells with ages NOT dates
  131. Lookup in sub-tables
  132. Function: Cell (format) only returns G when value is Text
  133. TRUNC formula not working ?
  134. Find Multiplex Text Values And Replace
  135. sorting cell in excel
  136. finding repeat admissions
  137. Create a drop down list box with specific data!
  138. determine lead/lag times between series
  139. Formula for Costing Roster
  140. Using Formula
  141. Sorting By Formula
  142. converting numbers
  143. Dynamic Cell info based on another cell text
  144. Shading Duplicates w/cond. Formatting
  145. message appear in a cell if a user enters a number below the output range
  146. Excel 2003: VBA to control Header title based on date in cell B3.
  147. Averageif in Excel 2003
  148. count irregular names
  149. Populate many rows across many worksheets
  150. Vlookup help
  151. Entering a Ref Number Automatically
  152. Countif #Value!
  153. Bolding in a formula
  154. help on eulers method in excel
  155. Lookup both text and numbers
  156. How to say the following....
  157. Excel Formulas
  158. Entering a Ref Number Automatically
  159. Prevent #REF from replacing sheet reference
  160. How to find a cell value not in the same column or row
  161. Short form if statements
  162. [SOLVED] Calculating the number of days between dates
  163. "Average" Formula Help
  164. Double if statement??
  165. Count Unique Items
  166. Calculate Rate
  167. Vlookup from two list?
  168. IF Cell ? = 0,1,35,45,blah blah then Cell ? = 1970
  169. Help needed with forcasting
  170. Apples and Oranges = Time and Production
  171. Worksheet Not Decrementing
  172. Roundup to mutiple cells?
  173. Applying a "TEXT" function to an "IF" function
  174. Removing spaces
  175. Separating string
  176. Paste special values
  177. number of hours between two dates
  178. using Sumif with a range
  179. Compare values of 2 columns in one worksheet to 2 columns in another worksheet
  180. Need data cross-referenced in multiple tables: VLOOKUP vs. Match vs. Index
  181. find an error, notify user
  182. Finding first non-blank when there are formulas
  183. Issue with too many nested IF statements
  184. Average using VLookup
  185. IF conditions
  186. SUMIF function for multiple sheets
  187. Validation list & copying data from another sheet
  188. IF OR AND statement
  189. Formula for Costing Roster
  190. Combining Data
  191. SUMIF and then applying a criteria
  192. get the number from cell
  193. Help with Vlookup
  194. Daily fault reporting
  195. Merge & Sort Dynamic Lists with Data Validation
  196. Populate data to different worksheets
  197. Pivot Tables Excel XP - Repeat Data
  198. Problems with auto incrementing formula copying?
  199. Compare and then copy
  200. how to sum every nth cell
  201. Creating a search Dialog box
  202. Calculating Turn Around Time
  203. Vlookup depending on two matching Validation lists
  204. Every nth cell....
  205. Associate month # with abbreviated month txt
  206. =SUMIF(A2:A12,"Ben",B2:B12)
  207. Filter w/ Respect to List
  208. vlookup
  209. Text & Function in Same Cell
  210. Search & Delete
  211. Linked Workbooks
  212. Help
  213. Football updates in Excel
  214. AutoComplete Problem
  215. Count frequency of pattern
  216. Football Spreadsheets
  217. Subtracting The First Two Numbers In A Column Automatically Regardless Of Row
  218. Data Validation
  219. Sum col A if Col B equals breakfast
  220. Problem extracting data to another worksheet
  221. Counting pairs from 4 digit----
  222. Trim, clean and substitute function do not work for these data
  223. Remove Alphabet to return Numeric
  224. Display contents of a cell when another is greater than 0.00?
  225. Count Number of Times Per Minute
  226. realtime data formula issue
  227. Subtracting Time (in Min)
  228. Cell Value instead of reference
  229. how to include in countif?
  230. remove blank space in cell?
  231. Summing based on TWO search criteria (SUMIF?)
  232. searching for a string in a worksheet
  233. Showing the IC50 value on a graph.
  234. Count Formula
  235. pulling data from a master worksheet
  236. reversing first name and last name in same cell
  237. Sum minutes from HH:MM
  238. changing seconds into hours and minutes
  239. The IF Function
  240. INDEX & MATCH Function, IF
  241. Pivot Table Restrictions
  242. Frequency with grouping
  243. Excel Salary, Tax, and Net Earnings Calculator
  244. Multiple calculations in Pivot Table
  245. find hours left from now till 8-2-08 12:22:00
  246. Finding Intersections
  247. How do I compare cells in multiple sheets in a workbook
  248. Calculations by Period
  249. What is this function ????
  250. How to find a value and its associated row vlaues