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. Real Time Charting
  2. Excel formulas on different Powerpoint Slides
  3. Need excel formula help
  4. Calculate current date from fixed time?
  5. search for and return more than one row in a sheet
  6. Check In
  7. How to convert Euro's to Canadian dollars?
  8. time sum incorrect
  9. Help With A Tricky SUMPRODUCT Function
  10. If statement using multi columns
  11. numbers automatically format
  12. fromatting formulae with text & dates
  13. Lock a cell from others to edit?
  14. How do I repeat an item in multiple formulas w/out retyping each
  15. Columns To Rows
  16. Program "Enter" Key
  17. Copying and Pasting a cell with a constant number
  18. Index / Match Help
  19. Upcoming Date alerts
  20. #REF using =INDIRECT...
  21. Another SUMIF question
  22. Help with getting data from a worksheet
  23. need help with drop box please!!
  24. Inconsistent results with =LOOKUP?
  25. MODIFICATION IS NOT ALLOWED
  26. PivotTable Question
  27. string/char CONTAINS function?
  28. Sum If ???
  29. SUMIF function help
  30. Drop down menus
  31. lookup function .... I think???
  32. Default Page Settings
  33. Adding a Function to a cell when inserting a row from a macro
  34. Adding and Deleting rows - update formulas help needed.
  35. Summing
  36. Need conditional statement to paint a cell
  37. Copy Formula Problem
  38. how do i format cells with preceeding zeros & minus sign
  39. refreshing linked workbooks
  40. HIGHLIGHTING
  41. "Last Saved" date in Excel 2000
  42. Global Custom Formats
  43. If Calculation
  44. Max value within a set of rows
  45. Adding only the filtered results
  46. SUMPRODUCT problem
  47. Conditional Summing reminder/refresher (please!)
  48. exceptions in filtering
  49. Now formula problem
  50. Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21
  51. Sumif interior.colorindex condition
  52. Roster
  53. nested if
  54. Count Number of Occurrences in a Column
  55. Tool tips for UDF
  56. HOW CAN I SORT A "RANKED" COLUMN WITHOUT LOSING THE FORMULA?
  57. What does an apostrophe (') in front of a word mean?
  58. move or copy sheet
  59. Hours and Minutes to minutes
  60. Am I able to protect my work sheet and keep my grouping function?
  61. forcing caps lock
  62. make criteria in sumif refer to another cell
  63. LOOKUP multiple results but ignore duplicates.
  64. Frequency
  65. Formula for calculating Hydro bill
  66. VLOOKUP problem with using a -
  67. Getting cell reference in excel through VBA
  68. Lookup a value in a list & return multiple corresponding values
  69. 3 step "if" function
  70. two-way ANOVA
  71. Writing a macro that updates solver solutions?
  72. Need a count of #of times a result occurred on multiple platforms
  73. Unmerge to all cells possible?
  74. 2 questions about IF
  75. Can anyone shorten this one. (not overly clear on array usage)
  76. How can use a lookup formula through multiple worksheets?
  77. Creating a Count formula
  78. Office 2007 Installation
  79. pulling data!
  80. Insert macro in IF Function
  81. what's the easiest way to common size a balance sheet
  82. Which formula to use for compounding interest for specific # of da
  83. calculation LOG10 using relationals
  84. reference autofill.
  85. Looking for a function to count alpha values in a range.
  86. Cost to Retail Price Formula - some help pse
  87. Disable Cut function
  88. Rounding up Formula
  89. Looking for a formula to create a mnemonic, using two existing col
  90. Sumif
  91. Space between series
  92. Cell reference in different worksheet in formula
  93. Convert 1934 minutes into 32Hour 14Minutes
  94. using a countif with multiple columns
  95. lookup based on multiple dates
  96. Formula not working
  97. question about many sheets in one warkbook
  98. Sumif on Formula instead of Value
  99. How do I count non-contiguous cells?
  100. Macro Help
  101. formula doesn't show
  102. Protection
  103. How to make a more complicated version of the if function
  104. OT I would want protect my sheets of excel from a "password recovery" software... How?
  105. how do I get the cell to move to the right instead of the wrksht?
  106. finding blank cell and moving specific data into it
  107. How I print only the cells with data without selecting everytime?
  108. survey results tally
  109. IF/AND Statements in Comp Calculator
  110. Reference different files using vlookup
  111. Need to reference different files using vlookup
  112. MONTH()
  113. How to dynamically calculate totals from data being exported
  114. Password protect cells
  115. How do I eliminate "false" from showing in a cell?
  116. functions
  117. functions
  118. Count Function
  119. FUNTIONS
  120. Replacing the row index in HLOOKUP
  121. Calculation of Hrs and Mins from 2 Time Frames
  122. Help displayed while hovering over a button
  123. formating cells using formula rather than menus/VBA
  124. List Box Contents
  125. Filtering
  126. sorting rows
  127. Excel Iterations? Conditional Operations?
  128. Excel 2003 does not recognize "no fill" from older Excel
  129. Excel 2003 does not recognize "no fill" from older Excel
  130. VLOOKUP date search
  131. How do you turn off a FilterKey?
  132. OFFSET behaving oddly
  133. Works if I copy F Col to A Col
  134. Top 10% and Bottom 10%
  135. Autofilter - copy & paste
  136. Look up Webpage addresses from a List of company names in Excell?
  137. wild card with if logical function
  138. Cant get my head around this one
  139. If Function
  140. Concatenation and skipping blank cells
  141. Sumif
  142. Formula for Petty Cash form to return -/+ amount?
  143. Minimum highlight
  144. Links to Multiple Spreadsheets
  145. Advanced filter
  146. The edit - find command
  147. How do I sort a large column of data by length?
  148. Newbie Question, NOW() function
  149. Lookup query in excel
  150. MSNStockquote function is not working in Office 2007 beta
  151. how to get a data form to fill you own exel sheet (was data-form
  152. FOOTER
  153. projecting when a person is 70 from DOB
  154. cONDITIONAL fORMATTING
  155. how to get "123" as one hundred and twenty three in excel
  156. Defined name Relative to sheets
  157. How do i add a cell value in a sentence without using 2 cells?
  158. Setting TAB to navigate to selected Cells Only
  159. LINEST()
  160. Sumif problem
  161. I want cell A1 to equal $A$2 even after inserting line at A2
  162. holiday dates
  163. extend on an index formula I already have
  164. Adding number to a cell reference not to the contents
  165. :confused: Nested if then else statement
  166. Filter data automatically by input
  167. How do you set cursor position at current date in macro?
  168. How do I set macro to run at specified time?
  169. DMIN Criteria
  170. Disable a range of Cells
  171. Prevent Consecutive Entries
  172. Creating an exact time display
  173. VBA function for annualized return (geometric mean)
  174. Vertical scroll bar jumps scrolls line 1 to line 2705?
  175. Calculate Loan Payment Dates
  176. Schedule Type Graphic/Forumula
  177. Calc minutes and seconds difference
  178. Email selected worksheets from a workbook as attachment.
  179. There is a bug in formatting charts data labels.
  180. HOW DO I CHANGE THE EXCEL CURSOR TO AN ARROW FROM A CROSS ?
  181. How do I figure out a pre-tax amount when I know the final total?
  182. Displaying certain coloured cell
  183. Group & sort rows that have a specific value in column C
  184. Need help applying a formula to a certain area of the worksheet
  185. hyperlink cells between workbooks
  186. Question about copy/paste functions
  187. I wish automate a cut and paste of data from one work book to ano
  188. How do I copy data from main frame computer and keep data in cell
  189. I need to swap last name, first name in a cell to first name last
  190. set height of individual cells
  191. using AND/BETWEEN in a countif formula
  192. Rounding down
  193. Vlook
  194. Conditional string calculations
  195. validation of time
  196. equation for a power analysis
  197. subtracting time
  198. Excel shared workbook copies rows by itself
  199. Unexplainable results from my vlookup
  200. BIN2DEC bits 0-5 then 6-15
  201. search massive
  202. match and sort columns
  203. can you nested sum and round function within if function?
  204. Return a value for a range of dates
  205. HOW CAN I PULL INFORMATION FROM ONE SHEET TO ANOTHER IF NOT #
  206. Not as stupid a question; this time about data from multiple sheet
  207. false result
  208. VLLOKUP - more than one result??
  209. Lookup two different columns
  210. Can't Get Objects To Work In A Protected Worksheet
  211. Removing spaces from columns
  212. edit more than one Hyperlink at a time
  213. counting if
  214. Formula to display the row number above?
  215. date function
  216. date function
  217. Calculating first/last Monday, Tuesday, etc. in a given month in E
  218. IF Formala Doesn't Work
  219. Compare and merge
  220. How do I set the tab stops in a specific cell pattern?
  221. Vlookup file location changes depending on value within cell
  222. Help with using a work sheet to compile data
  223. Data Group Total
  224. Using worksheet to process formulas and return new values per day
  225. Using worksheet to process formulas and return new values per day
  226. Sum of Cells if Row Contains a Specific Variable
  227. Conditional Formatting Bottom 10 with "ties"
  228. Cell calculate only once
  229. How to perform calcutions only if value if greater than zero?
  230. Setting Reminders
  231. Subtotalling
  232. Excel worksheets
  233. Excel worksheets
  234. mix font styles in concatenated text
  235. Excel worksheets
  236. mix font styles in concatenated text
  237. mix font styles in concatenated text
  238. Shared spreadsheet changes color when opened ny another user. Why
  239. Shared spreadsheet changes color when opened ny another user. Why
  240. find
  241. Multiple Filters in one Sheet
  242. How do I have calculation responses viewed in a Purchase Order?
  243. password protect column
  244. Multiple text sheets into a master worksheet as you enter data
  245. where is the function wizard in excell??
  246. If, then question
  247. If/Then Statements
  248. How to remove unwanted green horizontal lines in Word Table?
  249. Can't remove Conditional Formatting
  250. DELETE ALL ROWS & COLUMNS WITH ZERO BALACES