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. Break up my URLs? Can't figure it out...
  2. How to return zero for an equation = < 0/
  3. Manual AutoFilter - Vlookup, Index, Match, Array???
  4. ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003
  5. 3-D References and Link Updates
  6. In a column of numbers I need a function to find the last entry
  7. Formula for totaling column
  8. weird recalculation of user defined function
  9. ActiveDocument object not recognized
  10. How to make only the cells i need active
  11. deconcatenate
  12. Running averages
  13. Running averages and time stamping
  14. Employee Performance based ratios
  15. Ranking
  16. if column 1=>3 then column 2, if not return no value-Help?
  17. Formula Help
  18. Excel: How to import multiple XML "Repeating child elements" same.
  19. How delete formula bar and retain the computed number in a cell?
  20. Count ; in cell
  21. Compare name and copy from closed .csv files
  22. COUNTIF Formula in Excel with two conditions
  23. Finding last used
  24. Insert Criteria Based on Current Month
  25. floor function
  26. Three new functions that should be part of your standard set
  27. How do I setup dynamic linking between worksheets ie. T-O-C
  28. eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS
  29. Formula Fill help
  30. age formula
  31. Macro - Auto Run
  32. new romanian currency (ron)
  33. =TEXT(I21,"MMYY")
  34. Filtering numbers in a column?
  35. change display format for excel folders and files
  36. select all worksheets in formula (wildcard)
  37. Split 2 words
  38. RE: Otto M. - Data Matching
  39. Capital
  40. Find
  41. Finding duplicates in 2 worksheets
  42. How do I create a formula that makes text in a cell = 0
  43. Increasing values in Price column
  44. Choosing data based on Match to several items
  45. Several worksheet tally by name
  46. Right-click inside of a cell
  47. IRR for 2 cash flows
  48. trouble with viewing fill color and font color
  49. Is it possible to merge data from two worksheets?
  50. Macro Help for Saving a file
  51. min and max in a sequence
  52. excel export
  53. SUMIF with 2 conditions
  54. Merging 2 cells together and prefixing
  55. Is This Possible? - Data matching
  56. About Sheets
  57. INDEX / MATCH problem
  58. How can I link sheet to the certain Excel document
  59. Need help with possible formula
  60. big list of values to averaged smaller list?
  61. Most Current Date
  62. Adding Text from seperate columns
  63. How to select automaticly the last cell not empty of a area?
  64. How do I vary the conditional formatting?
  65. template for taking customer food order
  66. Filter record on color scheme
  67. compare adjacent cells and calculate averages
  68. Data Filter and AutoSum
  69. IF Date range formula
  70. Using a macro to create a macro in another workbook
  71. Ascribing Values to Symbols
  72. Help - Auto update from multiple spreadsheets
  73. "IF" Formula Query
  74. Multiple IFs prior to Count function
  75. Tick Boxes
  76. Need help with two cell accumulator
  77. Validation List
  78. Arrows And Formulas
  79. Copy all records matching "Text" criteria to new worksheet
  80. Seperate cell string into individual cells
  81. Macro command control by date
  82. Reference to Worksheet name
  83. How to auto hide and unhide columns using 1 and 2 icons
  84. using IF function to copy, but leave populated cell alone
  85. Excel, how do I count cell with data within a range?
  86. COUNT and OFFSET
  87. Break Even Analysis Help --dza
  88. Time calculations
  89. Unlocking "check box" control function
  90. in data/filter/auto filter
  91. Sort Problem - Please Hurry!!
  92. Calculate Elapsed Date and Time
  93. How to incorporate cell data in a worksheet header
  94. How do I get a line break when using a formula to combine cells
  95. Modified /advance "Max function "may help!!
  96. How do I input a minus time in an excel spreadsheet
  97. Simple Circular Reference Problem
  98. can you count data in a cell to give a value?
  99. assign formula to another cell
  100. If Match Part of Text Within Cell, Then Blank
  101. linking to a cell within a text cell or comment
  102. Create my own formula?
  103. "000" + number + "."
  104. V-LookUp help
  105. Summing every third cell
  106. How do I make hyperlinks?
  107. IRR formula for monthly cash flows
  108. Returning a Value if 3 Conditions are True
  109. 2nd to MAX
  110. If's conditions about matching
  111. Extract information from the list
  112. sum only visible cells
  113. Trnasferring/ Copying Data Between Sheets
  114. IF Statement help please - again - got it wrong last time!
  115. FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000
  116. Copying Sum Formulas
  117. Match and merge on new worksheet
  118. How can I change the color of the comment indicators?
  119. Match and merge on new worksheet
  120. How can I change the color of the comment indicators?
  121. Is this formula going to work?
  122. Copy a Workbook Automatically
  123. IF Statement help please
  124. cell reference via another cell
  125. cell reference via another cell
  126. Copy a Workbook Automatically
  127. count number of letters in a string
  128. IF Statement help please
  129. count number of letters in a string
  130. Excel
  131. How can I count the number of times a letter repeats in a string?
  132. Several Countif criteria
  133. Multiple sheet
  134. Index function using multiple values in one cell
  135. Gas Mileage
  136. Array formula using two columns and countif
  137. UserForm Save Issue
  138. How can I use an IF statement to find out if the cell is shaded?
  139. Find a value and return a corresponding number
  140. Using nested IFs with CountIf
  141. How can I sum data on a row from certain named columns?
  142. IF Statements-call private sub
  143. How does Excel allow for leap years?
  144. NVL type function
  145. Is there any way to rotate the a field or cell 180 in excel?
  146. Rounding issue with Goal Seek for IRR
  147. How do I show numbers in Excel as 48K instead of 48000?
  148. SUM of INDEX lookups
  149. sumif function
  150. vlookup vs if, help required
  151. vlookup vs. if, help needed
  152. fill in data range knowing start and end values
  153. Results of conditional formatting not what desired. How do I corr
  154. combine 111 in one column & .jpg in another thru out entire works
  155. Does protecting a workbook shut off VBA code?
  156. Results of conditional formatting not what desired. How do I corr
  157. combine 111 in one column & .jpg in another thru out entire works
  158. Does protecting a workbook shut off VBA code?
  159. Excel extending result to multiple decimals
  160. Results of conditional formatting not what desired. How do I corr
  161. combine 111 in one column & .jpg in another thru out entire works
  162. Does protecting a workbook shut off VBA code?
  163. Excel extending result to multiple decimals
  164. Excel extending result to multiple decimals
  165. Forms controls
  166. is it possible to apply template to a existing worksheet
  167. Make a formula to calculate the avarage of baseball stats
  168. pls help with IF formula
  169. how can I highlight a cell if it meets year and month criteria
  170. protection de-activating tab-naming code
  171. Double and Multiple Lookup Using the MATCH Function
  172. How do you get the function of a pivot column to not appear
  173. Autofilter and Subtotals
  174. easy question?
  175. COUNT IF <> ""
  176. Automated summaries/conversion
  177. vlookup formula
  178. price higher than...
  179. external data function error
  180. Help with time formats
  181. Finding values in a list
  182. Time between days
  183. Cell protection & Auto Filter
  184. Query to find last saved date/Time
  185. Sum product of many pairs of columns
  186. Relating text to a value
  187. how do I calculate times in seconds and minutes using percentages
  188. values in IF formulas
  189. sum within a range of numbers
  190. if statement with #N/A
  191. copy & paste formula between spreadsheets - not working
  192. How do I get Auto-Fit to work correctly?
  193. sum the results of a group of formulas
  194. shortcut to last entry in a column
  195. I need to know how to 'Colour Tabs' in Excel 2000
  196. Excel Worksheet Function
  197. Counting multiple criteria involving dates
  198. complicated If condition?
  199. Automating Tab names
  200. Date Population
  201. existing unique value formula help (index(match(countif)))
  202. Using sum(1/countif....) not returning expected result
  203. dotted leader line
  204. Date calculations and sum
  205. Converting to Absolute Cell References - en bloc
  206. Pivot Tables
  207. Does Excel have a "sumnegative" function like Lotus?
  208. Saving worksheets within workbooks as individual files
  209. Help w/range-based permissions in Excel webpage
  210. Count occurrences of values in a column??!!
  211. average every 6th cell in a column
  212. Between function
  213. countif with non-continous ranges
  214. Recursive Functio help
  215. CELL function.
  216. Custom function
  217. add radio buttons to an excel document
  218. IN operator
  219. Displaying percentage in ranges in pivot table
  220. VLOOKUP needing to match two cells
  221. Can I insert an email into an excel spreadsheet?
  222. Relating text to a value
  223. MSNStockQuote ?
  224. Cell Reference
  225. Linked cells and Mapped Network Drives
  226. How do you create your own auto format for a pivot table
  227. How do I get the checkbook register to keep a running balance?
  228. Formulas no longer working
  229. Finding Quotation marks in Search function
  230. Check if a cell has a formula.
  231. Two functions in one cell???
  232. How to copy formulas to a new workbook? Paste Special is different
  233. Index,Match table array in separate workbook
  234. VLOOKUP not returning correct answer
  235. Font size smaller and bigger in a formula
  236. Help!!!
  237. Blank cell in formula
  238. SUMIF FUNCTION
  239. how do you use a chisquare function to analyse data
  240. Late Rounding of Formula
  241. Data Validation Rules
  242. July 19-21 London Excel User Conference
  243. cell formatting
  244. Lock data in a cell a specific cell based on selection on other ce
  245. Sort of VLOOKUP
  246. A1 value 400 I want disply in B1 "Four Hundred"
  247. Extracting a number from a string and converting it into an Intege
  248. MATCH w/ multiple answers?
  249. SUMPRODUCT troubleshooting
  250. Giving different text for different numbers