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. Change background color with IF statement
  2. irr function
  3. How do I search an array for values in a column greater than zero
  4. How do I assign numerical values to a letter? Ex: A = 4, B=3, etc
  5. HOW DO YOU SORT EXCEL FILE WITH BLANKS
  6. validate work sheets
  7. How do I truncate or hide portions of text in a pivot table?
  8. countif function
  9. Protecting a shared worksheet
  10. HOW DO I CLEAN UNCLEAN DATA?
  11. Pivot Table Error Message
  12. countif function
  13. array formula count results of two tests
  14. Column Name Formula
  15. naming a grouped column
  16. Sumproduct,Countif, I don't Know!!!!!
  17. How does Excel determine the ORDER of consolidated data?
  18. Help with IF function...
  19. Change the Auto-filter that is "on" to a RED arrow, can't see blu
  20. Return number OR sum based on two criteria
  21. How do you compare names in two lists? One is a subset.
  22. Pick from lists
  23. Count Certain Cells in Specified Range
  24. sequence number based on date
  25. lookup and return values using lists
  26. Multiple Functions and conditions
  27. I want brackets around my math equation answer?
  28. can a dde link populate excel creating new rows automatically?
  29. New VLOOKUP problem
  30. Nested sumif/sumproduct
  31. Clipboard collects items but will not paste them.
  32. Advanced Filter Using Calculaions
  33. Circular Reference Error Even Though There Is No C.R.
  34. Not delete row using or
  35. I can't view column A in a document and it won't unhide.
  36. Can I merge addresses from one excel worksheet to another?
  37. Using Sumproduct to count text occurence
  38. how do i set up/use drop down list in excel
  39. How do I rename multiple sheets at one time in Excel?
  40. max function with a less than or equal to
  41. Apply multiple Conditional Formats
  42. Numbers Into Data
  43. how to save imported data in diffrent worksheet cel before refrehs
  44. Fomula need to pick up last entry in a row
  45. Nested IF with a VLOOKUP?
  46. Does anyone know how to create a lookup that will do this?
  47. Filename from a Cell
  48. How to find missing numbers in series
  49. How do I hide or unhide row and column heading in Excel?
  50. Putting check marks in every cell in a column?
  51. Copying Spreadsheets without referencing other workbook.
  52. SumIf with an Or
  53. count cells that begin with specific text
  54. Ignoring Blank value in a drop down list
  55. data validation
  56. Comma delimiter
  57. Passwords on Worksheets
  58. DIV error
  59. Execl formula return the lowest value
  60. Opening Different Programs using Excel.
  61. Number Placing
  62. Create Excel Grouping according to Merge Cells
  63. Not all links are created equal
  64. create a list box
  65. The Seemingly Impossible
  66. Sum of a range if the value in cells are > 0
  67. Data collation killing me!!
  68. Can this be right? Excel has no XOR function???
  69. Getting a string of data from a file name
  70. Holidays
  71. Need help on creating a formula in excel
  72. How do I update filters when using Autofilter?
  73. Brain Dead: Need help with ????
  74. Excel Rankings function
  75. Simultaneous Filtering
  76. How do I say "if this cell is blank, use this formula...
  77. Nested if statements - is there a better way?
  78. Dragging graph-points to change data? (!)
  79. problem with linking data
  80. Is it possible to combine two worsheets into one Pivot Table?
  81. Excel should let me divide and multiply time intervals
  82. How do I keep the 0 at the beginning of my order? (098523)
  83. calc # of d, m, y, then round to nearest fraction
  84. Follow-up to the IF with OR function
  85. Start & Finish Time
  86. Filter horizontally?
  87. Filter horizontally?
  88. Populating one worksheet from another
  89. How do I set up a way to keep track of vendor invoices?
  90. Adding math
  91. finding exact matches using vlookup
  92. Assign a date to a record for consecutive days
  93. How do I create shiftwork schedules in Exel?
  94. IF with "or"
  95. cell addition
  96. formula to calculate time values
  97. embedded ifs
  98. Top border in a footer in Excel,
  99. Pivottable percentages
  100. Matching up data
  101. Saving Sort Criteria (or Sort Lists)
  102. delete row
  103. match word in one column form list in another
  104. VLookup Nightmare!
  105. Right clicked range highlights in Excel would add the "$" to func
  106. Counting a Column when Three Conditions are true
  107. distorted totals
  108. Copying comments from one cell to another, in a different spreadsheet
  109. Discounted Payback
  110. Discounted Payback
  111. I need a macro that saves a spreadsheet on two drive at once,
  112. Trying to convert date to day
  113. SUMPRODUCT not equal to...
  114. Match Function
  115. Listing variable names for 3 greatest values in a column?
  116. Functions- Finding and counting specified text in cell range
  117. formula to apply concatenation to successive rows of data
  118. lookup formula?
  119. Hiding tools/options
  120. Are there any job costing templates available for free?
  121. VLOOKUP Help
  122. Conditional Formatting
  123. Using List Box To Clear Cells
  124. IF statement question
  125. My Menu bar is hidden. How do i restore it.
  126. Color of text/Data in a Cell
  127. refer to last cell in worksheet?
  128. How to get double quotes to show up after pasting?
  129. Use of the MID function
  130. Worksheet Help
  131. How to use the If Function?
  132. multiple lines in a cell
  133. How do I get my curser to move by using my arrow keys in Excel?
  134. Please explain function/formula
  135. 3 way dependant lists
  136. custom label
  137. Getting the top five incidents
  138. Calculating Flying hours allowing for GMT or BST
  139. sort prob with Common info on more than one sheet
  140. Matching cell information
  141. London Excel User Conference - Thank you
  142. word frequency
  143. Multiple criteria countif/sumproduct function
  144. Selecting the first non blank cell in Range
  145. Concatenating Text and Date in a chart series Name box.
  146. Project exponential growth againt linear timeline
  147. Find multiple repeated values in a Pivot Table
  148. combo box
  149. how to total amounts in one colum
  150. Prevent The Cruelty
  151. convert numbers stored as numbers to text
  152. DSUM with dates??
  153. #N/A errors when matching time values
  154. SUMPRODUCE and AVERAGE
  155. Can we do "save as tab delimited text" from cmd ?
  156. How to create a 'name' which is not worksheet spcific
  157. how do i enable negative results in the lcm function?
  158. How to match values in one column to values in another?
  159. How to insert hyphen "-" in between two numbers
  160. Intersection point return data
  161. Dropdown Data Lookup
  162. a weekly grocery list and costs, available coupons and value
  163. VLOOKUP and truncating time
  164. Object Variable Not Set Error on Selection object
  165. Format text 'dates' to real dates
  166. Setting up a validation of data listbox to provide the unique items within a range
  167. When I try to insert a logo (.jpg) it prints out as a black box
  168. Millionaire Retires and Gives His Multi-Million Dollar Business Formula To You
  169. Help to create a date formula
  170. Counting letters and symbols
  171. pulling 5 lines of info from a sheet
  172. VLOOKUP and Add data
  173. Sumproduct W-t-d
  174. enter data two worksheets but not in the same cell as first
  175. how can i change the colour of eg. datas more than 10%?
  176. WEEKNUM to dynamic range name
  177. Major Help Needed Asap
  178. dates
  179. How to Create a list which sort itself automatically
  180. Recording Absences
  181. How to determine the column letter from Cell address
  182. Convert My Data into Barcode 128 B
  183. Calculate Checksum
  184. Pivot Table Sub total and totals
  185. SUMIF / COUNTIF Problem
  186. For dates, copy/paste special/values for 2006 gives me 2010--Why
  187. Pivot Table Field
  188. Nursing Rota Question
  189. how can I stop an excel cell being calculated
  190. Sum on multiple columns
  191. Excel Worksheet Printing
  192. Pasting HTML into the cells in column A
  193. In Excel 2003 can you password protect a single page in excel?
  194. Help With Formula
  195. data retrival
  196. is there a function for this?
  197. Another Conditional Formatting Question
  198. Syntax to "OR" 3 "ISERROR" conditions
  199. How do I re-calculalate the values for all cells in a column
  200. numbers to characters
  201. If and nested Sumif error
  202. Updating a Date in a Graph Header Field
  203. How to copy data to the next empty cell in a column
  204. Conditional Formatting
  205. reference different sheet in same workbook
  206. How to get current worksheet name to display in a cell?
  207. common numbers in 2 columns
  208. NETWORKDAYS Function doesn't work
  209. Averaging Time withing Excel
  210. Circular Reference Formula Help
  211. Drop Down selecting worksheet
  212. Create a List That is Pivotable
  213. Increase group of numbers by same amount
  214. Return last cell that contains a particular value
  215. formulas involving ranges
  216. Need to Sum when THREE Conditions are met
  217. I need help with a formula...
  218. Simple Equation Builder/Solver in Excel for use in Dell Axim X51v
  219. Need help with VLOOKUP
  220. writing a statement
  221. Trend question
  222. Calculating correct pecentages with negative values
  223. Create a macro to delete rows if value is less than a specified nu
  224. calculate difference between two times
  225. removing weekends
  226. Hyperlinks in Excel
  227. Protect worksheet and still allow user to sort data
  228. Sum when two conditions are met
  229. Statistics Student>Simple Graph Template?
  230. How can I redline (mark corrections) in Excel 2003?
  231. Using IF statement compare cell ID with data in another column tru
  232. Countdown
  233. recording more than 2 changing values in Excel at a time???
  234. Automate Excel report to place certain data into existing report?
  235. Hexidecimal lookup
  236. Re: Date Calculation
  237. lock only one cell
  238. how to enter negative amounts in the unit price column of excel
  239. Protection using the subtotal function
  240. sum column when it meets certain conditions
  241. Linking one cell to another
  242. Drag formula down
  243. External hyperlink to a specific page in a workbook
  244. Unable to remove objects pasted into Excel from HTML grid
  245. vlookup for exchange rate
  246. Find max value in a row and return column title
  247. Drag Formula copies values instead
  248. Function help
  249. Concaenate formula- text diff lines?
  250. Weeks and dates