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. If alternative
  2. Compare 2 columns and choose one and enter answer in third column
  3. What if I want the answer to be in Dollars or Percentage.
  4. How do I obtain the Average Values between 2 dates?
  5. How do I concatenate two currency cells to show a price range?
  6. Excel - Time display
  7. Help
  8. Finding max value within a subgroup
  9. Can I display a cell based on a calculation (eg M(14/2)?
  10. Need help with math Function
  11. Averaging Cells from another workbook
  12. remove negative from number
  13. Confidence Interval
  14. Excel Indexing Function
  15. Function that will = 1 of 4 cell containing text
  16. Calculating Paycheck to Include Overtime
  17. sum returns #N/A
  18. Using the "$" as part of a cell reference
  19. Dates
  20. Select a range of non-adjacent cells in Excel?
  21. Insert and sum in empty cell
  22. Number format in a formula
  23. CUBEVALUE Function - Excel 2007
  24. How to go End of Huge Data Range?
  25. How to go End of Huge Data Range?
  26. How to go End of Huge Data Range?
  27. formula for a # in a column of #'s that's closest to a certain val
  28. Keeping the same format in linked worksheets
  29. Neet to use Excel to read in multiple-sheet file
  30. Trying to find a way to fill in the rest of a row if it is a dupli
  31. Comparing Times To Make Sure No Overlap
  32. Deleting rows with macro
  33. VLOOKUP - Can't see result
  34. If Statement/Conditional Formatting
  35. hyperlink tospecific sheet of html workbook
  36. Vlookup more than one criterion
  37. turn a colon into a period? timestamp related
  38. turn a colon into a period? timestamp related
  39. turn a colon into a period? timestamp related
  40. If function
  41. Network days question
  42. How do I remove the words Page 1 from the body of a worksheet
  43. Help with and /if formulas
  44. Double Criteria
  45. combo box dropdown list
  46. How to lookup the minimum, 2nd minimum and 3rd minimum.........
  47. Formula
  48. how to delete the 4 rightmost digits from a cell
  49. correlation p values
  50. Excel error message
  51. Adding on a 24 hour clock basis
  52. IF FORMULA
  53. =?Utf-8?Q?Trying_to_find_sales_figures_of_?==?Utf-8?Q?certain_products=E2=80=A6?=
  54. Include ability to sort Excel cells by colour
  55. Include ability to sort Excel cells by colour
  56. Hyperlinks and protected workbooks
  57. 3 ifs in one statement
  58. Auto Copying Data
  59. Use a formula to delete part of a text string?
  60. months calculation
  61. copying a picture in a cell
  62. copying a picture in a cell
  63. I want to set up a conditional formula
  64. Auto Data Transfer
  65. Auto Data Transfer
  66. How do I create an overall graph from Multiple worksheets?
  67. population percentages and ranks
  68. Calculate number of years and months employed using hire date and.
  69. Using SUMIF Function with a named cell reference as value in CRITE
  70. counting valid dates in a range of cells
  71. N/A Error
  72. Warning Message
  73. On Exit, always asked to save
  74. Need help on four different topics.
  75. filtering data and blue marks
  76. Creating a formula to populate information from multiple cells in another workbook
  77. Editing Data in Excel
  78. count specific value with filtered data
  79. How do i make cells in one worksheet copy certain data to another
  80. problem setting formula
  81. How do I set uo a template of formulas in excel
  82. formulas
  83. Finding Duplicate Phrases in a File
  84. IF statement help
  85. Count IF omitting blank or zeroes
  86. How do I get the total number of items that meet 2 criteria in Exc
  87. Vlookup or what should i use ?
  88. Cross-Worksheet Averaging
  89. excel
  90. Can I create a formula dependent on if a cell is highlighted or no
  91. Entering historic dates
  92. Adding 2 cells together and paste into 1 cell
  93. excell arrays
  94. Error Checking for Duplicates in List
  95. Help! Boss needs this ASAP - I am pulling out my hair here folks use of "&" in HEADER
  96. labels to list
  97. formula too long error?
  98. Linking cells with comments
  99. Populate required cells prior to saving
  100. Count # of unique occurances
  101. Change row color based on condition of celss
  102. HELP!
  103. Is it possible to have phone numbers dial when clicked in Excel?
  104. Text to Number
  105. How do I do a "between" in an IF statement?
  106. Using Excel defined functions in UDF
  107. Losing reference when deleting worksheet
  108. Excel formula
  109. Custom number formats in TEXT function
  110. Hide row if cell = 0
  111. How do I separate the alpha prefix from a text (abc123 or a1234)?
  112. Can I re-number Excel Form Label Controls for orderly tabbing.
  113. For some reason I can't insert an object on my spread sheet.
  114. Use of range in an if function
  115. Find text
  116. Pivot Table Label
  117. Add per dates
  118. Question regarding Excel functions
  119. import info from outlook to existing excel file
  120. Match Value and then offset
  121. Can't do calculations with the data from a web queries
  122. How do I change numbers and percentages in a formula??
  123. Count If
  124. Conditional Format Question
  125. Counting Multiple Criteria
  126. Pivot table grouped results
  127. Help regarding 'IF' function in Excel
  128. Automatically transfer cell contents
  129. vlookup formula different workbook
  130. How do I find clearing items in a column in Excel?
  131. Help with array's
  132. Can an Excel hyperlink be linked to an outlook file?
  133. Max,if,vlookup??
  134. Macro to insert formula
  135. counting occurences in data range (e.g 31-60)
  136. I've no idea how to do this. :(
  137. Makro in excel
  138. London Excel User Conference - Register now, it is not too late
  139. More help needed :-(
  140. Return cell adress for next non-blank cell in a range
  141. Multiple source for pivot
  142. Excel list feature should search with more than first character
  143. Pivot Table Data - Troubleshoot needed
  144. Date Button
  145. If statement on cell with #N/A
  146. Conditional Formatting...
  147. Record the minimum-est value.
  148. Record the minimum-est value.
  149. vlookup totals?
  150. Worksheet view
  151. Ending Negative Sign
  152. calculate erlang
  153. need the result after using formula in deffrent colour
  154. VLookup a Vlookup
  155. Need a formula to calculate greater than & show answer as a %
  156. Saving some cells
  157. vlookup colums with reference to a formula from another sheet
  158. I locked up my column and rows they are highlighted
  159. can excel choose a name from a list when I am typing in a cell
  160. sum of top 5 base on one condition
  161. sum top 5 base on one condition
  162. Index by Range
  163. Problems with INDEX formula
  164. Excel Macros
  165. SUMPRODUCT
  166. cell formatting won't update
  167. sumproduct help
  168. Strange error with basic divide function
  169. Convert input cell into metric tons
  170. Duplicate values in Pivot table Page Field dropdown..
  171. How can I always ROUND UP to the nearest multipal of 5 in excl
  172. how to use find binoculars in excel 2000 .xls ?
  173. Calculate the return of irregular deposits
  174. I have a problem with my Formula.
  175. Vlookup on multiple cells
  176. Deadline Notice
  177. function to check rows
  178. Problems with Fuction Loading
  179. How doe I protect user defined functions in VB Editor
  180. Thanks for all you help
  181. help! cumulative returns
  182. Preventing a function being called if argument is unchanged
  183. Formula Help
  184. Can I condition format, "if the cell contains a formula"
  185. index, match formula
  186. Missing tabs in Format Cells Menu
  187. countif multiple criteria
  188. Autosorting Information
  189. Automatic Sort for variable Ranges
  190. Help with layout change
  191. Need help with formula...
  192. Auto save file copy with unique filename
  193. CELL COLOR DOES NOT SHOW ON SCREEN, DOES PRINTS
  194. Find/Replace last couple of digits on number
  195. how to re-layout data
  196. Adding data to matching records...
  197. Display Dynamic Range
  198. Sorts on variable ranges
  199. Worksheet formatting
  200. IF STATEMENT
  201. MID Formula
  202. Add formatting to all pages in workbook
  203. can not insert object
  204. Conditional formula based on formatting
  205. Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!!
  206. nested subtotals
  207. How do I show the date of an update?
  208. conditional formatting, multiple criteria
  209. Functions and Formats
  210. Vlookup fuction
  211. how do I remove repeated data in excel
  212. How can I link external excel file cell formats?
  213. Fill colors aren't displayed in my Spread sheet but they print.
  214. array results not returned
  215. Countif for the number of a specific count?
  216. lookup specific text, then apply rules
  217. How can I link external file cell formats?
  218. count the number of times a specific word appears in a column
  219. How to return the row # of an expression in specific array of cell
  220. SUMPRODUCT with varying # of rows
  221. Major Sorting Problems!!!
  222. Countif Multiple with text
  223. Countif over several worksheets
  224. Is there a shorter/quicker way to do this?
  225. Copying index/ match formula
  226. DCOUNT and DSUM functions
  227. Hyperlink Woes - Please Help
  228. Start & End of the data series
  229. calculation
  230. Count if
  231. date
  232. Assigining User Defined Functions to Categories in Addins
  233. Lookup Data in two seperate Spreadsheets
  234. vlookup not returning full field value (text)
  235. Conditional Formula - calculate only if net unit is zero
  236. Variable Cell Reference
  237. Rounding Formula
  238. 2 qurstions
  239. predefine english word on the cell
  240. conditional format text size
  241. number input box
  242. weeknum gone ??
  243. Excel Insert Function form
  244. How do I add a serial number to an invoice
  245. How to search for grouped rows?
  246. Multiple Consolidation Ranges
  247. How to open a work spreed sheet
  248. How do I use a template to keep records for equipment?
  249. HOW TO FIND THE GREATEST COMMON FACTOR
  250. Another vlookup problem