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. Cash Book
  2. closest match
  3. VLookup function to right!
  4. sequential invoice numbering
  5. Count number of pages
  6. How to change a link to another worksheet by changing a value in a cell?
  7. paste to next blank cell/row
  8. Cpk value calculation in excel
  9. Compare product prices from two supliers and produce report
  10. Macro Help
  11. if and function
  12. Can formats follow formulas?
  13. How do I lookup multilple criteria and return a single value
  14. how do I sum all of the $ payments made between two dates
  15. Running total array?
  16. What's wrong with this formula?
  17. when i enter time in cell it changed, why?
  18. How to validate
  19. formula references change when data entry sheet is modified
  20. Find most recent date
  21. Email addresses in Excel need to format for mass email
  22. Function for days between dates and an if statement (HELP)
  23. VLookup Multiple Data Rows
  24. Rank(A1,C1:C5) - Rank using 2 ranges
  25. Can't see all the text in a cell when using file links
  26. % or Nr
  27. count # of instances in cell (a b a) answer 2 formula if possible
  28. changing money
  29. Column Headings in Lists
  30. SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
  31. How do I keep column headings from showing on a list?
  32. Format number using CONCATONATE
  33. Automatic Population?
  34. Page TOtal
  35. Hyperlink trouble
  36. How to import data based on a variable
  37. Count Number of Different Cells
  38. Page TOtal
  39. why cond sum wizard returns diff result as when formula typed out
  40. Function Question
  41. IF,And,OR Help
  42. Macro for copying conditional data
  43. f statistic, p value definition
  44. Automatic Product Functions
  45. Formula Needed to Compare Dates and return a running total
  46. how do i sum A1*B1 through to A12*B12 in one easy forumla?
  47. I'm trying to link two excel spreadsheets so they update automati
  48. Database Functions - Strange results
  49. How can i convert an ASCII character to decimal/hex in Excel?
  50. calculate the sum of hours exceeding 23:56
  51. World cup spreadsheet help
  52. reference in another workbook related to the name of material
  53. Transpose Question
  54. Formula too long - text
  55. Trouble writing an excel formula.
  56. Protecting columns?
  57. How do I retrieve the text string from the right of a cell
  58. PivotTable:Using a calculated field result in another calculated f
  59. Validation Links
  60. AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS
  61. if and then formula
  62. Paste Special - Values
  63. End (bottom) of worksheet
  64. average function
  65. insert picture from file based on cel value/content
  66. Comments Printing Problem
  67. what is the "random" function in Excel in spanish?
  68. Returning column header as result
  69. Two links changed on my site
  70. Lookup function for a value that has multiple instances
  71. Using DCOUNTA to count only Unique values
  72. Retrieve specific date from one row of one column that is changing
  73. How to sum cells but not show zero if cells are blank?
  74. Extracting the most frequently occuring text from a range
  75. 2 levels of worksheet protection?
  76. How do I alpha short worksheets in a workbook:
  77. Extracting the most frequently occuring text from a range
  78. 2 levels of worksheet protection?
  79. How do I alpha short worksheets in a workbook:
  80. Macro Question
  81. 3-D reference
  82. Help in data comparison
  83. How can I lable a colomn group in Excel?
  84. Data Importing?
  85. macro to copy multiple rows to separate worksheets
  86. how i change thai text to english text
  87. dumb question
  88. Save sheets in a folder
  89. Converting letters to numbers
  90. Add a new row under a changing list
  91. Baseball sumproduct/array formula?
  92. How can I check the "P" or "A" in the attendance sheet
  93. Percentage
  94. Percentages between two cells
  95. Inserting automatic text in Excel
  96. Manipulating Data Problem
  97. Drag a Named Formula
  98. How to mark down the time when entering input to a cell?
  99. Comparing columns from 2 different worksheets.
  100. Averaging a column with 0's
  101. How to define the 1st, 2nd and 3rd element
  102. Formula-Cell has a letter (C=100, M=1,000) and needs to divide?
  103. Conditional Formula help required
  104. mileage
  105. Formula not recalculating
  106. lookup and move rows to other workbook
  107. visual basic (copy and paste)
  108. Auto Filter by Criteria
  109. Modify database
  110. Matching Adjacent Columns?
  111. Excel 2000 filter problems
  112. A function to indicate whether a cell contains formula or value?
  113. Converting a formula to its value
  114. Insert currency numbers from spreadsheet such as 48 = $48.00
  115. Text Compare Function
  116. Running macros on ALL Excel tabs
  117. Moving automatically from one cell to another
  118. I want to add a plus sign behind a number and keep the leading zer
  119. Sumprpoduct Help
  120. limit text length after importing data
  121. How do I change the default spreadsheet size in Excel?
  122. Determine if a value in a range is close to the value of another c
  123. RE: Determine if a value in a range is close to the value of another c
  124. NOW Function For Time Changes With Each New Macro
  125. Pivot Table - Deleting data rows while maintaining them in the tot
  126. PULL Function
  127. One column with various widths
  128. Conditional FIND and REPLACE
  129. retreiving cell address of vlookup value
  130. Macro Question
  131. Replacing a number value with text from array
  132. Can't add 7th IF statement to long formula.
  133. reset certain cells to a default value
  134. How to get the right-most word from TEXT
  135. Help with INDIRECT
  136. create & name multiple worksheets
  137. xirr - hi! i need some urgent help
  138. what formula in Excel will identify the first zero in a row and...
  139. Dissecting the contents of a cell
  140. Maintain Formula Reference (sort of)
  141. Req for help using INDIRECT or alt solution
  142. Number format in cells
  143. Time sheet calculations
  144. Pivot Table Question
  145. Concatenate in a string
  146. Counting data between 2 values
  147. Convert Text to Columns with Excel 2007 beta does not work well
  148. Conditional Format Issue
  149. Drawing on a chart
  150. Great time in France
  151. How to create a calendar view from data in Excel?
  152. Help Need Formula for Calculator
  153. 3 data validations
  154. How do I copy columns between worksheets if the columns don't matc
  155. Conditional Formatting to Compare to Lists
  156. I have 2 lists of email addresses and I want them to match up
  157. Averaging Only the X Highest Numbers in a Row
  158. If AND Statement
  159. Searching for string in other cells
  160. Excel formula - help needed!
  161. How do I get an IS and IF statement to work together in excel?
  162. working with time in minus
  163. deleting sheets in Excel 2007 ( Beta 2 )
  164. deleting sheets in Excel 2007 ( Beta 2 )
  165. Selecting particular rows containing interesting data
  166. Deleting blank rows
  167. How to specify cell ranges dynamically?
  168. Vlookup
  169. Sunday Function
  170. help with coding in excel
  171. input box within macro
  172. reverse cut and paste
  173. how to add values of cells only if a corresponding cell has information on it
  174. hyperlink in menubar
  175. a function that counts the number of cells with information
  176. Linking cells by name only to another worksheet....
  177. HOW DO YOU SPECIFY A RANGE TO SORT?
  178. copy rows to another worksheet
  179. Modify Excel Formula
  180. greyed out compare and merge document
  181. vlookup problem
  182. Why does a column add incorrectly when usng autosum?
  183. How can I link a cell in Excell and keep the same formatting?
  184. HOW CAN I FIXED FORMULA THAT DISPLAYS #NA
  185. How do I set up a formula to add column a if column b = cell c1?
  186. GETPIVOTDATA
  187. Hyperlink in an IF statement
  188. Hyperlink in an IF statement.
  189. EXCEL WILL NOT LET ME INSERT COLUMNS
  190. Auto-Fill From Table
  191. Template update database, auto move down 1 row
  192. sum of multiple IF statements
  193. v-lookup problems
  194. Conditional Formatting if cell content is a formula
  195. count
  196. Moving Information
  197. countif problem
  198. Vlookup doesn't work in new workbook
  199. Need to get a count on an hourly basis
  200. Formulas go away
  201. Evaluting 2 cells, adding one to largest for another cell.
  202. isna & if functions
  203. blanks in data validation list dropdown
  204. How to create hyperlink from 2 cells, then open Word
  205. How do I merge data in the same workbook?
  206. formula
  207. Count if Lower case
  208. Calc cost pro rata (nested IF's and macro to find empty row)
  209. Sumproduct
  210. return one value from list
  211. Comments don't stay the size I choose.
  212. sumif 2 text conditions
  213. I want to jump to a worksheet from a contents sheet
  214. Sorting Outlines
  215. Credit Card Number
  216. Credit Card Number
  217. IF & AND statements
  218. linking one column or varying range to another column using same f
  219. retrieve last entry in column
  220. Removing "Spaces" Entire Workbook
  221. Totaling from seperate worksheets
  222. Copy formula with skipping rows
  223. functions on imported database
  224. protect sheets against cutting / pasting
  225. Finding/counting a given character within a cell
  226. add a rule line to excel
  227. Finding/counting a given character within a cell
  228. add a rule line to excel
  229. Finding/counting a given character within a cell
  230. add a rule line to excel
  231. Data validation with hyperlinks
  232. Pick a Random name from a list.
  233. How to click on a cell and have the content of the cell display in a different cell
  234. if this equals that
  235. Offset, VHookup - Confused
  236. Adjusting Formula
  237. Matrix Question
  238. Count Formula
  239. Excel pivot table
  240. Worksheet names 2
  241. Excel hyperlinks open Netscape not IE
  242. Nesting IF function
  243. how do i get the mid function to work with a zero
  244. function help
  245. worksheet names
  246. vlookup across more than one sheet
  247. Problem with nested if function. PLS HELP
  248. Linked Cells Staying With Cells Once Linked Workbook Update.
  249. How to use IPMT and PPMT to compute Interest and Investment paymen
  250. How do I grab the date from a text string?