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. search & if functions
  2. Creating Text Hyperlinks - why does my link icon gray out?
  3. if statements
  4. Summing values based on two criteria
  5. Move and Delete
  6. Ignoring #DIV/O! in averages
  7. Conditional Formatting
  8. Countif
  9. Count <>0 in Pivot Table from a DW
  10. Countif
  11. Totaling Revenue based on Source
  12. Lookups
  13. Advance conditional formatting
  14. Sumif with various criteria?
  15. Date Function
  16. Tab into and out of a Combo box
  17. Trouble with " = " formula
  18. Index Match
  19. Creating a "Calculate Now" button.
  20. Satifying 2 criteria...then return a value
  21. Summing a column from the bottom up
  22. if then formula using integer statement
  23. Adding numbers in a range within a cell
  24. What is the interest rate?
  25. Sumproduct alternatives
  26. Entering data once, have it appear 2ce
  27. Formula for creating permit fees.
  28. data validation list
  29. Sum if multiple conditions fit
  30. #REF errors
  31. Weekday Date()
  32. Formula for percentage
  33. Extract repeated words from Text string
  34. Count words between a certain criteria
  35. Formula
  36. Percentage Function?
  37. lookup with multiple criteria
  38. Vlookup, match, conditional formatting?
  39. Counting Based Multiple Criteria using Wildcard
  40. Import from MySQL Problem
  41. Converting Dates problem
  42. Formula lock down
  43. converting date problem and eliminate century
  44. Cell Color Association
  45. Selecting One Number From Each Row/Column to Maximize Value
  46. Array question
  47. countif
  48. Conditional adding
  49. Formula with adjustable absolute address
  50. Extreme Oddity - w/ Day Calculations (DAYS360)
  51. 4 criteria lookup formulae
  52. Odd Need
  53. if ... and ...
  54. use cell to ref a rab
  55. resetting form to start position?
  56. non-array formula with multiple lookups
  57. Automatically insert a STATIC date/time if data in adjacent cell
  58. Wrap Text - shortcut / toolbar / autoformat?
  59. Pivot Table?
  60. Average every 10 readings
  61. To get total for several rows and to sort by first column?
  62. Count unique + filter
  63. Fixed title row
  64. Gridlines in Pivot Reports
  65. Formula for # of days past due
  66. Sumif
  67. Merge 2 XLS files into 1
  68. PMT function
  69. How to compare times?
  70. IF & VLOOKUP formula
  71. Formula
  72. searching a function
  73. Count
  74. If formula
  75. Udfs and Description
  76. Vlookup
  77. Identify active worksheet in macro
  78. Vlookup or Index
  79. Merge Cells
  80. Time sheet
  81. Removing characters from a cell
  82. if statement
  83. percent of times data shows in a column
  84. Another Function Besides =DEGREES
  85. Selecting only cells with text values in CAPS
  86. Finding last occurance as Non-array formula?
  87. Enter data in a formula cell
  88. Getting error on exceeding some specific limit char
  89. Data Validation bug in Excel
  90. IF & ROUNDUP functions
  91. A paperwork issuing program
  92. Formula size limit?
  93. COUNTIF function per month
  94. Multiple Check Boxes
  95. Running macros in Excel97 that was created in Excel XP
  96. Find first blank cell in range
  97. Creating a Function
  98. Username formula
  99. Tab to next textbox
  100. Financial year is 2006-2007
  101. Adjust multiple values to equal 100%
  102. calculate the time
  103. Ignore #NA In A Sum
  104. VLookup Question
  105. Extract text from cells?
  106. Row Insertion Problem
  107. Sumif ?
  108. Insert Carriage Return in Formula
  109. Changing the order of a list
  110. Adding Military time formula
  111. create entry form
  112. Calculated Reimbursement for total month
  113. Show as text, but enter number
  114. Text
  115. Lookup Function
  116. excel worksheet copy formula
  117. Next Date
  118. Formula to handle cells with unicode needed
  119. SUMIF question
  120. Formula & Result in same cell
  121. Combining COUNTIF statements with different criteria
  122. nesting more than 7 functions
  123. Find, return string address in a range of cells with numbers and text
  124. how to recognize letters before a number in a cell
  125. XY dispersion
  126. Excel worksheet with 5 data validated columns brings performance to a crawl. Why?
  127. Polynomial Equation?
  128. minus 30 minutes for lunch
  129. sum (add) every consecutive N cells in a column
  130. auto update formula, linking formula
  131. Creating function to find and format/fill
  132. Calculate total time worked from signing in and signing out
  133. Locked - Posting on two forums >> Min Value & If Statements.
  134. More Than 3 Condetion Format
  135. Sort by function
  136. Conditional Formatting Formula
  137. Counting list, while checking for criteria
  138. CountIF Function for dates
  139. Countif with two conditions
  140. Testing same cell across multiple sheets for a string and counting each instance?
  141. Reversed Conditional Formating
  142. Vlookup
  143. keeping cells blank
  144. Last business day of month function +1,2,3,4 business days
  145. Vlookup using multiple worksheets
  146. Format and colors of rows are changing, when copying from one workbook to other.
  147. Lookup
  148. Copy links to automatically change
  149. Create Summary from Table
  150. Pulling data foward to the front sheet.
  151. Programing Cell
  152. Cell value as Sheet name reference in formulas
  153. Prime numbers
  154. VLOOKUP and OFFSET
  155. How to "return the last value entered in a column"?
  156. backwards dates
  157. Creating Complex Formulas
  158. Linking simular product codes with vlookup?
  159. Grading question
  160. Restricting Scroll Area
  161. Lookup function
  162. Insert-Range
  163. SUM(ColB Where ColA=y)
  164. Counting
  165. formulas and rows being added
  166. If, Isblank, ???
  167. Convert decimal number to time format
  168. Counta
  169. Array Problem
  170. If function for just the begining
  171. Date/Time
  172. Countblank
  173. Overdue / Late Docs
  174. Using VLOOKUP across multiple rows..
  175. Traceability Matrix Generation
  176. square times and display correctly
  177. Update Row or Add Row if empty.
  178. Associating values from another worksheet
  179. Adding up 45 days worth of money
  180. From Word to Excel
  181. Sort by groups
  182. How to use text to columns with a vertical bar as the delimiter?
  183. Advanced use of the ADDRESS function
  184. grouping data?
  185. How do I get rid of an annoying flag?
  186. Designing a formula to calculate western Union fees and shipping costs
  187. Find cell address within a table?
  188. values in worksheets
  189. Summing Time
  190. Using a lookup based upon cell attributes
  191. Static time and date stamp
  192. copy info to new worksheet
  193. Entering .5 pence & Rounding Up
  194. Conditional format 3 columns some with 0's
  195. Sum of one cell
  196. Return Value Depending On Month
  197. Table Question
  198. today's date question
  199. Linking a series of cells to a row
  200. How do I assign a letter to a weekday
  201. Text vs Number when using lookup table of numbers
  202. date conversion
  203. Subtotal Formatting
  204. Vlookup & offset
  205. Headers
  206. Date
  207. Named range lookup using Index and match
  208. =left?
  209. #N/A woes...
  210. Grouping
  211. On time event
  212. multiply and round in one equation
  213. Deleting parts of text from within a cell automatically
  214. Ranking
  215. Array formula
  216. 100 + 14% = 114
  217. Vlookup string print new "ORDER"
  218. Help with tedious data entry in Excel
  219. vlookup with two columns?
  220. IF Function based on many criteria
  221. Viewing worksheets on seperate monitors
  222. #dIV/0 Function or macro
  223. Select Distinct Case From Sheet
  224. Possible Combinations Of A Given Set Of Numbers??
  225. Combine data
  226. Financial Formula
  227. Row of numbers - need to average w/ grade letter
  228. Managed to get a wider-than-column dropdown list, but can't reproduce how ...
  229. Sumif() question
  230. Nesting more than 7 ifs...another way?
  231. Double Declining Balance
  232. Top 8
  233. Adding values from sheets to sheet
  234. Excel Timesheet
  235. Removing cells based on adjacent blanks
  236. Not counting blank cells
  237. increasing dates by number of months
  238. Excel template on sheet1 save to sheet2
  239. Linking Data in diff worksheets
  240. summarizing
  241. Daily Averages
  242. Creating Rows with Counts
  243. Line break using Concatenate
  244. copy with conditions
  245. Formula to insert a check mark
  246. vlookup misbehaving
  247. Colour display
  248. Finding the total number of matches within two columns?
  249. display content of a cell with conditions
  250. Countif