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. Adding Borders
  2. Excel date function
  3. move spread sheet
  4. worksheet malfunction
  5. change format for phone numbers automatically
  6. HLOOKUP
  7. Delete duplicates
  8. ALL CAPS to regular text?
  9. Counting Unique Values
  10. Formula to spread number across
  11. Array formula not working
  12. How to add only certain rows in a spreadsheet
  13. Selective deletion of rows containing certain text.
  14. Counting unique text/number cells from a range
  15. lookup within a cell
  16. calculation error
  17. indirect cell reference using copies of worksheets in same workboo
  18. Rounding Time Calculations
  19. Need help looking up value based on criteria
  20. need formula
  21. PLEASE help with IF function...
  22. how do I cut and paste into a protected worksheet?
  23. Can I combine the text from multiple cells automatically
  24. Number changed to Currency and ...
  25. how do I cut and paste into a protected worksheet?
  26. how do you copy the same cell reference on different worksheets
  27. How do I convert a net $ to a gross $ in excel
  28. display multiple lines of text within a merged cell automatically
  29. IF Scenario
  30. COUNTIF for 2 conditions
  31. Using Offset to name a range
  32. Counting Unique text entries in a sheet with a condition
  33. re-selection of Chart data range using keyboard
  34. create a top 10 list of sales figures
  35. how do i display numbers in lacs
  36. HELP ME, PLEASE!!!
  37. HELP ME, PLEASE!!!
  38. COUNTIF FUNCTION
  39. Formula related Crash on Opening File
  40. dealer evaluation
  41. How to round up the result in a cell containing formula
  42. copying cells based on criteria
  43. nested IF maximum?
  44. sorting two columns together
  45. How do I lookup a value in a array that is not in ascending order
  46. SUMPRODUCT and search string
  47. EXCEL:NUMBER TO GREEK WORDS
  48. EXCEL HEX2DEC conversion error
  49. Accessing WorksheetFunction.XX from regular C# Forms application
  50. A new sequence number in file everytime it is opened
  51. SUMIF function help
  52. Copy and Paste between 2 worksheets with VBA
  53. How to convert numbers with apostrophe's (ex. 219'2) to decimals?
  54. Re: Autofilter stops working
  55. How to input Jan & have a series filled in for the rest of months
  56. Workbook Links
  57. Sorting, Merging, and Re-merging
  58. how do you delete a name in the the open box
  59. Execel Question
  60. Why are my cell being divided by 100?
  61. Combining Text from multiple cells under multiple conditions
  62. countif conditional
  63. How can I use replace(alt+H) for mutiple items needing replace
  64. Automatically changing stock tick quotes to decimal-price format.
  65. multiple pivots updated with selection in one table
  66. pivot field of fields
  67. pivot zero values
  68. what is the excel equivalent to lotus backsolve
  69. pivot date sort/show
  70. forecast function
  71. Modify A SumProduct Formula
  72. Creating a blank when links can't update
  73. How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
  74. SUMIF function not working
  75. drop down box calendar
  76. Setting character attributes in a text string
  77. Define list of worksheets
  78. Protect Format OF Worksheet
  79. Reformatting formula
  80. Cant find it!
  81. Calculation in a Row
  82. Save as Dialog Box Mysterious " "
  83. Auto fill in cells
  84. Can I empty the cell who has formula in it
  85. How to protect the cell's formula not be deleted
  86. RE add cells together if value has a formula
  87. subtotal - pivot table - or better function
  88. formula help please
  89. Earliest Date to populate?
  90. My formula Is giving me a #NAME!
  91. Decimal Subtractraction
  92. What is the formula for converting farenheit to celsius?
  93. simple formula
  94. SUMIF problem
  95. Cumulative Sum
  96. Letter/Number Split
  97. array formulas
  98. Cash Flow by Week
  99. PLEASE HELP with the SPELLNUMBER function
  100. SEPERATE NUMBERS IN A CELL
  101. SumProduct Question
  102. Help with what should be a simple formula
  103. Creating norms
  104. Lookup values in multipul sheets and show value in another sheet
  105. pivot date sort/show
  106. con't paste merged cells
  107. How Do I Hide A Row (if a condition is true) using a Macro ?
  108. Creating a certain number of entries based on a number in a cell
  109. Auto Numbering Each Cell In A Column
  110. search in the entire sheet for different letter and cal.
  111. Concatenate in Pocket Excel
  112. making controls transparent
  113. check a checkbox in a formula
  114. How do I link multiple cells at the same time?
  115. Making an ouput file
  116. how do I convert text in excel to 1st letter capital,only
  117. Ttest
  118. how to I refer to current workbook without using its name?
  119. Using Excel's XML mapping/export with data organized in columns
  120. vlookup
  121. ttest function
  122. how do I calculate an input "c" to add certain cells?
  123. Could the "Criteria" in COUNTIF function be a cell reference?
  124. Modifying sumif formulas.
  125. Excel 2003 worksheet name function?
  126. NETWORKDAYS() not avaialbe after reopening
  127. How many IF's can you have in a nested IF function?
  128. Please Explain Formula
  129. dates
  130. Please Explain in Lamen's Terms
  131. Past date in column to change color
  132. i,
  133. IF Statement Problem
  134. Look up Problem withion Excel
  135. variable to refer to "this worksheet"?
  136. Micosoft Query does not export result set to excel
  137. Macro needed
  138. Fraction in 16ths format reduced to LCD
  139. Finding a Value and inserting a value in another cell
  140. Nested IF and MID functions
  141. I want to show all comments on cells in one cell in the worksheet
  142. create autosum macro along with notation on the side
  143. Sumif help
  144. Counting Functions
  145. vlookup weird error
  146. sumif formula returns incorrect value
  147. Formual help needed
  148. Pivot table Data refresh
  149. Formual help needed
  150. vlookup using a constant value
  151. how do I total hours and mins in excel
  152. functions do not calculate
  153. sumif issues over multiple colums
  154. Returning all values from a lookup - not just the first/last one
  155. sqlrequest in excel 2003
  156. In Excel the total is off by a penny.
  157. Finding char within a cell
  158. Number of Conditional Formats
  159. finding char within a cell
  160. Data Source Name Not Found
  161. I can't get the forecast formula to work?
  162. please ignore
  163. If statement for text
  164. Date Conversion
  165. Variable VB to assign new sheet name
  166. Sorting Worksheet Tabs
  167. How to use complex no. functions that have cell references?
  168. Combining rows
  169. doubling a number X number of times
  170. Variable ranges
  171. IF scenario for a range
  172. Eliminate formatting dulication in multiple worksheets
  173. improve formula offset and indirect
  174. How do I display more than one mode in a cell?
  175. margin trouble in excel,bottom always default to .62
  176. Recover earlier version of sheet?
  177. How do I bin numbers by a date in an Excel sheet
  178. How do i convert years to months (formula)
  179. Doing Sums on existing numbers
  180. how to change path name of html source folder ?
  181. triadic combinations of words
  182. Cell value = tab name?
  183. date/time
  184. Setup Accounts Receivable functions in Excel til we get new syst?
  185. Getting Count field to recognise rows with negative values in Exc.
  186. Help in getting external data needed please
  187. OFFSET using ADDRESS for the reference argument
  188. filter list of text for unique entries using formulea
  189. how do i protect an Autofilter funtion on Excel 2000
  190. extrapolate data from series
  191. Tab in a cell?
  192. Difficulties with COUNTIF.
  193. Sum Product Problem
  194. How do I do multi VLOOKUP's based on certain criteria per cell?
  195. Problem
  196. sorting data by date
  197. Can specific cells on a worksheet be hidden & password protected?
  198. Formula for Continuous Services Dates
  199. Absolute References in cell formula
  200. Restricting Multi-user access
  201. Calculating non-financial rates
  202. RE: help with simple formula
  203. Starting a macro with the IF function
  204. Merging 2 different pivot tables
  205. help with simple formula
  206. Auto-update with multi-users
  207. Find and delete part of formula for multiple formulas?
  208. Mode Function with 2 Criteria
  209. Help Please - Dates in Excel
  210. Adding excluding zero
  211. Use Cell Content to Build Link
  212. hide a worksheet so that a macro can still find it
  213. If function help
  214. Sorting an Address List
  215. Filter range of only active cells???
  216. SUMIF over multiple columns
  217. How can I add up how often certain text occurs?
  218. Cross workbook referencing based on cell input
  219. Did not see any reply from yesterday. Need data formatting help
  220. font size changes w/ control focus
  221. Problem Assigning Macros
  222. help please - complex countif, etc. functions
  223. The { formula } type of formula
  224. hiding worksheets
  225. More time questions and IF function problem
  226. Need Help Computing Workdays for a project
  227. Worksheetfunction.vlookup and #value error
  228. Removing Duplicates
  229. help please - trouble with sumproduct function
  230. HyperLink Function
  231. Sum if statements with conditions
  232. Drop down lists are displaying end of list, how to make it top?
  233. use sumif with array
  234. hyperlink functions
  235. Cannot get CUMIPMT to work in Excel
  236. formula to find and flag dates older than 30 days
  237. Adding an AND Statement to COUNTIF
  238. Using color in lookup
  239. Excel Formula/Worksheet maybe Macro Question
  240. how can i calc averageif
  241. formulas
  242. if then statement color coding (or another function???)
  243. how do i setup a running invoice number in excel
  244. SUMIF function retrieves "0"
  245. VLOOK
  246. Match Function
  247. How do I assign a text value to a variable number of rows?
  248. download will not open in usable form
  249. Windows cant open excel spreadsheet.xls?
  250. how to use the Prob function in a list of averages to find the le
Google