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. Average & Std Dev from filtered list.
  2. countif function
  3. Automatically Combine Worksheets
  4. COUNTIF function help
  5. Lookup
  6. Calculating time difference between two days capturing the overnight time.
  7. ignoring blank columns in pivot table
  8. Comma separted values
  9. Trouble with SUMIF
  10. Need help with bond yields
  11. help on a solution to a "countif" question
  12. Cell References sometimes don't update!
  13. Question; any and all help much appreciated!
  14. schedule date tracking
  15. Ascending order and IF
  16. let us try again on if
  17. Probably a basic question, but beyond my grasp
  18. formula to change address of external data?
  19. Sumproduct
  20. function for dedup... again...
  21. Convert cell reference to text string
  22. Multiple worksheets - opening options
  23. Allowing for New Sheets
  24. Stripping Text
  25. Making first letter of each word capital
  26. insert row and keep format and formulas but no data
  27. parsing comma-deliminated data into multiple columns
  28. Isolate 1st 2 letters in a column
  29. need help with days past due calc.
  30. multiplying time function
  31. Referencing Worksheet Name
  32. MIN value ignoring zero values
  33. Multiple If statement or SumProduct?
  34. Want Corresponding # in Sheet 2 to appear in Sheet 1
  35. sort and insert blank ...
  36. Function to perform dependant on criteria
  37. Relative links / cell references
  38. Newbie help with simple % formula please
  39. Another Quick easy one?
  40. Probably a simple question for most of you!
  41. Retrieve every 5th data point from one column?
  42. Formatting exported DB data with IF(AND)?
  43. How to delete some text after copy/paste
  44. Error in lookup/match
  45. How to make an if/and function examine range and return
  46. need *find function* help!
  47. Help required with Vlookup and INDIRECT
  48. Adding conditions to a VLOOKUP
  49. Appending a worksheet function to a line of code
  50. Time functions
  51. IF with multiple results?
  52. feature for Excel
  53. Need to find corresponding cell from 2 values
  54. AVERAGEing Most Recent n Entries
  55. If Cell Contain A Letter
  56. Data Validation using IsNumber and IsBlank
  57. Need help please
  58. Drop down menu in cell
  59. Find lowest number, greater than 0
  60. Multiple count if
  61. datedif trouble
  62. Web Query help please
  63. I need help with filling words down....
  64. Formula that multiplies X for every Y unit
  65. Difficulty with round function
  66. if statement with two conditions
  67. Not sure what function to use
  68. Using VLookUp to build Data Validation List?
  69. Pushbutton and Macro help
  70. assigning values to terms
  71. I'm getting closer, one more part
  72. IF function help
  73. Vlookup? Help
  74. Date question
  75. =IF statement
  76. Interest Calculation
  77. Compound Annual Growth Rates in Pivot Tables
  78. How to remove duplicates from a column
  79. displaying results
  80. Odd and Even Numbers
  81. Data sort by format??
  82. Year()?
  83. Formula help
  84. Counting nonblank cells - 3D
  85. Conditional count in Excel
  86. Count Unique Entries
  87. Template sheet changes carry over into copied sheets
  88. Protecting a Workbook
  89. How to find min/max and its corresponding input several columns/rows away in PivotTab
  90. SUMIF help
  91. Table of Contents
  92. Rank function is this possible?
  93. Start and Finish Date
  94. If then statement problem
  95. Count based on criteria
  96. Looking for high-skill Excel spreadsheet developer
  97. Formula help
  98. Inventory Totalling Challenge
  99. IF for Payroll Processing
  100. Is this possible?
  101. How to merge multiple columns/words....?
  102. Here is a tough question! IF formula output
  103. Showing the IC50 value on a graph.
  104. MS Query in Excel
  105. count help
  106. help seperating city and state. Text to column creates 3 columns
  107. Need to test for multiple variables in columns
  108. Put Column A into a hyperlink on Column B
  109. Complex calculation including extraction of month from date field
  110. Salutation help
  111. ADDRESS Function
  112. Javascript function converting to Excel function
  113. SUMIF using the sheet
  114. rounding function
  115. Deposits & Sales
  116. date between 2 dates?
  117. Updating list of worksheets
  118. Two SUMIF scenarios
  119. Date Formula & Alerts
  120. Conditional Format based on value of other cells
  121. How do I remove duplicate text from cells
  122. formula help
  123. Choose Function
  124. Help needed, please!
  125. Any suggestions on how this can be improved
  126. Nested IF with Vlookup Help Required?
  127. Changing a formula when copying
  128. Maintenance of Print format not constant?
  129. Date Function Inept
  130. Check for Division by 0
  131. Summarising info in a spreadsheet
  132. Using excel in a web page
  133. 'If' syntax
  134. Multiple Cell find and replace?
  135. Vlookup & Sumif (Maybe/Maybe Not)
  136. Transposing within a formula
  137. One more "INDIRECT" function woe...
  138. Password protected worksheet
  139. Getting data from other worksheets
  140. Formula for multiple conditions?
  141. Big problem with SUMIF.........
  142. Help using SUMIF with multiple Sheets
  143. Need help with SUMPRODUCT with IF
  144. RAND function
  145. DATE Functions in Excel
  146. % Change Question
  147. Running Balance Calculation - with timestamp parameters
  148. Formula to Match 2 items
  149. Creating a macro to find and/or replace text
  150. Time log entry
  151. get values using wildcard
  152. combining column number and hlookup
  153. calculated new fields in pivot table
  154. Sum Function with exceptions to criteria?
  155. SUMIF problems
  156. Quiz Master needs help!!
  157. Month and Year
  158. Time periods as minutes : second
  159. how do you do this .......
  160. Use dates to define a set of data?
  161. convert date number to date format
  162. Help with an IF VLOOKUP, please
  163. Linking data listed in one spreadsheet to another
  164. Calculating diff in time
  165. formula for subtracting
  166. Bill Payment Calendar
  167. Why my post was deleted? Please explain thanks!
  168. Complicated Function, need assistance please
  169. Count Conundrum
  170. Merging Rows Based on Common Column Value
  171. Using Sum with TRUE/FALSE Functions
  172. Date Calculation
  173. Add row in multiple sheets and fill formula!?!?!
  174. Indirect doesn't work when sheetname have spaces
  175. Vlookup table only works in alphabetical order???
  176. vlookup and relative links
  177. Is it possible to modify large amounts of data without retyping?
  178. restarting a calculation based on a cell value
  179. Excel 2003 formula
  180. ...lost
  181. IF and VLOOKUP statemanet...need to get rid of #N/A and get 0 instead
  182. referencing problem
  183. How to calculate Expense with Price increase per year
  184. best way
  185. Is it a countif? Is it an if? No! It's a...?
  186. Maybe an IF Statement?
  187. Help with If/And Logic Functions
  188. Tricky formula
  189. How do I place a button in a cell?
  190. Help with date formula
  191. DoCmd.TransferSpreadsheet-Range and Filename problem
  192. Presentation of Date ( Calendar)
  193. count number of text or numbers in a cell?
  194. Counter for invoices
  195. Double SUMIF
  196. Pricing on a 'sliding scale' possible?
  197. Replace blank cells to shading?
  198. Match Function problem
  199. if statement with mutiple col/row support???
  200. 0019 and 49 = 1949 I need 001949
  201. display date in date format
  202. Need Help Plz.....
  203. app.insertFunction.Trend(known Y's,know X's),Nex X's,True
  204. IF Nested with Vlookup?
  205. hyperlinks to other worksheets
  206. Flagging Duplication In Columns
  207. Lookup Sum
  208. Data Sorting
  209. excel "IF" function help
  210. Formula Suggesstion Required
  211. Can you use "LARGE Function with VLOOKUP?
  212. Date ....?
  213. Any Solution ?
  214. Convert excel date to date format
  215. Unique No in column
  216. using IF Statement
  217. Lookup woes
  218. help with using function in Excel
  219. Need Help on If Statement
  220. Place permanent data window? On worksheet
  221. Nested Lookup Function to Return a Value
  222. Budget Calculation Help
  223. IF Function
  224. Running a filter depending on values in other cells
  225. Using Cell Values as Equation Variable
  226. How to Search for data in multiple column?
  227. Help me please! :(
  228. I can't unhide sheet
  229. range that changes as i enter new data
  230. How would I go about doing this?
  231. How to set ranges for an array formula with VBA
  232. Need to call a profile by a key in cell recognition
  233. Database Function Criteria range
  234. Duplicate Entries, Validate Only One
  235. Calculating dates based on a particular cell
  236. Help in adding rows in between weeks
  237. Sorting across multiple sheets
  238. Help with IF function
  239. Help! Divisible by 75 Function?
  240. Counting
  241. changes Vlookup
  242. If Then Conditional Function
  243. Show string based on conditions from another worksheet
  244. Data Validation for unique values
  245. Tracking elapsed business hours
  246. Changing Links in VBA
  247. VlookUp
  248. Can I use this situation?
  249. Lookup Formula
  250. Same format & func. for 07 worksheet