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. Subtracting cell contents - I can't believe it's not working!
  2. #REF! help
  3. need assistance with merging cells
  4. Customizing MSOffice 2K Format toolbar.
  5. how do I add minutes and seconds together in excel
  6. Conform a total to a list of results?
  7. Conversion of Cell Contents into a Functional Worksheet name ?
  8. cell format limits
  9. Naming Worksheets
  10. Modify A Formula To Include AND
  11. Lookup Function Problems
  12. Formula to lookup Multiple Column Text and then Count Result
  13. Convert numbers into its equivalent in words?(12 to Twelve)
  14. use only the first 3 letters of cell data
  15. How do I calculated total hours per week
  16. Moving data in financial forecast
  17. Help using the 'If' function to automatically fill in other cells
  18. I need help
  19. pivot tables reports - altering display of (blank) cells
  20. Countif based on 2 criteria
  21. what exactly are relational operators in Excel? All math symbol?
  22. this may be simple, sumif question
  23. Is it possible to place a stopwatch in Excel
  24. Conditional Average
  25. Help with IF function
  26. creating a rate schedule
  27. Excel formula help?
  28. How to insert picture and automatically size to cell?
  29. Referencing data in different worksheet based on month name
  30. Help with VLookup function
  31. Sum of comma seperated values in cell(Reposting)
  32. unbalanced data in ANOVA
  33. #N/A! to be blank please.
  34. Age with mont in decimal
  35. Help! Formula between the sheets
  36. Splitting a Target Figure
  37. Weeknum Function
  38. Large function
  39. Convert Text (letter) To Number Excel
  40. Next Row
  41. Workbook formulas
  42. Lookup and return multiple Values
  43. Automatically Sort By Reference Amount?
  44. Selecting Rows
  45. Recalculating a Regression Output in Data Analysis
  46. Copy Formula - EXACTLY
  47. Date Range and calculation
  48. I'm Having Problems with EOMONTH
  49. Max number of IF statements
  50. I want to use the same function as SUMIF, but for two criterias
  51. counting date entries by month & year
  52. Generalised version of LINEST using QR Decomposition
  53. Editing countif formulae
  54. custom cell number
  55. If Statement Using Wild Cards
  56. merging sheet1 to sheet2
  57. move one row to another in excel (worksheet)
  58. Check to see if cell data is within a range
  59. VLookup and HLookup at the same time
  60. IF is not carrying out the FALSE part
  61. formulas using text
  62. Can I modify Excel 2003 color palette to accept Pantone colors?
  63. Make an =if show - instead of 0
  64. Create a print macro that would automatically select print area?
  65. I need to insert a drop down menu in a cell?
  66. Logic Tree, MS help = useless
  67. How do I calculate operating expense
  68. Selecting a Worksheet Range
  69. sumproduct w/horizontal range not working
  70. Nested IF AND OR function Inexplicable error
  71. How do I calculate operating expense
  72. Automatic Date Entry
  73. drop down lists/validation tables
  74. How can perform a summation?
  75. Target.Address syntax
  76. Need insert a dash in between last 4 digits in text string
  77. IF - Nesting... almost got it - need a bit of help
  78. Update of cell values after insert row?
  79. Need a help with the IF/ IFCOUNT function
  80. Find certain text in a column and return statement
  81. How do I do this?
  82. counting filtered items
  83. How can I get fonts bigger on my dropdown list?
  84. Question about Emailing
  85. How to get pivot table Time field to appear correctly
  86. Is there a way to reverse the layout of your colums?
  87. No Match
  88. Function Help Please ....
  89. Help with IF & Average Functions
  90. importing data into a workbook
  91. Formula for Calculating a Floating Date
  92. Numbers converted into amount in words in English?
  93. Worksheet VBA function - not recognized
  94. how to convert numerical figure into text
  95. Struggling Again With A VLOOKUP
  96. How do I calculate time
  97. how to change colour of text in true or false formula
  98. cover #s to text
  99. CREATE A SUM BASED ON DATES
  100. Could you help me to calculate overtime
  101. How can I merge and link workbooks into one summary workbook?
  102. randomly select value WITHOUT changing
  103. coutif with 3 criteria including brackets
  104. Not including blank fields in pivot tables
  105. Best 8
  106. How do I delete the same item from all pages of a workbook?
  107. Countif using dates
  108. Editing Array Formula
  109. Counting Blanks
  110. page numbering
  111. Range Changes with the Months
  112. Identifying bottom of list
  113. excel, printing data in columns
  114. Function to return the active sheet name
  115. How do I total amounts on various sheets in excel?
  116. minimum along rows
  117. School assignment: Excel worksheets.
  118. Pivot Tables - Named Range
  119. use replace to edit a formula with wildcards
  120. how do you count checkboxes in excel2003
  121. Cell reference
  122. Payment formula Question
  123. create a multivariable regression in excel without using array
  124. Help with formula...please
  125. display Calendar for Excel field entry?
  126. Lookup function help
  127. Excel for inventory aging?
  128. Help with a formula
  129. IF statements/formula problem
  130. formula with changing cell ranges
  131. moving the formula "average" over one column in a macro
  132. Create a master worksheet based on 2 different worksheets
  133. Re: working with sub-totaled data without the detail
  134. Is it possible to split a cell within a cell?
  135. combine date one column, with time another column into third?
  136. formula to identify weekend dates
  137. Counting Match Pairs In Rows
  138. Exclude non-numeric data from calculation
  139. Formula Problem
  140. create default cell value
  141. Date Function
  142. Drop - Down Box
  143. Do Loop
  144. Vlookup then OFFSET over and down
  145. Drop Down List Autofill
  146. how do I write the date in an if statement
  147. How to transfer info from PDF file to excel (lists)????????
  148. Results in a column
  149. column to column conditional formatting won't work, need formula
  150. Caculating a "staircase" discount
  151. Product formula help
  152. inserting a VISIO drawing into a worksheet
  153. IF Statement??
  154. How do you format a cell for % varience for multiple answers
  155. Lookup - Pro-rate formula
  156. Cleaning up data from Crystal Report
  157. how can I blank out columns that are not being used
  158. Newbe Help with count/countif function
  159. Matching a sampling # to it's row #number
  160. convert a PDF file on the Web to Excel
  161. working with dates
  162. Using Sheet names in formulas
  163. backing sales tax out of a total including sales tax
  164. Calculating the right formula
  165. How do I set up an automatic running average in Excel
  166. print bottom row repeat on every page
  167. plz help
  168. Sumproduct / Max array formula problem
  169. Error using "IF" in Microsoft Excel
  170. Simple Copy from Worksheet to Worksheet
  171. LookupV
  172. Autosum returns an incorrect zero value on the selected cells
  173. IF STATEMENT in multiple workbooks.
  174. How do i make a range of cells change colour
  175. moving cell
  176. I want to convert 10,000 to "Ten Thousand" using Excel Function
  177. Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17
  178. SUMIF Returns a #VALUE error when external source is closed
  179. Reading data in onther Excel document
  180. COMPARE DATA FOR CHANGES
  181. Copy Formula to Different Workbook
  182. pivot table to sheets
  183. lookup function bringing in wrong info
  184. Average of the minimum+50 in a row
  185. Excel Worksheet crashes when changes are made.
  186. Nesting Problem
  187. Array Formula help pls.
  188. date shows 1/1/1900
  189. Nested If with And
  190. Data entry for two worksheets
  191. copying formulas to another cell
  192. Sort defaults
  193. Opening excel spreadsheets via excel.application object w/o prompts
  194. Automatic Sort with VLOOKUP/LARGE Functions
  195. How to autofill data from one sheet into another
  196. Excel - open a new workbook with "own" macro
  197. ISERROR
  198. IF - need to insert a cell value
  199. Formatting Cells - color based
  200. Nested functions HELP!
  201. Combo Box
  202. subtact between times
  203. DATA > TABLE -- 2 variable data tables?
  204. How do I input zeroes in a zip code for a mail merge?
  205. Excel finds a value that is not in the lookup range
  206. errors and printing
  207. Lookup and return
  208. Quick and easy
  209. vlookup, but ignore errors if #n/a
  210. formula stays same in cell when new row is inserted
  211. puzzled
  212. Source Data in Pivot Tables
  213. IF statement
  214. VB Error, combining rows if...
  215. Carying Forward data with specific information
  216. How do I separate a text value with dashes?
  217. International Equivalents
  218. Can an IF formula result in a color filled cell in Excel?
  219. can not enable macros
  220. Check if cell contains certain text
  221. ATTN: Mr. Bob Phillips
  222. Conditional formating help needed
  223. Formulas requiring a time stamp
  224. do I have to manually change PER to amortize a loan out 40 years?
  225. "BLANK" - need to delete
  226. do I have to manually change PER to amortize a loan out 40 years?
  227. Ability for Excel to find and replace graphic objects (like Word)
  228. assigning ranks to number ranges
  229. fill a series of dates excluding holidays
  230. Refreshing drop down cell values...
  231. cell custom format
  232. Changing a Link Mid-way Across Worksheets
  233. Duplicates
  234. Entering same data, two worksheets
  235. When using SUMIF won't worj with crieria = cell referrence
  236. IF Function or Countif
  237. Help with Excel formula
  238. Change color to red when fraction is negative
  239. Another Reason to Hate Insurance Companies (as if you needed one)
  240. Data Validation dependant and unique
  241. Searching Excel for a value
  242. How can I match data about countries drawn from two database queries?
  243. How do I add time (in mm:ss) from multiple worksheets?
  244. Real Value of .UsedRange.Rows.Count
  245. SUMIF for Dates / Months ?
  246. trying to add text
  247. How to print detailed instructions for all functions in Excel?
  248. Automatically insert row and copy formula
  249. Return Single Instance of Numeric Values from a Column
  250. mass cell data editing
Google