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. Column A by Column B, for entire worksheet
  2. count the amount of time a combination of events occur
  3. Vlookup
  4. Get data from every 4th row
  5. How to select every nth row?
  6. Sorting in a Column & Totaling Question
  7. Conditional Formating
  8. Vlookup problem
  9. Sumproduct Question
  10. IF or SUMIF possibly?
  11. Sumproduct Problem - sum all the values in a column given value error
  12. Advance Filter
  13. Weighted Functions in Excel
  14. Count using criteria
  15. Calculate Productivity
  16. Translate English to Hmong in Excel?
  17. strange looking brackets
  18. Referencing a file name
  19. Vlookup if two cell Match
  20. tabs within tabs
  21. Standard deviation calculations with excel
  22. Copy values from multiple worksheets onto one master sheet
  23. two different conditional formulas using the same data set and cells
  24. Proper Use of VLOOKUP
  25. IF A date between x&y dates return date B
  26. Function
  27. Select adjacent value
  28. Use Cell Contents as name in Formula
  29. Database Date Problem
  30. Average of Percentage on a Sumary Page
  31. sumproduct with horizontal line
  32. Trying to create a time/pay chart in excel...
  33. Calculate Discrete Averages, not rolling
  34. Formula with multiple if statement
  35. How to use the MIN formular in a list of non unique records
  36. COUNTIF? Date Function
  37. divisible if statements
  38. Modify Sumproduct to include helper column
  39. inventory code?
  40. Copy cells from a sheet to a new workbook
  41. simple lookup or match?
  42. VALUE OF cell
  43. Tax Formula
  44. merging
  45. Looking up values in a table
  46. Auto-extraction from 'Master' sheet to another worksheet
  47. Converting existing formula to WORKDAY
  48. Text problem
  49. Creating a list of names
  50. If commands based on cell value
  51. Using the "substitute" function
  52. Vlookup issue
  53. IF and VLookup formula
  54. Adding to the total only if that cell contains data
  55. Copying Information to a new sheet if it meets a certain requirement
  56. Add by increments of 8 for temp change
  57. Sumif with 2 conditions
  58. rounding up from zero
  59. move worksheet / macros
  60. Vlookup - Words with different spelling
  61. SumProduct/CountIf/Duplicate
  62. If + Year function?
  63. calculating labor costs using an employee schedule
  64. copy the contents of one cell to another one
  65. keeping the function in a particular cell but changing color based on another cell
  66. Using Custom Number Format
  67. Auto-updating cell evaluated by date
  68. Time Date Stamp
  69. MACRO - Alphabetical order..
  70. Count Unique values with vlookup
  71. count if with an OR
  72. AND IF Statement??? Not sure the formula to use
  73. Summing CountIF's across noncongruous ranges
  74. Indirect(Adress and specific sheet
  75. Count range
  76. calculating time to go a set distance
  77. Always making the date the previous sunday.
  78. Replacing : with ,
  79. return cell address
  80. Moving a sum formula down a row
  81. Data Validation between closed workbook
  82. Summing multiple sets
  83. Worksheet names as variables
  84. Using Cell Reference in SUMIF
  85. Spliting formula...
  86. Converting 3 formulas into one answer
  87. Taking last value in a data set to enter on another work sheet?
  88. Vlookup question
  89. Sum Column based on Ajacent Column
  90. Hide Sheets - Maco won't work!
  91. list values in one column based upon value of another
  92. vlookup
  93. Basic formula, big problem
  94. Subtotal Controls
  95. trying to add times with Sumif-
  96. Pivot Table - variable date
  97. how do you count the number of thursday from whole month of April 2007
  98. 2nd. argument (Optional ) in COUNTA() function
  99. Vehicle Age
  100. Match or Look up
  101. Convert Date Value to Actual Date
  102. Random List Selection w/No Duplicates
  103. Updating Multiple Sheets
  104. Lookup formula with multiple tables or range names
  105. Convert formulas in text into formulas
  106. Set Row and Column widths to make cell into a Square shape
  107. How to protect Formula, but not cell
  108. insert alternating columns and rows
  109. calculate ETA's to a country basis departing another
  110. MIN and MAX with Named Ranges
  111. SUMPRODUCT and Wildcards
  112. countif function
  113. non-contiguous cells
  114. Summing Unique Values from 4 Columns
  115. excel to return a Sheet name...
  116. Multiple conditions
  117. Replace words with another word
  118. Replace 0s with blanks - IF statement
  119. Matching a value to a list of values
  120. Nesting IF function
  121. SUMIF and lookup function to combine data
  122. Problem with Vlookup function
  123. IF statement?
  124. Auto Increments - in text and formulas
  125. Counting mutliple text entries in cell
  126. leave calculator. Only 3 cells
  127. negative values in cells
  128. COUNTIF function..
  129. Find the last occurance of an item
  130. Auto-Enter list into cell and record if cell meets various criteria automatically?
  131. Subtotal, Sumif Only Showing Visible
  132. Formuals within text
  133. Function to return the value in cell above
  134. Sum Based On Partial Name
  135. Ending a formula, based on condition...
  136. formula to make a box a color...
  137. security for formulas
  138. Sorting Time of Day in Column
  139. how can i auto insert a new row......
  140. Conditional Format a string of cells that begin before today & end after today
  141. IF Function - Multiple Conditions
  142. Vlookup with more than one result
  143. Add more functionality to Index formula
  144. VLookup Function
  145. If >,<, or = number functions
  146. Lookup in another worksheet
  147. Stuck creating stock worksheet
  148. Pull Down boxes and Tables
  149. Rounding
  150. assigning totals
  151. Another Question
  152. DELETING Date/Time
  153. Syntax issues with the OR function
  154. sum a range of cells that meet one criteria
  155. Returning Cell reference
  156. Random List Selection w/No Duplicates
  157. lookup problems
  158. pairing up data in two columns
  159. MAX function
  160. Date Extraction
  161. Copy Data From Protected Workbook
  162. Replacing numbers with text?
  163. SUMIF with dynamic criteria
  164. Validation Trouble
  165. How do i copy the data instead of the formulas?
  166. Formula to calculate number of cells with same data
  167. Refresh List Boxes
  168. Calculating Taxable Social Security Benefits
  169. Strip data from a cell
  170. Using values in ADDRESS function
  171. Mode Function
  172. If formula too long
  173. formula help neededmarkup all of the prices by 20%
  174. Automated input based on reference list
  175. determining range
  176. Filling a table
  177. Counting even/odd rows with countif
  178. Radio Button % values
  179. Calculate commission - IF AND ??
  180. Dependant? Data Validation
  181. IF formula based on multiple ranges??
  182. Column Step Function??
  183. Locate cell position for max value in column
  184. Matching two spreadsheets for Similar Words
  185. Wildcard incorrect?
  186. Commission PER Invoice
  187. Month Calculation
  188. Hyperlinking to other workbooks
  189. Finding items in column which are NOT in a given list
  190. Breakdate/anniversary calendar
  191. Range Lookup Value
  192. Using dates in formulas ?
  193. IF function anomaly
  194. Date copy
  195. WORKDAY function
  196. removing part text string with a formula
  197. How to count a combination of two items
  198. sumif/sumproduct
  199. IF formula based on two other cell values
  200. Index-Match Function Not Working all the time
  201. Conditional Formatting whole column
  202. Formula Cell Entry
  203. Filtering multiple columns
  204. Formula to create age
  205. Connecting cells together
  206. Sum across all sheets
  207. Array Formula
  208. counting cells in a column that match cells in another column
  209. lookup formula?
  210. Names In Formulas Not Working
  211. how to add decimal
  212. Figuring Lapse Time
  213. VLOOKUP confusion
  214. Excel sum formula (two criteria)
  215. Defining cell ranges by interactive drop-down?
  216. Interactive features: click, something happens
  217. Moving Data Between Workseets
  218. use each digit 1-9 only once each
  219. Turning Text into a Formula
  220. weeknum() flawed
  221. Drop down menu???
  222. Average functions with more than one referenced condition
  223. STRANGE look up
  224. Sum on row and column criteria
  225. Using binary in solver
  226. Average If nesting
  227. WEEKDAY(TODAY()) function
  228. look/match to return resuts from multiple rows
  229. copying data between sheets
  230. Formula for figuring out the sum in a range of cells where you only need the 1st
  231. Preventing Excel from changing the cells when copying WITHOUT using $
  232. Copy formula down rows based on pattern
  233. Linking data from another workbook
  234. Alternative to INDIRECT with Dependent Lists
  235. Re: Solver
  236. Displaying text in functions
  237. roadway station format
  238. cells not updating
  239. Referencing part of a cell
  240. Using If Statement for Zip Code
  241. MAX Function - Changing Range
  242. Criteria met in cel goto URL...
  243. Avoiding Error Displays
  244. Sumif with 2 ranges of criteria
  245. SUMIF - add values from one column based on values in two other columns
  246. Autofilter Problem?
  247. Log Equation does not work right
  248. Using functions to select dynamic ranges
  249. Reformating a matrix
  250. Add Years?