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. [SOLVED] Help with Averaging
  2. [SOLVED] EOMONTH - Tools / Add Ins
  3. [SOLVED] display date, excluding weekends & holidays
  4. joining and sorting two arrays
  5. Vlookup Column Index Number
  6. [SOLVED] How to convert a column's cell formats
  7. Elapsed time with no dates
  8. Update second workbook data once another Workbook is Updated
  9. Average if
  10. Change cell colour based on contents of adjacent cell
  11. [SOLVED] separating numeric and alpha cell contents
  12. Grabbing cells with text from a range
  13. sum range of numbers if two criterias are met.
  14. Extracting numeric and alphabetic strings
  15. [SOLVED] counting number of unique items in column
  16. [SOLVED] Complex Array Formula - Scores and Weightings
  17. [SOLVED] Formulas that include Blank Cells
  18. [SOLVED] Conditional Sum
  19. [SOLVED] I renamed cells, now formulas wont copy correctly
  20. [SOLVED] Vlookup Table Array
  21. [SOLVED] display text and its formatting in other cell
  22. IF Statement
  23. Links to other workbooks in formula
  24. Concatenate across multiple worksheets based on variable
  25. Display cell contents of the latest date
  26. [SOLVED] countif multiple criteria.
  27. Listbox focus always in the "middle of viewable area"?
  28. [SOLVED] Update worksheet using Vlookup
  29. [SOLVED] Conditional formatting using AND,NOT,and OR
  30. [SOLVED] G11 to show the highest
  31. [SOLVED] Tab Name in cell
  32. If Statement, or am I going about this wrong?
  33. Insert date and user name after editing
  34. [SOLVED] Extracting data to form a new table
  35. [SOLVED] using the if formula with comparison operators
  36. Lookup/vlookup query
  37. Filtering Across Columns and return in a single column
  38. [SOLVED] reference not adjusted
  39. [SOLVED] Counting Data from one column to add another
  40. [SOLVED] Using indirect to sum multiple worksheet cells
  41. [SOLVED] Share with multiple users allowing macros
  42. Offset issue
  43. [SOLVED] Check if final week of fiscal period
  44. Separating Text & Numbers within the same cell...
  45. [SOLVED] Auto separating groups of like cells
  46. How to find multiple max values in data set
  47. Copying Data from one worksheet to another
  48. [SOLVED] Round Up Date
  49. Sum with Symbols
  50. Outlook export to excel for reformatting telephone numbers
  51. [SOLVED] Creating a default cell content?
  52. [SOLVED] Redundancy check
  53. variable if
  54. [SOLVED] Sum if, but the sum range is seperate cells ?
  55. [SOLVED] Count using 2 variables
  56. VLOOKUPS, wildcards, and multiple columns of source data
  57. Empty cells that aren't empty?
  58. [SOLVED] How to consolidate data - easy?
  59. Splitting Information in the Column
  60. Countif for non-continuous data
  61. Table Value Multiplay Formula
  62. [SOLVED] SumIf Problem
  63. Tab list /summary assistance
  64. [SOLVED] Calculating time, potential lunch break
  65. [SOLVED] Table Value Selection Formula
  66. VLOOKUP referring to columns to the left of the source column
  67. Help with 3-D referencing - I think
  68. Adding data
  69. [SOLVED] Deleting value from a cell
  70. How to Summarise the database
  71. How to calculate the Value of "X" if resulted Poisson value is known?
  72. [SOLVED] Subtracting the results of a formula
  73. Date issues
  74. [SOLVED] Pivot Table data inconsistency
  75. [SOLVED] Using Median with a look up function
  76. Averageif + sumproduct
  77. [SOLVED] How do I remove repetitions in a column?
  78. Looking for Excel Function to calculate amount owed
  79. [SOLVED] Alternative to a if statement
  80. [SOLVED] Show Cell contents when hovering over cell
  81. [SOLVED] Conditional Formatting Based Upon Various Dates
  82. [SOLVED] Ignoring blanks in a dynamic named range
  83. Attendance Tracker with drop downs
  84. Return all, after/before certain word.
  85. Seeking a formula...
  86. Combination Function?
  87. Extrapolating Data from 1 Period to Another?
  88. [SOLVED] Delete empty cells, and shift left
  89. [SOLVED] Select the named range to use in a function
  90. [SOLVED] Select Which Named Range to Use in a Function
  91. Monthly numbers to quarterly numbers
  92. ISERROR array problem
  93. Excel Function
  94. Allowing multi-sheet text strings to be saved
  95. [SOLVED] vlookup: search for value in SECOND column of table array and return value from FIRST
  96. Check box to lock out entering information?
  97. Challenging Excel Question!
  98. Unexpected result using IF THEN statment
  99. [SOLVED] Convert a Date Format to a text format
  100. need to display the worksheet name
  101. Help with a complex date format
  102. SUM if cell is > 0
  103. [SOLVED] Using vlookup for multiple sheets
  104. [SOLVED] Defining Dynamic ranges
  105. [SOLVED] if then statement in a formula
  106. [SOLVED] Vlookup help
  107. [SOLVED] Randomizing and then sorting data
  108. Change value next cell
  109. [SOLVED] Converting Countifs to 2003 formula
  110. [SOLVED] How to create a VLOOKUPIFS?
  111. Lookup & delete or copy?
  112. auto insert text
  113. [SOLVED] Excel protected sheets
  114. [SOLVED] show column of hyperlinks as the actual addresses and not just a word
  115. Conditional subtotalling
  116. How to type to select something in a Drop down list?
  117. [SOLVED] Index and Match.
  118. [SOLVED] DSUM Function - Can't repeat column ref. down rows.
  119. [SOLVED] Filtering for Summary
  120. How to get show information if a certain name was selected?
  121. [SOLVED] Want to combine celll values
  122. [SOLVED] How to Populate a listbox's from one list?
  123. Totalling values from multipile files
  124. COUNT unique values in NON hidden rows
  125. [SOLVED] Return Value from 2nd column when value in 1st column matches given criteria
  126. Complex IF Statement
  127. Arguments to give a set value
  128. is it impossible to match 2 columns & return values from a 3rd when a match is found
  129. [SOLVED] Trying to average columns from multiple sheets
  130. [SOLVED] help with conditional formatting duplicates
  131. [SOLVED] From cell in sheet 2 find name in sheet 1 and value offset
  132. Conditional Formatting Issue
  133. [SOLVED] SUMIF function help needed Got first now have second question
  134. Rotate Cell Layout From Horizontal To Verticle
  135. Rename WorkSheet
  136. If either condition is true (3 Or conditions)
  137. Variable Auto Sum
  138. [SOLVED] Combox Box
  139. [SOLVED] Referencing sheets titled as dates?
  140. VLOOKUP problems
  141. [SOLVED] counting functions - If Col A =5 and Col B < Col C
  142. Combining Data... Multiple Rows and Columns.
  143. what is the keybord short of format painter in excel
  144. Duplicate products from Drop down list will not populate
  145. pointers and string retention for recall
  146. [SOLVED] if,average,sum formula?
  147. [SOLVED] Creating Revenue Recognition Waterfall
  148. In need of a date formula
  149. [SOLVED] The MAX of multiple range
  150. Rounding and writing a formula?
  151. Partial Match List
  152. Adding to a max value
  153. [SOLVED] Ranking by multiple criteria
  154. [SOLVED] Replace #DIV/0 with Comment
  155. If Formulas
  156. [SOLVED] SumIf on moving Columns
  157. Unique records
  158. Conditional formatting removing duplicates
  159. [SOLVED] calculating hours left
  160. [SOLVED] Ranking with blank cells
  161. Match and Sort and Align two columns
  162. [SOLVED] Conditional Averages
  163. [SOLVED] Combining text and cell reference with Indirect
  164. Keeping a running total for Liquor Inventory
  165. [SOLVED] Find predominant number in list
  166. vlookup
  167. mid substitute formula
  168. Trying to add data from one column based upon categorization in another column
  169. [SOLVED] Counts
  170. Counting system
  171. Start count over after blank cell
  172. Averageif in Excel 2003
  173. External reference with variable filenames
  174. Counting Number of Instances with Conditions
  175. [SOLVED] SumIf question
  176. [SOLVED] finding 10 smallest unique values in a list
  177. [SOLVED] Conditional Formatting Multiple Rules
  178. [SOLVED] Cell References inside a LINK
  179. [SOLVED] Can I copy the names of the tabs to cells in a worksheet?
  180. The impossible pull down menu!!!
  181. What Function for retreiving data that matches a text in a col
  182. Formula affecting two columns
  183. IF statement that looks at date values in 2 cells
  184. Help with INDEX
  185. formula logic
  186. Data Search & Adjustment
  187. Match and return
  188. [SOLVED] Conditional grey-out and disabling of cells
  189. Get Cell Ref from One Formula and use in another?
  190. Fatal error: Allowed memory size
  191. Variable Cell Range
  192. countif function
  193. What excel function to use to generate some words with a certain frequency?
  194. SUMPRODUCT - 3 criteria - OR?
  195. Find highest number in a row
  196. Collating Workbooks
  197. Finding first number smaller than set value
  198. Fill Series of Disjointed Selection across Rows & Columns?
  199. Grouping by Column
  200. sorting data using a common factor
  201. string to hexadecimal?
  202. [SOLVED] If statement within If statement
  203. Array Formula not working
  204. Change color of pie in a graph based on cell value
  205. add simultaneously monthly values to get quarterly values
  206. MIRR discrepency monthly vs annual
  207. Summing across multiple worksheets with criteria
  208. [SOLVED] Conditional Formula
  209. [SOLVED] countif with date
  210. Total IF Value equals "Yes" ?
  211. lookup and output ?
  212. If statement
  213. Self-calculating timesheets!
  214. Nascar Game for old men
  215. insert characters
  216. [SOLVED] Trying to get legend along with the result of a formula
  217. Sumproduct formula not giving expected results
  218. Moving cell refs
  219. Averaging nested countif?
  220. [SOLVED] Help regarding cumulative sums
  221. 24 Hour + More hours without resetting
  222. Compare two columns and add third column based on matches
  223. Creating multiple rown in single cell from multiple columns
  224. [SOLVED] Function: List dates in increments of 6 hours...!!
  225. Combining COUNTIF and OR won't work
  226. How to show a number of most recent entries
  227. Merge 2 Worksheets; One Common Field
  228. Copying Text Right of Specific Character
  229. Pulling Specific data that meet certain criteria from main workbook into new workbook
  230. Formula to display end of week
  231. Formula to find day number of year
  232. Using array to sum by multiple criteria including one based on prefix
  233. sumproduct formula with text
  234. dynamic formulas
  235. Defined Names - choose which one to use
  236. [SOLVED] Link to specific cell in preceeding row!
  237. [SOLVED] Cell formatting
  238. Checking if multiple cells are blank
  239. SumIf or Vlookup on multiple sheets at once
  240. fimding multiple records that match specific criteria
  241. SUMPRODUCT to exclude values?
  242. [SOLVED] Consolidating multiple worksheets
  243. Lookup Function
  244. IF Function does not work
  245. Removing Div#/0 from with Function check
  246. Named Ranges question
  247. How can I make this Pace formula neater?
  248. Cells don't properly update
  249. Changing the text color in a formula
  250. entring a formula that says Parameters Complete