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. VLOOKUP / INDEX / MATCH problem
  2. <Resolved> Mconcatenation
  3. Applying Conditional Formatting to Data Validation
  4. Function for grades
  5. sorting and look up question
  6. Simplification of Multiple IF conditions!
  7. employee time sheet hours
  8. NA Solution
  9. find values exists in sheet
  10. employee retirement plan
  11. How do I create a formula to return a blank cell if false?
  12. More than one thing in a Cell
  13. A Name not a Number
  14. vlookup link between sheets
  15. changing images to symbols
  16. Trendline for a section of data
  17. vlookup and compare
  18. Colour Fill cell range in (Conditional formatting XL2007)
  19. sum of " agnet codes " in a pivot table
  20. ARRAY or IF FORMULA to copy data !
  21. Row Number to Cell Content
  22. indirect not working
  23. index and match
  24. Count if on 2 different rows
  25. Trying to figure out some budget calculations and formatting?
  26. IF statements and their alternatives
  27. create url from text in three different cells
  28. Combining 2 sheets of data to 1 sheet w/sorting
  29. SUMIF Function?
  30. Sumif or Sum Product ?
  31. Vlookup on 3000+ Rows
  32. Count every other cell
  33. Sum of wages for the year with varying start dates
  34. Absolute cell references
  35. How to count instances of time categorized by hour
  36. Cell Copy and Paste to another cell, opposite sign (+/-)
  37. Replication of polynomial equation in formula
  38. Compare 2 sheets based on criteria
  39. number value
  40. comparing 2 columns
  41. Only numbers and letters
  42. Retaining Leading Zeros when pasted from web
  43. Formulas that reference the values
  44. Copy Formulas
  45. Resolved >>> summing amounts corresponding to variable date ranges
  46. Counting Occurance
  47. If and lookup query
  48. Finite Field Arithmetic
  49. Check Book Register Formula
  50. Automated formatting from basic Excel to fancy Excel!
  51. Resolved >>> Conditional formatting issue?
  52. Another Ebay Calculation
  53. Resolved >>> Sum only unfiltered columns
  54. #NAME error
  55. IF cell is red
  56. Duplication of a List
  57. Resolved >>> Number of consecutive first values
  58. Resolved >>> Sumproduct calculate excluding errors
  59. <Resolved> Oldest Dates Lookup
  60. Create a conditional sequence????
  61. stacked data excel formula
  62. Adding a new autoformat
  63. Question on If else functions
  64. Showing average on line graph
  65. return a blank when there is text using if function
  66. Way to put functions in first and then data afterwards?
  67. Top 5 values using LARGE and INDEX avoiding duplicates
  68. Dynamic Worksheets
  69. Optimizing Revenue
  70. Control Box as Hyperlink
  71. impossible to obtain a correct sorting
  72. Averaging between reference cells
  73. Resolved >>> error query
  74. Resolved >>> Nested Ifs combined in 1 cell
  75. Conditional Formatting
  76. Resolved >>> Subtotal with condition
  77. Extracting Duplicate Email Addresses from Same Cell
  78. Resolved >>> If then Statements
  79. Populate corperate worksheet
  80. Show zero if value less than zero
  81. <Resolved> sumif issue
  82. Networkdays
  83. Sending an automatic email from a spreadsheet
  84. simple addition
  85. Linking a Worksheet Title to a Cell and Other Problems
  86. SUMPRODUCT issue
  87. <Resolved> conditional formating
  88. Repeat Function for editing mulitple cells
  89. Getting a picture/object to only appear if condition is met?
  90. <Resolved> Calendar Formula
  91. Subtracting date and time
  92. Counting if criteria is met
  93. Array Formula - Calculating Staff Numbers
  94. Error With Multiple Matches
  95. Auto filling from 1 sheet to a 2nd..
  96. Sorting values from two columns into one catagory
  97. Solver and Equation issue
  98. Indirect - combine two cells to look up sheet name for formula
  99. Duplicating info in another worksheet
  100. Automatic Live Data Updates
  101. Conditional COUNTIF
  102. Resolved >>> Time Formula w/o colons
  103. Resolved >>> Sumproduct with more than one condition
  104. Resolved >>> Filter a Hidden Column
  105. Resolved >>> Sumif
  106. Vlookup formula with multiple sheets
  107. Resolved >>> Conditional Formatting Issue-Bolding lowest value in EACH ROW
  108. Check if Sku in column D is in A.
  109. Resolved >>> Increment date by a year
  110. Resolved >>> Find the top result for each category
  111. summing averages of paired data
  112. How to dedupe records with different segment codes
  113. Resolved >>> Date formula
  114. using Max() with #N/A values
  115. countif using 2 variables
  116. Rating System Auto-Update?
  117. Match or find text in part of a cell
  118. search a table
  119. Summing a moving range
  120. Resolved >>> formating color if
  121. Resolved >>> Matching Or Indexing Problem
  122. Resolved >>> Increasing a cell value by +1 every day
  123. Conditional formatting problem
  124. Data formula
  125. countif problem
  126. download info from website
  127. Transfer data to another workbook
  128. Searching right to left for a differing value
  129. cells not updating
  130. Use name cell in formula
  131. shortcut to insert custom text
  132. copying selected text from one column to another
  133. inserting rows when refreshing external data
  134. result of vlookup = #N/A, how to replace it by "0"
  135. <Resolved> calling the min row to another row
  136. Resolved >> Play a sound when a cell equals a certain value
  137. What is not in "LOOKUP" array.
  138. Resolved >>> Conditional formatting with INDIRECT and AND
  139. Transfering (copy/paste) Tables
  140. VLOOKUP or something else
  141. Copy cell contents and formatting
  142. Always displaying the last cell in another column
  143. Trace Precedent and Dependent Cells
  144. VLookup Fuctions
  145. Disassociate a function in the table
  146. Create a workbook reference
  147. How to apply a tick in excel
  148. Formula Reference Cells & Ungroup worksheet
  149. Solved - rounddown function
  150. Making Cell referances absolute changes the result
  151. Create a PivotTable
  152. Insert Subtotals Command
  153. Vlookup search within a cell if the lookup_value is not in the same order as the arr
  154. data/statistic analysis
  155. Stop new cells from copying format of other cells in the row?
  156. Calculating Percentage of Data in Column
  157. Comparing Customer Lists
  158. vlook up increment column number with auto fill
  159. Resolved >>> Obtaining Average Question
  160. Different royalty rate depending in unit sales
  161. Custome AutoFilter
  162. copying formula into another sheet as number
  163. trying to get rid of formula error messages
  164. Countif or sum product?
  165. Sorting Function
  166. Matching
  167. Resolved >>> Using #VALUE! in a logical statement
  168. Mileage lookup
  169. Filtering issue
  170. numerator, denominator functions?
  171. match with multiple criteria that's externally linked
  172. merging and consolidating two data sets
  173. Merging non-numerical data onto a master sheet
  174. If Fuction with an absolute reference
  175. Excel Formula to count past due dates
  176. excell spread sheet adding rows
  177. Counting specific cell pairings
  178. Resolved >>> Max Index Lookup Returning Two Cells?
  179. Conditonal Format Odd or Even Numbers
  180. Relative and Absolute to create an average/year
  181. returning offset results with a lookup formula
  182. More than 7 If functions
  183. Creating a Purchase Order
  184. Adapt if lookup query to work with percentages as opposed to numbers
  185. Disable AutoFilter function for specific rows
  186. Complex Lookup
  187. Push Button With Input Box For Specific Data
  188. commission payscale formula
  189. delete carriage returns from fields in column
  190. link cells between sheets?
  191. VLOOKUP return column from different sheet
  192. Limit formula to 1st date value
  193. Using formulas in cells
  194. vlookup cell reference
  195. externally linked spreadsheets
  196. Ctrl Shift Enter
  197. Display Negative Numbers as 0
  198. Extracting numbers from a cell
  199. Number format in a concatenated formula
  200. Sort conditional formatting
  201. currency format in a formula using text
  202. Compare and Replace with Correct!
  203. using if function with multiple choices
  204. average monthly costs for the past three months and forcast by 1%
  205. Formula to bring back result with soft return
  206. return a value based on cell background color
  207. Lookup both text and numbers
  208. Lookup value in a table and return muliple contiguous cells from a row
  209. If without else possible?
  210. Search for duplicate record in 2 excel spread sheet
  211. IF function
  212. automaticaly sort selected contents on worksheet to seperate worksheet
  213. Calculate week difference between different years
  214. different colour fonts in a drop down list?
  215. Error in calculating seconds function
  216. counting matches in multiple columns
  217. "IF" statement
  218. Minimum and VLOOKUP w/ errors
  219. How to get data from several workbooks without opening them
  220. Sum If And
  221. Splitting columns
  222. IF function #value! error
  223. COUNTIF Function?
  224. Counting quantified duplicates?
  225. combination of ifsum and indirect, or something else?
  226. Formatting problem...
  227. Macro to copy a worksheet new
  228. Moving text thats hyperlinked
  229. Excel and HTML
  230. cell format error (Excel 2003)
  231. Nested Lookup Function
  232. SUM for a specific range
  233. Insert hyphens in number or letter strings
  234. Concatenate blank spaces
  235. Return an array of numbers
  236. Resolved >>> Pulling From Another Sheet and Sumproduct and TEXT
  237. conditional formula
  238. Finding the minimum for each group
  239. How do I validate the time?
  240. DSUM for rows
  241. If statement containing two calculations
  242. Merging data from several spreadsheets
  243. Vlookup to compare cells
  244. Lock a cell
  245. VLOOKUP or IF?
  246. 26 IF workarounds
  247. Concatenate text w/ a percentage
  248. VLOOKUP to the left
  249. Sum columns based on 3 criteria, where the column summed is dynamic!
  250. trouble with formula filling