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. Fantasy Football forumla
  2. How do I change part of a formula linked to another workbook?
  3. macro w/dates that change
  4. I have a question about accessing data in various worksheets.
  5. help me out please
  6. Lookup i think?
  7. Help with reference values from another worksheet
  8. Offset that change by it own.
  9. Referring to a COUNTed value
  10. Excel 2007
  11. Drop Down list Help
  12. what is the position of the first element of an array to be found in a string
  13. Finding Values for Multiple Ranges in one Sheet
  14. Adding the last digit of each number only?
  15. Time stamped data
  16. Display drop down list arrow?
  17. Hiding worksheets
  18. Multiple If Statements
  19. Adding cells that reference other cells
  20. Merging multiple simple survey's in Excel
  21. Extract records to another worksheet
  22. formulae 4 conditioanl formating
  23. Offset error
  24. More Statement Help Needed
  25. Date Range Parameter Query
  26. Intelligent Excel formula needed!
  27. Fantasy Football Draft question
  28. SUMIF color=...
  29. Display last date modified in cell
  30. Spreadsheets needs to update itself
  31. Help with Day/Date
  32. pivot table and % on grand total column only
  33. columns
  34. Calculating Percentages
  35. looking for a lookup solution
  36. Can this be done?
  37. How to compare data in table and return sum of matching pairs?
  38. Function for matching invoice and values
  39. PLUS to minus
  40. Locating a cell reference (not a value)
  41. Selected parts of worksheet needed in word document
  42. Randomizing list of Names
  43. Record in Workbook 1; same info appears in Workbook 2
  44. Link to external workbooks
  45. Is VLOOKUP/HLOOKUP The Right Tool
  46. sumif with nested vlookup
  47. automation of procedures in excel
  48. Lookup & Reference function
  49. Multiple Criteria count again
  50. Drop down lists
  51. Exel hour counting
  52. A simple VLOOKUP question
  53. If function
  54. TEXT and MONTH Functions
  55. how to extract month from dates
  56. 1 workbook - have multi sheet data populate seperate sheet in same workbook
  57. Is there a formula that can do this?
  58. Thanks Frank B!
  59. Need Help expanding a list....
  60. 1 from column A, 1 from column B - you get egg roll!
  61. SUMIF Using Criteria From Two Columns
  62. converting "strange" date format to standard date format
  63. Please Help! Reading only cells with content.
  64. Insert a number into a function formula
  65. "IF" Function
  66. Pivot table drop down list with data no longer valid?
  67. Pivot table & language dependency?
  68. Return offset data/values with lookup...?
  69. comparing two lists of data
  70. csv file with formulas
  71. Lookup type problem
  72. Max Function Question
  73. Linking to Word files
  74. Vlookup to return blank cell
  75. inserting values automatically from sheet1 to sheet2
  76. Eliminating unwanted rows
  77. Conditional formatting with a twist...
  78. SEARCH function, help needed!
  79. IF Function help.....
  80. IF functions
  81. Apply Percentage to Entire Worksheet
  82. checkbox excel 2007
  83. Vlookup
  84. Merge / Consolidate data
  85. Drop down lists
  86. SUMIF with sequential criteria
  87. Tabbing through cells
  88. Formula to put a value in another cell
  89. Vlookup?
  90. =SUM(IF(AND Array function
  91. EOMONTH Corruption
  92. exclude several values with one condition
  93. Function
  94. Subtotal Count Words!!
  95. Sum product
  96. Countif
  97. Command Button to increase cell value
  98. Data Validation to prevent symbols (\/|"*&) from being used
  99. Need help with Formula
  100. double entry
  101. Multiple dropdowns
  102. Day shift/night shift time calculation issue
  103. database help
  104. IF statement
  105. A quick question about the =IF(...,..,..) formula
  106. Counting digits in a number
  107. Split Date and Text
  108. count unique cells in a table
  109. Upper only first character in first word of sentences
  110. IF function - do not calculate
  111. reducing formula size
  112. sumif including 2 separated columns
  113. If Function problems - nesting
  114. replace specific character
  115. Hyperlink For Printing
  116. Very very confused with searching for rows
  117. order calculating inventory
  118. Linking revenue to a specific month
  119. excel formula I cant get right!
  120. Can I use custom codes instead of a drop down menu?
  121. Hyperlink Creating TIMEOUTs
  122. Month to Month Dates
  123. Drop Downs within a Drop Down List
  124. cell references in "COUNTIFS" function
  125. between function
  126. Looking to use math functions while colon marks divide the number
  127. Duplicate entire workbook
  128. Counting Weekdays + Saturday, omit holidays
  129. Find Dissimilar
  130. Data comparion by using pivot table
  131. HLOOKUP and date weirdness....
  132. Tricky Formula
  133. Adding worksheet with formula??
  134. A series with criteria of ten percent
  135. Text Issue
  136. Return latest word in a row.
  137. Function that displays duplicates when match on 2 columns
  138. Excel version of IF - WHERE
  139. Separating Out Contents Of A Cell
  140. Formulas for Elapsed Time - Non Standard Hours
  141. Use Fantasy Football to learn more about excell?
  142. 2 problems i need help with...
  143. Combination of IF function and List
  144. Locked cell identification
  145. New user and need help with a formula
  146. Fill down into merged cells without skipping rows
  147. Moving data to new cell if criteria met
  148. sorting table into 2 columns
  149. Vlookup a value if blank cell found after meeting two other criteria
  150. Vlookup a particular entry
  151. Excel Function Query
  152. Using Subtotal when list contains #N/A?
  153. Not sure what command...
  154. writing macro for multiple cells
  155. Counting rows satisfying two conditions
  156. Stumped on populating other sheet
  157. Vlook up issue
  158. concatenate tables
  159. Grouping Workbooks
  160. Paste non-identical data from one book into another
  161. Display Unique Names From a Long List
  162. Paste to worksheet
  163. Remove text of variable length from cell
  164. Matching fields in separate sheets
  165. SUMIF with 2 criteria
  166. Returning file path locations
  167. Sum dates
  168. Lookup Limitation?
  169. Checking for differences
  170. Multiple formula in excel?
  171. Copying Data From Excel to a Powerpoint Presentation
  172. Copying Data From Excel to a Powerpoint Presentation
  173. How to display all of the data of many spreadsheets into one
  174. Using DCOUNTA where 2 conditions must be met
  175. Auto Filter
  176. Info from one form updating other sheet
  177. Date related IF function
  178. Golf Score sheet
  179. index row, return dollar amount adding amount together
  180. Dynamic employee list based on date
  181. Inserting a variable into a linked reference?
  182. Wrong Sum() Showing
  183. Another one i need deciphering...
  184. Sumproduct and Or
  185. Changing vaules according to date selected
  186. pasting to specific worksheets
  187. AutoFilter vs. Lists
  188. The value of an empty cell in a formula
  189. How do I subsitute part of a formula linked to another workbook?
  190. Auto sort
  191. Multi-condition IF statement
  192. Linking cells, not data
  193. Duplicates in comparing two columns
  194. using the contents of a cell in a formula?
  195. Sum issue
  196. 2 sheets forumula
  197. Finding characters in a string
  198. Replace IF NOT!!
  199. commission formula
  200. Cell is equal to a folder name up 3 levels of the path
  201. Keyword Search on Strings of Text
  202. Specfic Users Only
  203. Desire Versatile Alphanumeric Extractor From Any String
  204. formating dates
  205. VLookup / Auto-Fill Question
  206. if statement
  207. Idiots guide required
  208. Match
  209. Average Formula Question
  210. populating list with unique values (revised)
  211. Counting Unique Text In A Column
  212. Drop Down Menu
  213. average product
  214. Populating Unique Values into new List
  215. Removal of preceeding set of numbers
  216. Overide the data in list box?
  217. Data validation
  218. Date forumula..
  219. Count unique characters in a string
  220. Average over multiple Sheets with DIV/0 Error
  221. preventing cell corruption
  222. Lookup Offset??
  223. Counting products delivered by month
  224. Latest value in a series of cells (not a column or row)
  225. Quick absolute reference question
  226. Conditional Formatting
  227. Where's my personal macro folder?
  228. Multiple Matches - Index/Match
  229. Vlookup with two criteria and if met do a second vlookup
  230. IF/AND Statement
  231. Excel Data Comparison
  232. Rounding
  233. Inconsistency with YEARFRAC Function
  234. Formulas do not add up correctly
  235. Forcing relative reference to update
  236. Why H column not working???
  237. Countif with 3 criteria
  238. Percent Change with negative number and a -0-
  239. Comparing data in multiple columns
  240. Sum ranked values in nonadjacent cells
  241. maintaing a formula
  242. Update an Item in a list
  243. Drop down menu/reference
  244. Breaking down a code......
  245. Vlookup External Workbook with Password
  246. Data exclsuion method
  247. Errors in functions
  248. coloring single cells within a list
  249. Graphical window in a worksheet
  250. cell validation