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. Im sure this question is elementary...
  2. Number of Weekdays
  3. How do I parse columns?
  4. crazy triple array formula
  5. Can I password protect worksheets?
  6. Excel Chessboard problem, boarders and cell shading
  7. lookup?
  8. How do I hide rows in a pivot table with zero values?
  9. VLOOKUP and LEFT to match text?
  10. How to set up a formula with two false values?
  11. IF function for cell color
  12. only calculate if >100
  13. can an array formula do this?
  14. I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns.
  15. Email and Excel Problem
  16. Exel
  17. Last Modification Date
  18. How do I sort rows w/o losing a picture
  19. No headers & footers in the worksheets
  20. if function checking for numerical data vs alpha characters
  21. drop down list value changes
  22. How do I use indirect when referring to a named range in a closed
  23. Copy down
  24. macros and protection
  25. Sum total from other worksheets
  26. countif using a range
  27. Shade a cell on one wrksht if another wrksht cell is occupied
  28. how do I calculate the time service minus holidays?
  29. HOW DO I ALPHABETIZ A SELECTED COLUMN
  30. Summing where values
  31. VLOOKUP and LEN/ISNA to match names?
  32. VLookUp problem
  33. how to erase all spaces in text cell?
  34. how to use the active cell in an Excel formula
  35. =?Utf-8?Q?Power_users_need_your_help_=E2=80=93_cal?==?Utf-8?Q?culation_based_on_a_date?=
  36. How do I hide spreadsheet range from data entry?
  37. named range into formula?
  38. HELP: MsgBox takes 99% CPU usage... why?
  39. Combo Box properties problem
  40. Create an increase or decrease formula with zero %
  41. VLOOKUP
  42. Forgot password on protected Excel spreadsheet . . change?
  43. Why is that happen ?
  44. inserting zero
  45. Any function to ...
  46. Vlookup
  47. Exist a function to...
  48. HELP! countif
  49. transferring formats
  50. what function to be used
  51. formula help
  52. referencing non-blank cells
  53. can a function do this?
  54. Golf Formula
  55. changing from relative to absolute cell reference in multiple form
  56. edit excel pdf hyperlink using find replace
  57. Pivot table and counting totals
  58. drop down formulas
  59. Need formula help!!!
  60. Goal Seek on PMT function give different answer than a mortgage ca
  61. find the largest value in column, put in a cell
  62. Linked cells refer to source one row off.
  63. what is formula for cubed root
  64. Cut and paste
  65. Dynamic finding and replacing via functions
  66. Macro - select and paste
  67. Macro - select and paste
  68. month plus one - excel 2003
  69. Split One Work book into several based on content
  70. find minimum of range based on multiple criteria
  71. Where can I find a simple paying in and out with Totals sheet
  72. Sum function
  73. import a variable number from a web page
  74. using text wrap how can I type over the page break point
  75. COUNTBLANK function
  76. summary data sheet from worksheet to worksheet
  77. Linking and Query, Please help
  78. edit bar is missing, where is it
  79. How to do a basic formula for Xcel?
  80. Conditioning Formatting - Thicker Borders
  81. Multiple criteria help...
  82. How do I bring back my worksheet tabs in Excel. Options doesn't
  83. Where can I find a journal for accounting purposes?
  84. Conditionally formatting rows
  85. sumproduct & average
  86. Generating Simple Reports From A Master Spreadsheet
  87. hiding columns or rows not using the hide function
  88. OpenOffice Download
  89. Single statement database/range processing with criteria
  90. seperat.buys from sells.on spreadsheet
  91. Editing an Excel Spreadsheet
  92. NOW function question
  93. ENTER DATA INTO 2 CELLS AT THE SAME TIME
  94. formula to lookup & sum totals, given a start inv.# & finish inv.#
  95. countif function doesnt work
  96. changing numbers into a barcode using excel
  97. sum problem
  98. Nested IF in this situation
  99. How do I hide the Worksheet menu bar
  100. VB Script
  101. weekly sales
  102. How do add time/hours to get answer in hours if Ans>24
  103. Print each record per page
  104. INDEX MATCH formula
  105. Conditional formatting works, is there a better way?
  106. Change a cell color based on a certain value (green or red)
  107. Bubble Charts with two non-numerical variables
  108. conditional moves
  109. cell data not validated if navigating cell to cell with mouse
  110. What function will find a value in a table with X & Y Values
  111. Purchase order...
  112. Index/Match not working
  113. How to create a ranked list
  114. need to work out bonuses
  115. Conditional formatting and formula
  116. conditional formatting for currency
  117. Selecting Cells
  118. IS there a mathematical formula for NORMSINV?
  119. Selecting alternate cells
  120. Too many variables?
  121. Copy data in one cell to blank cell immediately below, repeat
  122. Is there a formula that will add only highlighted rows?
  123. limiting rows of text in a textbox object?
  124. Formula behaves differently
  125. Reference Worksheet Name
  126. Pull data from multiple sheet
  127. Validation Issues
  128. Adding a space in text
  129. Displaying data from seperate sheet upon drop down box entry
  130. Automatically Re-Size Row Height
  131. Excel using dollars instead of sterling
  132. Need a Formula
  133. create template with certain fields to input information only
  134. Reference Worksheet Name
  135. Using Vlookuop and then calculating
  136. VLOOKUP error
  137. have different row lables calculate formula
  138. In Excel , How do I turn off the math funtions?
  139. how do I add new data and have it added to existing data
  140. Deleting rows from a worksheet automatically
  141. In excel counting cells in a range which meet condition ">Xand<X"
  142. Excel Formulas getting information from 1 workbook to another
  143. Excel Calculation of After tax Cost of debt Plz Help
  144. function to convert number to words [ 21 = "twenty one " ]
  145. Lookup
  146. Sheet Protection
  147. COUNTBLANK function
  148. Counting occurance of text values across multiple worksheets
  149. Single Excel function to sort a list and eliminate dupes
  150. How to link data from one drop-down list to another
  151. AutoFitMergedCellRowHeight - Jim Rech
  152. How do I combines data from multi-worksheets into one in ascendin
  153. Leap year indicator
  154. Relative Value to a Vertical Lookup Result?
  155. too many different formats on excel 2000
  156. Function: cell contents formula or value?
  157. How can I prevent someone from deleting a shared workbook?
  158. using formula with several possible answers
  159. CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY
  160. xirr value error
  161. zip code to city, state function
  162. Vlookup
  163. The word "calculate" is at the bottom of my spread sheet. why?
  164. cell ref in function formula change when inserting additional colu
  165. Can you convert a excell sheet to a word document
  166. How do I create an "outline summary" - please see message for deta
  167. How do I create an "outline summary" - please see message for deta
  168. The formula for NORMSDIST is wrong?
  169. Need help...
  170. Problem with data from cells in merge fields
  171. Excel Web Queiries should work with protected web sites.
  172. How to include data on the same sheet some in database some not
  173. Function-Date Problems
  174. how do i sort a complete worksheet by sorting columns
  175. summary report with duplicates
  176. Simultaneous entry of data between 2 different worksheets
  177. How do I get the true path to server (not mapped drive letter)?
  178. convert cubic centimeters to fluid ounces and cubic centimeters
  179. Macro wiping out worksheet
  180. locking column widths within a pivot table
  181. Replicating Text Using "=".
  182. Please Help me with VLOOKUP function
  183. Sorting By Row
  184. Hidden Sheets
  185. Sum and rounding functions
  186. count of tab characters in a single cell
  187. List all filenames & tab names
  188. Incorporating Cell color fill in an "if" logical function?
  189. Single formula to 'sort' a list onto a second sheet?
  190. adding more than one value to cells
  191. new staff
  192. help using lookup and some kind of ranking criteria
  193. if then function
  194. Excel Woes - Formula bug (I guess)
  195. US states
  196. Max of a defined function
  197. divide by zero
  198. Sumproduct with #N/A in range
  199. excel "Networkday" function
  200. Sumproduct-multiple criteria for same range "OR"
  201. Lookup Formula???
  202. I want to get a value from an array, row 1 and column 1 known.
  203. Can you perform Math functions with ActiveX Checkbox controls?
  204. How do I convert cubic centimeters to ounces in Excel?
  205. Vacation Accrual formula
  206. PivotTable
  207. Function to Convert dollar to text?
  208. IF statement colored results
  209. Break links automatically changes graph's date format
  210. transpose links from a column to a row
  211. transpose links from a column to a row
  212. how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE
  213. Workbook_open : Putting in message in titlebar (Visual Basic)
  214. Creating a form
  215. how to insert day of the week
  216. Newbie post - help with Subtotal please!
  217. workbook name
  218. Expand/Collapse Rows
  219. Using COUNTIF and AND functions together
  220. copying macros
  221. merging two worksheet
  222. NETWORKINGDAYS
  223. How do I highlight cells on a worksheet that contain formulas
  224. Disable Page setup
  225. Absolute function
  226. Quickest alternative for shortcut of PasteSpecial then Values
  227. Sort function on Pivot Table
  228. How do I use VLookup Function effectively?
  229. IF Statment across Multiple Sheets
  230. more than one lookup value
  231. how can i make macros to work when in tools, costumize and option.
  232. Combine 2 cells without using the CONCATENATE function
  233. compling info from multiple pages onto one page?
  234. how do I make an excel comment box bigger?
  235. SUMPRODUCT FORMULA
  236. Drop Down List
  237. ABS of cell on another page??
  238. Date/Time Calculations
  239. Formula!!!!
  240. incerting calender in a spread sheet cell
  241. Sort & Show Data
  242. Cell Additions
  243. counting cells in two columns that have the same results
  244. Alternatives to GET.CELL and VB?
  245. If I have my sheets protected will that prevent me running a macro to hide certain sells?
  246. Vlookup between two workbooks
  247. V-Lookup, column index number indicator in table array
  248. Re: Add to Summed Figures
  249. Add to Summed Figures
  250. WHY DO FORMULAS STOP WORKING IN EXCEL