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. freezing formulas
  2. freezing formulas
  3. Count dates falling in a certain range
  4. excel-How many macros can one spread sheet have
  5. Count Unique Values with Multiple Criteria
  6. present value function
  7. maturity schedule fixed inc securities by month, quarter and year
  8. New text added to cell AFTER current text in same cell
  9. Display a "0" when #N/A appears in formula
  10. Find & Replace woes
  11. Matching Text with With Certain Criteria
  12. Truning 0 vaules red
  13. Turning 0.000 values red
  14. Date (hours and still counting)
  15. How do I sum a date specific range of cells?
  16. IF statement including BETWEEN
  17. Is there a way to return records?
  18. Converting a GIF or JPG into Excel
  19. not sure how to proceed
  20. Formulas that refer to (several) other columns for arguments...
  21. Delete every other row.
  22. Grouping Similar items
  23. How do you make an graph containing an algerbrica formula?
  24. How to COUNTIF blank cells?
  25. Using Cell Variables to Specify Cell Range
  26. HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA
  27. Where is the link???
  28. Can a formula ignore empty cells?
  29. CF ROWS
  30. delete unused columns and grey out the rest area
  31. Concantenate Help
  32. RE: If statement to find NA()
  33. how do i create a drop down list of items from a different file
  34. Copy/Paste Drop Down List
  35. Replacing Colored Items with Tags
  36. If statement to find NA()
  37. Remove green mark upper left several cells Excel?
  38. VLOOKUP should compare numbers stored as text to plain numbers.
  39. Add decimal years to a date
  40. Combining functions
  41. formula using up 2 10 cells of $ 2 seperate & = $ amt
  42. Matching Subtotals
  43. Deleting contents of cells in non contiguous ranges
  44. combining 2 dates into 1 cell
  45. OFFSET to include blank cells
  46. copy/Paste references other worksheet
  47. Changing file default
  48. >@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
  49. Counting text in multiple cells.
  50. <><><><><><><>The Net's #1 Joke e-Book!<><><><><><><><>
  51. inventory comparison formula??
  52. Empty Cells
  53. Using IF function for inbetween cell values
  54. "workinghours"
  55. Please explain
  56. Text Time Conversion Calculation
  57. How to Calculate ANTILOG in EXCEL SHEET?
  58. How do i add to information to microsoft exel worksheet
  59. Format Numbers
  60. Crazy discount !!!
  61. Upper case to Lower case
  62. =IF(ISERROR(SEARCH("insurance",A125,1)),"","*")
  63. How do I extract data from every other cell in a colomn?
  64. sumif from activeX control
  65. Keeping pictures with data
  66. EOMONTH error
  67. >@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
  68. Amnesty for illegal immigrants will not happen this time.....................
  69. Excel not calculating formulas
  70. Illegal Immigration, the Non-Issue of the Week??????????????
  71. How to have Excel Fill In Data in Column based on another columns
  72. Help writing an IF statement
  73. problem with checkbox control
  74. charts
  75. How do I sum values returned from functions?
  76. Transposing Data using Offset function
  77. Finding Text To Copy To Another Worksheet
  78. Help creating formula
  79. count only visible cells
  80. Lookup problem
  81. Clearing associated dropdown fields
  82. Cannot do calculations with numbers?
  83. Formulas for Time Sheets
  84. how do i do this - increment month by 1
  85. How to use lookup to retrieve next LARGEST value?
  86. Updating formulas
  87. Lookup based on range of dates
  88. combining multiple rows of data into one single row of data
  89. SUM of a variable range of fields
  90. searching multiple worksheets
  91. place text in one cell
  92. Entering a hyphen into a cell
  93. Sorting Parent Child
  94. data entry problems
  95. Score a list of numbers
  96. Drop-down list Populated by a Subset of a larger list
  97. rather complex logic statement
  98. #VALUE Help
  99. Convert excel spreadsheet into crystal report
  100. Does broken down functions calc faster?
  101. Does broken down functions calc faster?
  102. Does broken down functions calc faster?
  103. Need help with a dynamic lookup and logical formula
  104. VBA Help
  105. get the last number from the row
  106. How to reference a worksheet name
  107. Changing Cell References To a Different Worksheet in the Same Cell
  108. Extracting text from text string
  109. Vlookup? help.
  110. How do I print 1/3 cut Folder Labels from Excel
  111. Auto-delete Unbolded Cells
  112. WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?
  113. Calculating Per Diem Rates
  114. Formulas that refer to other colums for arguments?
  115. use data in a cell in a formula
  116. If the cell contains..., do something (2)
  117. Automatic Saved Date
  118. Advanced Lookup (lookup for 2 values)
  119. Data overflow to second worksheet
  120. How do I assign a unique ID number to an invoice sheet I created?
  121. How do I calculate grades from excell
  122. how to do a wookbook with sheets and subsheets?
  123. How do I print my excel contact sheet into avery labels
  124. Use array to return array of values
  125. Conditional formatting of text in a shared workbook.
  126. Combining Text from 2 Columns into 1 then Deleting the 2 Columns
  127. merge text from 2 columns into 1 then delete the old 2 columns
  128. Sort a Spreasheet by Color Highlights?
  129. FLOWCHARTS
  130. Need to use if statement with drop down lists has this been done
  131. Password\Backup
  132. If statement with Vlookup
  133. Excel 2003 index function does not calculate
  134. sum sub levels.
  135. Offset VLookup
  136. How do I make all columns in a range in a worksheet the same width
  137. Function for an object
  138. Don't print a specific cell
  139. Import a word document
  140. need help accessing other cells within a function
  141. Hlookup, how di I get it to return more than one cell
  142. Identifying Duplicates in Columns
  143. Help with a formula
  144. In Cell Layout
  145. Combining IF AND & FIND Functions
  146. ADDRESS
  147. How do i cross reference two excel spreadsheets?
  148. How do i cross reference two excel spreadsheets?
  149. Comments/Warning fields
  150. how can I perform trig. functions usings grads 400deg per circle
  151. Hyperlink failed
  152. Transposing + Absolute Reference + Multiple Worksheets = my headache
  153. validation and further
  154. how do i slide months of data under my first column?
  155. How to get time to update automatically and continuos
  156. do I need array formula or sumproduct for counting?
  157. FOrgot Password
  158. formula accross cells..when inserting a row..
  159. hlookup function
  160. Conditional formatting - Find common material
  161. Converting cost price to retail in vast array
  162. Help with a blank cell warning
  163. I Have No Idea How To Do Or Title This!
  164. Validation - clear blanks from drop down
  165. Keep text filter away numbers
  166. How do I hide and unhide the same columns without reselecting
  167. Excel 2003 Simply Stopped Working
  168. find largest value cell acrss worksheets
  169. Using IF function
  170. please help how to combine IF function with Countif function
  171. 1900 not a leap year
  172. Variable Determines Number of Cell in Formula Range
  173. Sports Comp Ladder tabulating help needed
  174. NORMDIST function
  175. Count Formula Problem
  176. Conditional Formatting: Formula is
  177. How do I get an excel field to 'prompt' me to add a number to mul.
  178. How do I make items repeat on a pivot table?
  179. average data from diff sheets
  180. Problem with paste
  181. Counting Words
  182. List of data available for each cell within a coulmn
  183. Returning Cell Value if someone deletes the contents of a cell
  184. adding digits of a number
  185. Need help with concatenate formula
  186. reverse principle calculation
  187. Leave existing data in a cell alone
  188. updating separate spreadsheets
  189. Need help with concatenate formula
  190. change the case of all the text in a coloumn
  191. How do I get rid of FALSE, #VALUE!, ###, in cells?
  192. formulas in worksheets/workbooks
  193. remove conditional format
  194. How do I sum text cells with number cells?
  195. Rehide Sheet in macro.
  196. group counter in excell
  197. dollars/cents multiplied by hours/minutes or tenths
  198. Auto sort
  199. How to apply a formula to all cells in a column
  200. Custom Function not updating
  201. Custom Function not updating
  202. N/A return
  203. Conditional Formatting for a range situation
  204. Standard deviation - confidence intervals
  205. Flagging constants
  206. importing multiple .dat files!
  207. Receive #VALUE! when I mix text with dates using SUMPRODUCT
  208. cell references
  209. Conditional Rounding
  210. Formulae for Tolerence
  211. How do I make an IF statement change cell shading
  212. a text array formula
  213. Easy question for you, but hard for me.
  214. when using find I want the box in excel to be highlighted
  215. Sum/average numbers in column A dependant on value in column B
  216. Automate Copy / PasteSpecial
  217. Why does my formula in Excell return a #N/A?
  218. Different ranges in formula
  219. saveto or Submit Form functionality in Excel
  220. Apply a formula as a pivot table calc or suggestion
  221. INSIDER - KNOWLEDGE NEUTRALIZING!!
  222. INSIDER - KNOWLEDGE NEUTRALIZING!!
  223. Convert Lats and longs to decimals
  224. #DIV/0! Errors
  225. formula help: calculate length of employment
  226. Emailing Macro
  227. How can I count conditional blank cells?
  228. How do you make information from one worksheet feed to another?
  229. Help with Countif
  230. NETWORKDAYS FUNCTION, Help please
  231. NETWORKDAYS FUNCTION, Help please
  232. if statements, and statements
  233. To Protect Excel documents and allowing only few cells to edit
  234. control limit
  235. Countif, Match or Sumif Formula
  236. Function for upper and lower control limits?
  237. Conditional Format as a MACRO
  238. Automatic colouring of cells
  239. Re: Loop time seems dependent on unrelated workbook - Why?
  240. Please Help
  241. UK Excel User Conference - July 19-21
  242. Copying Cells
  243. Working Hours (formula & graph) - any elegant solution?
  244. Unique numbers from data validation list
  245. How do I count differert items in a column only if the date in an.
  246. I need =SPELL()>True/False function in Excel
  247. Lock a file so it can't be altered unless saved as another file
  248. Unprotect sheet button!??
  249. How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
  250. Rounding