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. Obtain Easter date?
  2. Pulling my hair out here
  3. Calculation of Gross Margin in a pivot table
  4. Summing cells in array
  5. Counting unique text entries in a filtered list...
  6. fractions and decimals!
  7. How do I hide a formula so it will not show on the spreadsheet?
  8. I need help with Excel
  9. Look UP Formula
  10. Indexing of Name
  11. How to Convert Figures into Text in Excel
  12. UK Excel User Conference - July 19-21, 2006
  13. priority name
  14. priority name
  15. Using Countif when column A=Num and Column B=Yes
  16. Help Please! - Creating Function Calculated Fields within Pivot Tables
  17. Excel Cell References are different to normal
  18. how do I add a drop-down calendar in excel?
  19. Adding up data in multiple cells for a single criteria.
  20. how to use list in excel 2002
  21. min value
  22. Bug Report for Excel
  23. I want to be able to create a dynamic reference in excel, for exam
  24. Vlook up and if statements (I think)
  25. Formula needed for 2 criteria
  26. I'm having a really strange problem with 3 if statements.
  27. How to split worksheet to make smaller
  28. Ranking on basis of 3 Parameters
  29. Ranking on basis of 3 Parameters
  30. Navigation
  31. making gains or losses appear red or black in formula
  32. look up formulas
  33. use Now() in two cells for start and finish times
  34. can this function do this?
  35. Conditional Formatting
  36. return value other than #N/A
  37. hyperlink in combo box/data validation
  38. Excel Conditional sum, lookups and functions help PLEASE!!
  39. Separating text and data in a column
  40. Macros
  41. Macros
  42. adding to different totals dependant upon selection from drop down
  43. cell painting
  44. Excel Form and Data Retrieval
  45. Spreadsheet Function
  46. Invoice Comparison
  47. How to Share & "Un-Share" Worksheets
  48. elapsed time problems
  49. Can I freeze column A and scroll down the other columns in Excel?
  50. how do I update the scenario summary sheet?
  51. how to retrieve information that was saved on a floppy disk?
  52. how to do a dynamic ranges?
  53. edate function
  54. unable to grasp SUMPRODUCT
  55. stuck with macros
  56. Conditional Expression in cell
  57. How do I circle a number in excel
  58. ReCalc'ing for almost everything I do
  59. Select Distinct Maximums
  60. number lookup
  61. Cell reference between worksheets
  62. formula to add dates.
  63. How do I get the MAX value of adjoining columns then SUM range?
  64. I need a payroll sheet that can auto update figures each week
  65. Formatting
  66. What has happened to "Save As" in Excel 2003
  67. macro security too high in excel, I can not get into input data
  68. Formula to a number can you tell
  69. Rank a changing row
  70. annual percentage return
  71. how do i change an incorrect amount in a cloumn after download
  72. Cumulative Average
  73. Can I lock worksheet reference?
  74. find a value in a table, go to the previous column and add that co
  75. Can't see sheet, and have tried unhide, etc?
  76. Comments in Excel
  77. Stumped: If a cell contains a formula, can you make text color automatically change?
  78. sum column containing both text and numbers
  79. DIV/0!
  80. recognize formula
  81. How can I use one formula to change case on an entire worksheet?
  82. Conversion of Numercials to Figure
  83. Excel links
  84. How do I add a column of cells, but IF a row has (), subtract?
  85. Rounding up/down problems ?
  86. i maintain DB of URLs in Excel. how can i avoid duplicate entry?
  87. Track Changes
  88. Is there a way to write an equation that ignores cells that have .
  89. Does Excel contain a decision tree analysis?
  90. calendar help
  91. Help with formula
  92. Using Check boxes in Excel
  93. LOOK AT THE CONFERENCE- INTERESANT
  94. Number Transform to Date
  95. Forgot my pass word for excel sheet
  96. Prefixing a selection of cells with zeros
  97. Retriving Values from a separate sheet of a different file
  98. Highest value in column b returning column a
  99. Mortage Calculations
  100. paste special values
  101. protected document loses all protection(hidden columns) when manually copy-pasted
  102. What is quickest way to insert 4000 hyperlink documents?
  103. show customer based on Weekday
  104. Excel 2003's autosum does not update data in real time
  105. Can a cell be set to accept input only once?
  106. =bahttext(A1) please tell me about language in english how can i
  107. =bahttext(A1) please tell me about language in english how can i
  108. =bahttext(A1) please tell me about language in english how can i
  109. =bahttext(A1) please tell me about language in english how can i
  110. 'Copy to' Advance Filter depend only on sheet ID not start sheet
  111. excel formular update
  112. trying to lookup a value and return if true or fals
  113. keeping cells aligned when data is updated
  114. Sorting Colums
  115. remove partial data from cell
  116. How to format 39.5 to 39.5%
  117. sum if conditions in two columns are met?
  118. excel formular
  119. Date Value
  120. Not sure which function - Maybe IF
  121. Array, circular reference problem
  122. Don't think it's possible, but I thought I would ask.
  123. Dynamic Ranges and Lists
  124. point to a cell in another workbook
  125. How to populate prices in sheet two based on cost in sheet one
  126. Index-Match from a range
  127. Function for copying color formatting
  128. Using Lookup function
  129. copy formulas without associated values
  130. Help with vlookup
  131. Can you write a formul that will put multipal answers in multipal.
  132. Can you write a formul that will put multipal answers in multipal.
  133. Change the width of a column by using a cell reference
  134. =If - how to tell it to calc certain %'s only
  135. Drop-down Lists
  136. copy only unique values
  137. Sorry for the 3 threads! My bad...
  138. Help with formating cells (decimal places)
  139. Help with formating cells (decimal places)
  140. Help with formating cells (decimal places)
  141. Copy data from one worksheet to another using a function or a macr
  142. if statements
  143. prevent data entry into cell?
  144. Some help needed?
  145. how do I get access to the datedif function?
  146. How to count after 2 conditions are met
  147. Help with Excel formulas
  148. skip blanks
  149. Help for sumif / sumproduct
  150. Changing Color Palette
  151. Offset
  152. Conditional Formating
  153. Vary column to sum in SumIf
  154. Comparison result changes font color
  155. convert number to time
  156. running balance in Excel
  157. Suggestion
  158. Sorting names in Name box
  159. Importing .txt file
  160. How to prevent warning messages on protected work sheet.
  161. RE: Sorting names in Name box
  162. Match 3 Criteria and Return Lowest Numeric Value
  163. incremental counter
  164. Match 3 Criteria and Return Lowest Numeric Value
  165. incremental counter
  166. how do I put 'c' in () in excel & not get copyright symbol
  167. Date formula that adds 7 days to a cell when sheet is copied
  168. how do i have beginning balance take away an amount auto total
  169. Subtracting From 2 Cells
  170. Advance function of excel to get sorted data
  171. Exporting Excel spreadsheets with functions
  172. Formula help
  173. Newbie problem need formula help
  174. Create a Formula to display the sheet name.
  175. Date format problem
  176. Retrieving values from a specified sheet of a different file.
  177. Adding Tax in excel
  178. How do I select price from sheet.b where sheet.a part no = sheet.b
  179. Formulae containing more than 7 arguments?
  180. if statements
  181. How do I do a sumif function not including hidden rows?
  182. trivial problem
  183. Check my IF function
  184. Calculated Fields in Pivot Tables
  185. sumif based on partial match
  186. Function Help
  187. GETPIVOTDATA Bug
  188. NPV IRR MIRR
  189. how to convert julian date to general date
  190. Does anyone have a weekly schedule that computes total hours work
  191. Does anyone have a weekly schedule that computes total hours work
  192. Is there function to check and list data?
  193. How can I use dcount to total the number of columns with entries?
  194. summing problem!!!!!!
  195. Updates Problem
  196. No duplicate names in a range (A2:A200)
  197. LARGE and INDEX functions
  198. Updating LINKS when opening a workbook
  199. Input range and link a cell
  200. How many decimal places can a cell display?
  201. How do I set cell colors based on if query
  202. Array sum for negative match
  203. Fill cells with times
  204. Searching Columns and Rows
  205. change cell value greater than another cell value using formulas
  206. check marks in excel cells using your mouse
  207. Help Requested on Formula
  208. Calculate from time formatted cell
  209. Have column of nums, need qty of each?
  210. Return an Alpha based on number position in a word
  211. Status Changes
  212. Deducting a %
  213. how to substitute a value for calculation with a column of values
  214. number formats
  215. problem with blank cell
  216. Vlookup problem
  217. how do i add numbers in nonadjacent cells?
  218. Date entries
  219. How do I delete <br> or <b> that appears in text?
  220. condition formating
  221. How can I use the "TODAY ()" Function in an "IF/THEN" calculation
  222. Identify number of items with characterisitics from two columns
  223. Summarizing totals of all worksheets to one worksheet?
  224. Why would a pasted formula not calculate the new cell refs?
  225. rate of return
  226. If And Or
  227. Summing every nth row value based upon variable
  228. Working out wagees
  229. I am trying to "mirror" a row in excel, help??
  230. dates
  231. Referencing a range of columns and rows with the IF function
  232. VLOOKUP
  233. add 1
  234. Validation Q
  235. IF and MAX statements
  236. How to enter pre-decimal pounds shillings pence in Excel workshee
  237. Is it possible to convert a number into hours and minutes
  238. Sumif function
  239. Check if Equally Divisible
  240. formula to workout equal to or greater than
  241. retrieving values from a specified sheet
  242. How do I "Sum sales figure for a finacial month to currenct week"?
  243. Formula that will test text conditions in a single cell
  244. sorting data by a certain attribute
  245. Sponsor Tree
  246. How do change entire worksheet to uppercase letters and lock it
  247. Countif, Maxa or other function?
  248. HELP with dreaded formulas...
  249. eMoovie - a new company - we need sponsors
  250. Function Encyclopedia??