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. Use MOD?
  2. Copy Row based on a condition
  3. Sum and Divide Formula error
  4. countif non blank cells + dates overdue
  5. comments issue
  6. Where's the plain old database functionality?
  7. Column picked randomly with probability relative to number of entr
  8. saved worksheet opens in new with macro error report
  9. VBA
  10. minus sign
  11. Concatenate two columns?
  12. Update Spreadsheets
  13. Custom functions calculating time arguments Help Desperate
  14. i have two days and i want the difference in days, months, year
  15. Need help setting up a spreadsheet of some sorts.
  16. Function Needed! Please Help!
  17. simplify equation
  18. how to make formula
  19. Sumif Command
  20. How to set the row for title to be fixed during scrolling?
  21. adding days correctly
  22. Using a formula on cells containing results of formula – How?
  23. How do I use conditional formatting to hilite weekend dates where.
  24. import txt create sheet name
  25. COUNTA for a cell with a formula
  26. Updating links from one worksheet to another worksheet
  27. Conditionals
  28. Copying Data to next available empty cell in cloum
  29. Count data based on past dates
  30. How do I compare two values to calculate a total?
  31. Counting values lower then the median.
  32. Lookup from one spreadsheet that links to matching keys in another
  33. auto correct numbers with dates
  34. text fields in pivot tables
  35. Contional Formatting - other cells
  36. Data Validation and named lists
  37. format cells for color
  38. CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES
  39. Can you ID a cell that has both Alpha AND Numeric characters?
  40. =?Utf-8?Q?=E2=80=9CCount=E2=80=9D_occurrences_of_two_condi?==?Utf-8?Q?tions_on_the_same_row?=
  41. Excel should have unhide all worksheets selection or button.
  42. create links to check boxes marked "good" fair"and "bad"
  43. How do I calculate the midpoint date between two dates.
  44. Link worksheets
  45. How can I create a link between cells in two separate Excel sheet
  46. Fix Simple #Div/0! error
  47. Hi people views once what I received:
  48. Hi people views once what I received:
  49. in excel, can i set varying CELL widths that are in same column?
  50. vlookup range changes
  51. transposing question...
  52. SUMPRODUCT
  53. Return a formula as text string to a cell
  54. how do I paste without EXCEL increasing the cell number ?
  55. Excel file window won't open
  56. Excel should have row column highlight indicator
  57. how to catch the second or more cell with vlookup
  58. how can i change my sprdsht to list info from colums into rows
  59. Carrying a balance forward
  60. How do I delete extra blank pages from an excel worksheet?
  61. Lookup in data from external datasource
  62. In Excel is there a function to change a cell's background color?
  63. Vlookup referencing one column that contains part numbers in both.
  64. Please help w/ nested IF that returns a #N/A.
  65. how do I fix my 'if' statement?
  66. Count Records Between A-K and L-Z
  67. Excel Help Needed......
  68. Advanced Filter w/ multiple sheet List Range
  69. automatically updating summary worksheet
  70. Bug in days360 function
  71. How paste text from note pad to excel w/o using (Text to column) f
  72. lists
  73. Sum Count of Numeric Criterion for LAST 5 Rows
  74. Calculating p-value from Fisher's Exact Test for XYZ parameters
  75. Conditional Concatenate
  76. How do you dedupe a list in excel with parameter?
  77. how do i use excel's natural log function with negative numbers?
  78. external data function error-MS Query
  79. Subsequence of characters
  80. Excel User Conference - Registration winners
  81. what is the problem, when value comes up in the total column
  82. how do i create a customised numbered list in excel
  83. Correct answers like a quiz
  84. LOOKUP function not returning expected value - Using vector_lookup format
  85. Looking-up Columns w/calc'd Values ONLY to Calculate Average
  86. Is there a fluctuating payment loan amortization template in XL?
  87. Mob-ocracy and the Fall of the Republic
  88. functions/formulas
  89. Formula to figure bonus
  90. look up a value
  91. create pivot table with master/detail data from 2 worksheets
  92. calculate the p-value for a negative t-value
  93. how do you setup a table
  94. Finding the date on the 'nth' Monday in this Month in this Year
  95. Counting dates, within a list of dates
  96. How can I add additional rows beyond the 65,536 in excel 2003
  97. Option Button - multiple selected
  98. Summing one column if two other columns' values appear in other sh
  99. Which formula?
  100. returning a cell name
  101. Rolling Forecast
  102. IF condition
  103. Finding/removing duplicate names in a worksheet
  104. Dragging Conditional Formatting
  105. centre across selection shortcut
  106. Sum & VLookup
  107. Returning value based on input data
  108. Returning value based on input data
  109. converting a string of information into excel cells
  110. How to pull cells from other worksheets including color/comments?
  111. vlookup is returning a value one cell above the correct cell.
  112. Calculate 2 Standard Deviations
  113. VLookup Error in Part of a Named Range
  114. AND in an array function?
  115. How to create a New system function
  116. one criteria/mult. values
  117. formula for matching text
  118. Display missing Part Number if Column A does not match column B
  119. list box
  120. How to best monitor threads on this site
  121. Returning a sum when looking up two different values
  122. IF Cell Contents Start with STRING
  123. Text to columns
  124. drop down lists
  125. Sorting two columns (again)
  126. Text manipulation
  127. data from 1 sheet to the next
  128. excel conditional formating decimal fractions
  129. Index and match among sheets
  130. How can I add 3 years to date 03/05/2003
  131. Pull information based on a range of numbers
  132. Changing date from =NOW() to Creation Date
  133. Establish formula for multiple logical_tests
  134. Help needed with conditional formatting and adjacent text
  135. function to populate different cell
  136. IF Command
  137. Drop down categories in Excel
  138. Switching Subcategories into Categories and Vice Versa
  139. T-Account templates can be found where?
  140. days between 2 dates
  141. Measure length of an AutoShape Line?
  142. Total width of several columns.
  143. Search a random array of cells and return a value of "X"
  144. Lookups
  145. loan payment
  146. Tables, How do I make new info push existing info to the next row?
  147. Unable to paste a formula into other cells
  148. Unable to paste a formula into other cells
  149. Fill with zero
  150. Recording a high price on a worksheet
  151. for sale: internetDotComs.com
  152. Parse data where break is a first uppercase character in a string?
  153. Nested Ifs
  154. anti logarithm function for base 10
  155. How to equalise loans by ditributing funds
  156. Countif using the same cell on every sheet
  157. Protected worksheet with unprotected cells i.c.w. remarks
  158. Can I use IF function in calculated fields in a pivot table?
  159. Need a loud/bright warning before making changes.
  160. Adding or combining time problem.
  161. How to obtain both std dev and std error mean in each y error bar
  162. exponentials
  163. using worksheet name
  164. How do I type this so excel recognizes it?
  165. testing. do not open.
  166. Auto sum
  167. Change source ofr edit link is greyed out
  168. =?Utf-8?Q?a_h.s.l.@_=C2=A33.80_mtr_&_10sq_m_are?==?Utf-8?Q?_fitted_whats_the_formula_help?=
  169. template timer stopwatch
  170. Deleting formula in data validation list
  171. test a range of cells and return an adjacent value
  172. end result
  173. How do I get the largest number in a sheet to stand out on it own
  174. Help! With SUMPRODUCT
  175. Mortgage calculation after a large extra payment
  176. running total from the same field on multiple sheets as i add she
  177. how do I use the solver to solve polynomial equations?
  178. hyperlink using cell contents
  179. ranking with some blank spaces
  180. Filter arrows freezing!
  181. Adding percentage as interest to a total
  182. How to define table size
  183. accumulating values generated daily
  184. Hide used names in drop downbox.
  185. lloking for an easier way to count
  186. assigning points to rankings
  187. How can I alter the rounding rules?
  188. Excel formula
  189. Prevent user changing pivot chart layout
  190. Values not updating
  191. Find max number of character and return cell address
  192. Conditional formatting if value in cell is found in a named range
  193. INDEX and MATCH in one formula...
  194. Count If 3 Criteria Met
  195. CountIf by Month-to-date
  196. percetile function limitation
  197. Insert blank line macro
  198. Check for Duplicates
  199. why am I getting a #VALUE! error?
  200. find and replace - replace data in rows to separated by commas
  201. cell format changes when formula copied?
  202. Help with a function button within a cell
  203. Screening one list for data
  204. address() function
  205. Sum if need help
  206. Match/Index Returning #N/A
  207. Lookup different sheets and get the value from the sheet specified
  208. count function help
  209. VLOOKUP - 2 Questions
  210. Insert Subtotal button
  211. Another time addition problem
  212. Create number format for 4 digit integer preceded by zero
  213. CountIF() in Worksheet B while referencing cells in Worksheet A
  214. sumproduct question - kind of...
  215. Changing Text format in a function
  216. order formulas are updated..
  217. CountIF() in Worksheet B while referencing cells in Worksheet A
  218. Viewing data in Excel while scrolling. Instead of the cell count?
  219. copy data from various sheets into one sheet
  220. Data consolidation from Multiple Sheets
  221. Excel Formula or tool to compare two columns of data
  222. Macro help
  223. need to ONLY display worksheets that have had recently changed
  224. Copy cells, preserve cell size
  225. SQL.REQUEST not working in EXCEL 2003
  226. TRIMMEAN with different percentiles?
  227. increasing and decreasing a value in a cell
  228. how can update the data in an excel workbook without opening it
  229. Answers needed for challenging formula
  230. Formula too long - Shorter version?
  231. MSN Stock Quotes Excel plugin broken?
  232. how do i use import to consolidate data from multiple sheets
  233. seeking of array
  234. Comparing and counting occurences in 2 columns
  235. Little help with weibull function needed
  236. How can I set up a milestone report with red/green/amber alerts
  237. Excel Programming
  238. Lookup and compare rows
  239. Excel Programming
  240. Can't get CUMPRINC to work. Have Installed Analysis Toolpak
  241. Can't get CUMPRINC to work. Have Installed Analysis Toolpak
  242. Copying problem
  243. data entry in excel by linking to other word doc. or excel sheets
  244. how do I round numbers in .125 increments
  245. formula link to a file
  246. changing the year of a date
  247. Sumproduct Date clarification
  248. Formula for rounding a column of currency to a multiple
  249. Convert text in cell to a range name for formula
  250. 2 column lookup - match to date range