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. Why can't Conditional Formatting do other formating such as number
  2. Can you use INDIRECT in 3-D references?
  3. worksheets
  4. macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting
  5. How Do I add/sum the numbers in one cell...((More Info Below))
  6. How to Copy a Cell from one worksheet and return
  7. Stumped....Matching Columns
  8. Sorting in Shared Workbook
  9. how do I open a publisher file in front page
  10. formulas/function require (2)
  11. Calculating cells with text only
  12. Here's a good one!
  13. Macro to capture worksheet names
  14. index/match/replace
  15. help making formulation
  16. =NETWORKDAYS not working as expected and as it once did
  17. cells visable and following. Not freeze
  18. Excel formula Q
  19. Stumped with an IF function
  20. Help With Formulas
  21. formula to remind me of an appointment 3 months in the future
  22. Help..... with formula
  23. DATEDIF
  24. IF in combination with larger than
  25. list of sheets
  26. How do I do a vlookup that links to file paths within a cell ref
  27. how to expand the autofilter range 1000 to 10000?
  28. Need help with dividing and using ISERROR for Div/0!
  29. Sumif with two conditions?
  30. Repeat last action
  31. Using the lookup Function for similar items to add together
  32. Need to find a formula
  33. Conditional Average Array with Dates, <blanks>, 0
  34. How do I embed a two page word document in excel
  35. Using IF in an array
  36. Conditional Average across worksheets
  37. "IF" function with multiple truths
  38. PMT question
  39. matching values that are not in order with conditional formatting
  40. how to start using vlookup, match & index formulas, examples
  41. Hyperlinking problems
  42. Set solver constraints so variables are either 1 OR 0.
  43. Auto Numbering System
  44. How do you create a list & data validation in same cell?
  45. WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
  46. I can't change colors in certain Excel cells
  47. Why are formulas not updating when changing a value in the range?
  48. How do I keep the font color with VLOOKUP?
  49. get a single count after looking up a set of values
  50. Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA?
  51. How can I find comon values in seperate spreadsheets?
  52. Complex Nesting
  53. How do I make excel not prompt before deleting worksheets?
  54. How to track inventory?
  55. Please tell me this is possible
  56. Delete Macro
  57. How can I find duplicates in one column of an exel spreadsheet?
  58. formula help
  59. How can I covert dates to ccyymmdd?
  60. Average Time Difference
  61. Formula non specific lookup
  62. How do I write a comlicated conditional statement?
  63. Average calcs - ignore sheets
  64. How do I set up a transport cost with mulit origins, destin,svcs
  65. How do I get ONLY new info from 1 Worksheet to another automatical
  66. separating text
  67. How do you copy a border down the page?
  68. how can I compare two excel spreadsheets?
  69. add leading zeros
  70. Converting US Dates to UK Formats
  71. How do I retrieve & view multiple matches from another workbook?
  72. Formula/Macro to delete rows that do not meet criteria from a list?
  73. no password for protected sheet
  74. Horizontal arrow on cell edge and double-click, no matches found.
  75. date problem in excel
  76. How do I highlight a column depending on other column value?
  77. Count, Countif, Sumif??
  78. If statement
  79. How to format cells to show dates as the week-ending date of that
  80. Import External Data -- Fill down formulas Issue
  81. Extracting Data for a Formula from a List
  82. Time * Rate = Amount Billed Formula?
  83. Simplification help
  84. Time * Rate = Amount Billed Formula?
  85. Simplification help
  86. Excel
  87. Sorting Data From One Column into Multiple Columns
  88. auto updating list
  89. Tabs v.Pages
  90. calculating a date using the day of the week as a starting point?
  91. Converting data in one cell to 3 different cells
  92. Date Last Modified
  93. Forcing DIV/0 to display "0"
  94. Cell structure not copying to 3rd party app
  95. how to hide a list of macros without password protection
  96. How do I setup multiple lists
  97. Reverse worksheet data by columns
  98. Add worksheet Lookup based on date
  99. set filename to <filename-date> on open
  100. average formula ingoring empty cells
  101. How to create a fill down that increments based on the workbook name
  102. If statement to compare for wildcard value in another cell.
  103. noamal curve and cumulative distribution graph
  104. Incremental Numbering
  105. Simple Question but need urgent help pls...
  106. Formula to search for given term, and if not found in column to add it to list
  107. get a count from multiple lookups
  108. Please help me... with Case Structure
  109. Formula problem with different sheets
  110. How do I extract a single value from the linest array result?
  111. I want to turn off Text Import Wizard
  112. COUNTIF - Multiple Criteria
  113. remove a drop-down list in excel
  114. How to "auto fit"
  115. Need to create a error message box
  116. http://www.ebvalues.com
  117. Referencing a column across worksheets
  118. Can I add a drop-down list to a Vlookup?
  119. Can I add a drop-down list to a Vlookup?
  120. Copy, return and paste.
  121. Solver Question
  122. how do I skip blank cells when writing formulas
  123. how i recover my excel file
  124. combining fields on a pivot table
  125. Retrieve Data from one sheet to another
  126. hidden columns
  127. How do I find best fit out of a set of options by ranking criteri
  128. Is it possible to format a cell w/ 2 font sizes by formula?
  129. Hidden worksheet
  130. Why can't I see the Protection tab on cell format dialogue box?
  131. SUMIF across multiple worksheets workaround help
  132. Using linest for flow rate calculation
  133. Return info based on Date Range
  134. how do you do an average for percent without putting in the perce.
  135. Custom Filter
  136. Transpose row to read to column
  137. Value within a range
  138. feasibility study
  139. referencing todays date.
  140. Logic Test ?
  141. sound or speech the value of the cell if value > 10
  142. Excel question
  143. While using networkdays function, how can define weekly off days
  144. value from cell x according to cell Y
  145. Formula Query - Using Time & Text
  146. Why is a row's total rounding up?
  147. hyperlinks
  148. Excel Sheets
  149. How do I shade the active cell in excel
  150. EXCEL SPREADSHEET FORMAULS
  151. cond formatting ?
  152. Re: Last Day Of Month Calculation...
  153. Copy cells to neighbor column after leaving the cell
  154. Adding up multiple cells
  155. how can I insert rows in part of worksheet
  156. Linking a Specific Word to a Specific Number
  157. Linking a Specific Word to a Specific Number
  158. oldest incomplete job
  159. Linking a Specific Word to a Specific Number
  160. I wish to separate city, state, and zip into 3 separate columns
  161. How do I sort Library of Congress call numbers in Excel?
  162. How to autofill a column if criteria is met for Excel 2003
  163. Converting Dates
  164. Add reference to DDE Link formula
  165. How do I resort names
  166. Countif with a changing range
  167. Compare times : IF time < time2 then
  168. not sure which function to use for this summary
  169. Look up date on another sheet and do count of active cells (column
  170. Can anyone figure a formula for this?? Please?
  171. funtions for colors for fonts or cell backgrounds?
  172. 2007 insert button/icon
  173. Different Number of Workbooks each week
  174. Different Number of Workbooks each week
  175. Concatenate Nightmare!
  176. Concatenate Nightmare!
  177. select date range in column
  178. select date range in column
  179. count number occurring within specific date range
  180. count number occurring within specific date range
  181. Complex Formula
  182. Complex Formula
  183. Distinct
  184. Distinct
  185. LARGE with text string
  186. Question on some homework I have to do
  187. Setting Dates
  188. Nested IF
  189. Tracking Time
  190. Counting cells with text
  191. Leauge Table....Help!!!
  192. VLOOKUP question
  193. Plus or Minus
  194. How to count the number of 'values' in a cell
  195. change position of filter button
  196. Workday Function in Excel 2007
  197. More sort options - do they exist?
  198. lookup and add a value
  199. couldn't find "solver" in Excel 2007
  200. simple formula
  201. row= cell's row
  202. Need help with linking a file to a picture.
  203. Floating Cells
  204. How do I reformat my database from all uppercase to proper?
  205. sending macros
  206. "Excel Could Not Save All the Data and Formatting"
  207. Excel Formula Help!
  208. format to a desired style and order
  209. Values in spreadsheets do not update
  210. This is more complicated than it looks.
  211. SUMPRODUCT with AND's and OR's?
  212. How do I set up a needs assessment result template in Excel?
  213. Can I sort worksheets based on the tab name?
  214. compare 2 books in excel??
  215. Need Help w/ Index and Match Formula
  216. Formula in Excel to show greater than 50, but less than 250?
  217. Advanced use of LARGE function
  218. Can you do inverse trigenometry on excel - i.e Tan-1
  219. Excel is totaling wrong
  220. Graphing a dynamic range that automatically picks up the most recent entry.
  221. Always on top? Alway the same size?
  222. How to: COUNTIF when ISTEXT is True?
  223. How do I create a list inside a single cell?
  224. SUMPRODUCTS
  225. how do i change formulas in a wookbook to the results
  226. Summation Operator
  227. What does -- do?
  228. VLookup Formula
  229. formula question
  230. How do I Minus 10% discount On my Excel Invoices On the Sub Total
  231. users on shared worksheet
  232. Sum Column Entries that fall within Date Range Listed In Rows
  233. COUNTBLANK function
  234. Count number of textual values in a row
  235. Excel FUNCTIONS stop working
  236. Row() function returns wrong row and more..
  237. requiring a field
  238. Sorting SumIF
  239. Separate a String of #'s
  240. How to calculate return from uneven cash inputs over time?
  241. formula to extract text out of a paragraph
  242. How do I reinstall the autosum button? I cannot find it on Excel
  243. multiple selections from drop down list
  244. change text case
  245. Countif function
  246. SUMPRODUCT and OR operator
  247. Excel limit that stops pivot table processing at column IV??
  248. adding conditional rows
  249. why does Excel add more rows than I have selected
  250. Help with a SUM function...