PDA

View Full Version : 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

  1. Numbering rows for sorting
  2. almost DSUM, but is there another database - criteria funcion?
  3. Re: excel custom menu
  4. Re: Time-of-day Average
  5. MS.Excel vs Works Spreadsheet
  6. Re: Calculating age from birth dates
  7. Fields - Tabbing to the next
  8. ISERR vs ISERROR
  9. Select the Name of the Worksheet with InputBox
  10. Bolding specific text in a formula
  11. Comment boxes
  12. select the worksheet
  13. Re: How do I extract specific data out of a cell to another cell
  14. Don't show Zeros
  15. Re: Error #VALUE with TEXT(A1;"[HH]:mm") when changing regional settings
  16. Re: Continual date countdown/reminder (Help!)
  17. Trim function limitations
  18. Excel "IF" function problem
  19. sumif function
  20. Notes
  21. split worksheet
  22. Combo Box & Linked Workbooks
  23. Formula
  24. E-Mail Hyperlinks in Excel
  25. Excel column headings
  26. Excel Conditional Formatting?
  27. Compare 2 Worksheets & Find Matches
  28. VLOOKUP problem
  29. Pivot range update on mulitple tables
  30. Comparing ranges
  31. excel.exe program error
  32. Extract a number from a cell of text
  33. Re: Formula help, CELL Function help needed.
  34. filtered list
  35. Selecting from a list
  36. Formatting Column with all Caps
  37. Upper case to lower case
  38. Networkdays calculations
  39. pivot chart formatting?
  40. Change Case
  41. How to prevent function range auto-modification ?
  42. Re: #N/A
  43. IPMT and ISPMT
  44. Possible to set Zoom on worksheets via Macro?
  45. Calander
  46. Vlookup or Offset question
  47. attaching website links to excel file
  48. Examples needed
  49. Calculating Duration
  50. Date List
  51. concatenating cells
  52. combining formulas
  53. Rounding to nearest $
  54. Sumif of cells less than a system date
  55. Line spacing
  56. Re: Countif using Criteria "<>""" ?
  57. Balanced Scorecards
  58. How to pass array variables in sub procedure
  59. vlookup Sorry if it's confusing..
  60. Comments that aren't Comments
  61. Pivot table update
  62. reversing lastname, firstname
  63. emailing excel single sheet as attachment
  64. deleting duplicate rows
  65. Rounding up at 4
  66. vlookup does not always work
  67. Printing group symbols on report
  68. How to multiply a text function by a dollar ammount
  69. Merge 2 Worksheets like Word Mail Merge???
  70. Index & Match
  71. generating random numbers
  72. import data from one worksheet to another
  73. formulas
  74. Visual Basics code
  75. Creating new Option buttons
  76. Running Total of Column
  77. changing a button color
  78. angled column headers
  79. his own PR thrust
  80. Re: Hyperlink Removal
  81. formulas
  82. histograms with normal distributions
  83. Negative Numbers
  84. Splitting cells / diagonally displaying cell data
  85. remove link
  86. Solve for X
  87. Re: Table Formula
  88. Specs for Random Number Generator
  89. formula
  90. Excel 2002 does not recalculate existing formulas
  91. help with SumIF
  92. If value is greater than, then....
  93. Empty Cells, COUNTBLANK, and ISBLANK
  94. Excel formulas
  95. calculating with displayed values
  96. How to Copy/Paste Only the Subtotal Rows in Excel?
  97. Subtotaling in Excel Using Different Types of Calculations
  98. Need help: I want to display the last save date and saved by in the footer
  99. Impossible Matrix
  100. Calculating Time
  101. crore formatting
  102. Columns now numbers?????
  103. Re: cell to change colour at given date - how to
  104. Personal.xls
  105. macro question
  106. worksheet protection/macro
  107. formula
  108. IF cell contents = ?????
  109. Lookup question
  110. Looks like kind of lookup but...
  111. Pivot table - formatting
  112. Excel Spreadsheet
  113. Pop up function ???
  114. Newbee show cell address
  115. Totals in Days, Hrs and Minutes
  116. Entering numbers
  117. Sorting by cell or text format
  118. spreadsheet question
  119. match formula
  120. Excel text converted to Number or other
  121. Choice and effect
  122. lotus 2.4 macro
  123. Problem with Excel File after Upgrading to Office 2000
  124. Worksheet updates
  125. histogram
  126. Macro to add cell value to refering cells formula
  127. Compare adjacent numbers Within Cells
  128. Excel 2000 255 character limit
  129. "If" or "sumif"
  130. global changes to hyperlinks?
  131. Change in time where text is involved
  132. View problems
  133. date f(x)
  134. automatically add a numerical unit on a daily basis begining with a date specifi
  135. Bullet Points
  136. cell references
  137. average f(x)
  138. Formulas not automatic
  139. Formatting (General to Number)
  140. Fonts of Drop Down Forms
  141. Custom Template Worksheet Location
  142. Exposant
  143. Order form
  144. getpivotdata
  145. Column names and deletions
  146. Vlookup or Match/Index to return value 2 rows down
  147. Average function
  148. average function
  149. "Sumif"or "if" ...followup question
  150. Sharing Workbooks
  151. lookup for double column
  152. LOOKUP function
  153. watermark
  154. sum minus the smalles cell
  155. drop down
  156. calculating number of days between two dates
  157. Solving for Coefficients of a polynomial
  158. Pivot Table Using Multiple sources
  159. ROUND function or custom format
  160. lookup formulas
  161. LOOKUP Formula
  162. Pooled regression and dummy variables
  163. trendline equations are incorrect
  164. Date Function: How to determine number of Saturdays in a date range
  165. Macro
  166. all today's work gone :(
  167. AutoFill On Inserted Rows
  168. vlookup
  169. Re: Tally Text
  170. Dates parameters/logic
  171. Compare 2 columns in a worksheet.
  172. finding Specific day in a named range
  173. Autofill formulas b/t various worksheets
  174. Creating Formula (Date)
  175. Date Value & Date Format
  176. macro - hide rows
  177. graphng distributions
  178. matching values
  179. sumproduct variables
  180. Problem with Date
  181. Opening Excel sheet with macro's on XP machines gives error
  182. Date Format problem
  183. last day of month
  184. last value in a row
  185. Writing Todays Date to an Excel Worksheet
  186. sequential counter
  187. combined cell
  188. multiple AND conditions with IF's
  189. Using multiple IF statements
  190. nested functions
  191. LOOKUP or Offeset
  192. Macros in XP vs 2000
  193. multiple field returns
  194. Using Sheet Name In Cells
  195. concatenate question
  196. Counting Rows
  197. Multi level calculations
  198. DATE
  199. getting max value of unique dates in a range
  200. barcoding
  201. Moving from textbox1 to textbox3
  202. Sum Dates
  203. Remove Spaces
  204. text referencing
  205. Excel database query
  206. Changing A1 to $A$1.....
  207. Date Format
  208. copying worksheets to other workbooks
  209. automatic links
  210. filter
  211. Excel 97 - finding No. of Months between 2 date ranges
  212. If then formula
  213. Re: If then formula
  214. MONTHLY PAYMENT FUNCTION - DAYS TO 1ST PAYMENT
  215. return in excel
  216. using spell check on a protected sheet
  217. Turn off From: Cc: options under Office
  218. Deleting Excess Pages
  219. TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES
  220. Formula Help
  221. Finding and deleting data automatically
  222. Pivot Table Display
  223. Multi worksheet data look up
  224. emailing protected Excel worksheets
  225. MouseClick as Counter
  226. import data
  227. Re: Copy subtotals
  228. Spherical Coordinates
  229. Deletion of non-existent links
  230. Two Problems Adding Hours
  231. This directed to John Wilson/or anyone else
  232. Data Validation
  233. testing
  234. unhiding Column A - help!
  235. Calculating age from date of birth
  236. Spreadsheet play file then close
  237. Array Countif formula driving me NUTS!
  238. Changing date formats
  239. Linking
  240. Worksheets
  241. Tan Graph
  242. revision number of excel worksheet..
  243. sumproduct formula
  244. referencing a cell pointer in AVERAGE
  245. Split Combined Name
  246. Formula Help
  247. excel data hidden
  248. Re: Random Numbers
  249. sumproduct
  250. Counting
Google