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. Help Please, Worksheet Change
  2. What are the reasons if the "the solver" will not install?
  3. Excel worksheet functions question.
  4. how do you nest ROUNDDOWN in an IF formula?
  5. Comparison Function
  6. How do I compare lists in cells Excel
  7. Help with IF function
  8. I was creating a histogram; now i have data but no histogram.
  9. Vlookup for multiple criteria
  10. insert picture excel 2007 from scanner or camera
  11. All Capitals
  12. Search for first instance of text & return the value
  13. Averaging seconds
  14. Formula Help please
  15. Formula to show zero if reference cell is zero? tricky!
  16. How do I get the grouping dialogue box to appear in Pivot Tables?
  17. functions to count Yes & No
  18. How To Lock Cells and Columns without Protecting Worksheet
  19. how do I automatically hide or suppress zero balance rows
  20. Help with an Excel formula please. - it is beyond me!!
  21. Create 5 unique value between 1 and 14?
  22. Pivot table and Dsum security
  23. How can I CUT and paste to convert columns to rows?
  24. =Now()
  25. Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)?
  26. In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.
  27. How to convert cell contents
  28. maximum repeated value
  29. Dame: identifying duplicate numbers within a column
  30. unhide rows when cell is clicked
  31. unlock a spreadsheet without password
  32. converting month name to number
  33. MEGA FORMULA
  34. User defined functions without using VBA.
  35. User defined functions without using VBA.
  36. how can i ignore an error in a formula
  37. Compound Lookup, Large/Small, Match...
  38. Help with SUBTOTAL formula
  39. Still a problem with DSUM function
  40. Dare Format
  41. Convert a julian gregorian date code into a regular date
  42. Externalizing formulas.
  43. Please help!
  44. excel function
  45. how do I perform a lookup on an 80,000 line array?
  46. Hlookup search in more than one sheet of excell?
  47. Multiple hyperlinks from drop down box
  48. Total Minutes
  49. turn off convert text to date (i.e. 4-9 to April 9, 2006)
  50. Copy Worksheets
  51. Conditional COUNTIF Function
  52. IF Statement, including AND
  53. How do I Change the value in a count function from 1 to .25
  54. How do I Change the value in a count function from 1 to .25
  55. How do I Change the value in a count function from 1 to .25
  56. Xcel Formula # rows With value X in colF AND Value A or B in colJ
  57. Web toolbar in Excel 2007 beta
  58. Moving cell data and separating or deleting
  59. need value from referenced cell
  60. I need to count data in one colum based on data in another column
  61. Moving left of a cell reference
  62. Moving left of a cell reference
  63. query in excel
  64. Find and replace Comments
  65. London Excel Conference Registration giveaway
  66. MSQuery
  67. RE-submitting of: constructing (complex) variables with worksheet functions
  68. Hyperlinks
  69. do loops
  70. Max and lookups
  71. how do i save a large amount of data in a worksheet excel 4
  72. find value one row in advance of specified value
  73. if again
  74. if specific value from list A equals one of the values from list b...
  75. RANK, duplicate ranking but no gaps in rank
  76. Selection of Drop down list that allows you to go to a particular cell
  77. Running Sum across columns but only to a certain point
  78. How to parse a string with a date?
  79. making cells change relative to each other? cant figure it out
  80. making cells change relative to each other?
  81. Need a pareto of a text table
  82. Excel Workbook
  83. IF Function with equation and text
  84. Passing a WorkSheet from a Function???
  85. copy cell from one sheet to another
  86. place a number in a cell
  87. look up a value in one column to another colum
  88. Calculating Compounded Growth Rates
  89. help. Excel shows formulas, not answers
  90. Displaying result in parentheses
  91. formula error
  92. How do I rename an Excel worksheet when the feature is grayed out.
  93. Complex logical/conditional formula
  94. Adding A Not(IsBlank) To IF Statement(help)
  95. using VB to read in a column of values of varying length into an array
  96. searching all workbook sheets
  97. Compare and copy unique values
  98. finding a name in a string
  99. changing datas when adding row ?
  100. Datedif using cell references Excel 2000
  101. Rows into Columms
  102. How do I covert rows to columms?
  103. How are empty cells referenced in Excel in IF statements?
  104. How to smart count a table with words in it!
  105. EXCEL HELP
  106. Trying to replace "false" in IF statement...
  107. Apply Absolute Reference to multiplie cells
  108. Shrink to fit Macro Button
  109. Type in Part number which pulls info from another wksheet
  110. comparing ranges/arrays
  111. How do I change the IRR formula for MONTHLY periodic payments?
  112. How can I connect a word of text to a certain dollar value?
  113. <HELP> modified reference
  114. production cost
  115. How many characters in a box..?
  116. Using vlookup - how can I obtain a sum of values, not just first v
  117. Can anyone help?
  118. Stock data manipulation
  119. Compare Two Lists
  120. Date Function formula that will return the date of a specific week
  121. Automatically number lines
  122. Excel 2007 worksheet headers do not print
  123. lookups and match
  124. Customise the summation function / button
  125. Personally Identifying information in Excel Sheet
  126. Excel Data Sort in Excel2000
  127. Determine Future Value to Meet Average
  128. Factorial (like =FACT) function?
  129. Excel
  130. How do I open several worksheets from the same workbook on screen
  131. Arranging Names in a cell
  132. Speed fill function for MS Ecel 2007 (Beta)
  133. Formula to count cells between dates.
  134. Prom with the DSUM function
  135. Vlookup returns line number
  136. If Function with OR
  137. Counting cells using multiple criteria
  138. Date minus 3 months
  139. how to add a charater in front of part number
  140. Spreadsheet Alarms
  141. Formula
  142. How to get a cell with a zero errorto show the cell as blank
  143. alphabetcal order
  144. take numbers from one cell and add to another
  145. serial number decode
  146. percentages
  147. How to change a tab name with cell reference and formula?
  148. how can avoid considering of blank cells in IF function
  149. Is it possible to search tabs in excel?
  150. get back a document replaced by another
  151. Change the work sheet name in a formula by using cell reference
  152. Array Formula not working..?
  153. Array Formula not working..?
  154. Array Formula not working..?
  155. HLookup and how it works
  156. Macro hangs up often but sometimes works fine
  157. nested if function
  158. Title in one cell covering space of 3 cells underneath
  159. vba linking Excel and Word
  160. Last week for regular registration - London Excel User Conference - July 19-21
  161. Sum & two column conditions
  162. How to Add Restrictions to ComboBox...???
  163. Countif Problem
  164. Separate two words in cell
  165. change date format
  166. IF formula
  167. creating a quote looking up from tables
  168. Page set up for a workbook, so each sheet gets the same format ?
  169. CreateObject("Excel.Application")
  170. Internet Query?
  171. counting responses - please help
  172. load one vendors prices to a master workbook
  173. Compare and Merge Workbooks
  174. formula typed contains an error
  175. Parse from the Right
  176. Select from drop down list via typing text?
  177. Excel problem trying to format columns of data
  178. =SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2
  179. Age from birthdate
  180. Combo Box
  181. create list is missing from data menu
  182. 5 days week date (mon to fri)
  183. Calculate relative frequency?
  184. Template & Database Question
  185. I need to know what kinda Function to Use in A Worksheet
  186. What Formula To Use
  187. What Fourmula Would I use and How
  188. Newbie question Different decimal place values for columns
  189. Errors in "vlookups" formula
  190. vlookups error message
  191. Date issue
  192. what is the formula from british pounds to American dollars
  193. Basic Question on Subs
  194. cell reference changes and conditional formatting
  195. using logical functions
  196. HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
  197. HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
  198. Need column evaluated to count total of occurrences of "Y". How?
  199. Pivot Table
  200. Formula
  201. Pivot Table
  202. I want columns of worksheet to become rows and vice-versa.
  203. a exact string search inquiry
  204. How do I add the same dollar amount to all cells in excel?
  205. Average non zero values
  206. DCOUNT / COUNT IF???
  207. numbers in Excel
  208. IF with OR and AND - the Sequal
  209. finding value from table
  210. Does anyone have a solution for nesting an OFFSET in an HLOOKUP?
  211. IF with OR and AND
  212. Help with 2 sheets with data to work together
  213. Last Non Blank
  214. Circling cells based on a value
  215. Pivot table: sum of durations
  216. Would like help with displaying data if are a certain value is pre
  217. Zero starts of a number
  218. Confused on a function
  219. IF Function
  220. Find category value based on date range?
  221. looking for another same value cell in a range and returning a coresponding value
  222. New to Excel functions and need some help
  223. In Excel I want to copy text from spreadsheet to spreadsheet
  224. I need a date stamp that doesn't change when you enter text
  225. Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function
  226. Allow user to "switch" contents of two boxes in Excel
  227. calculation errors
  228. Formula Help
  229. Macro for column sum
  230. Worksheet not showing up in VBE
  231. Counting only Unique cells
  232. Help :-( - Auto Population
  233. Formatting smallest number in a range?
  234. hOW CAN i CHANGE HEADER ON ALL PAGES IN EXCEL?
  235. Using the =NOW() Function
  236. Desperately need help with 3 calculations
  237. can i execute a calculation in a cell at a certain time of the day
  238. Hyperlink trouble
  239. Hyperlink trouble
  240. How to update an external excel sheet
  241. Countifs and multiple columns...
  242. How to print a selected number of sheets?
  243. Printing selected sheets.
  244. PERCENTAGES
  245. Histogram Average
  246. Hyperlink trouble
  247. Name
  248. Final days for regular registration - London Excel User Conference - July 19-21
  249. Counting each time text appears in range???
  250. How to calculate odds in excel (for instance matching pairofdice)