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. Mod-10 Check Digit
  2. Add asterisk to excel cell
  3. Looking up a sheet name
  4. allocating between positive and negative amounts
  5. Overtime Calculations
  6. How do I move data from one cell and add to another?
  7. Matrix multiplication with empty cells
  8. excell
  9. Counting Values that meet another cells criteria
  10. insert a formatted row in excel [office for xp 2002]
  11. how can i subtract time from two different date?
  12. Using COUNTIF with text
  13. Compound Interest
  14. conditional formula - based on 2 separate criteria
  15. functions failed in excel 2003
  16. Countif
  17. Kent Hansen
  18. At my wit's end! Use DGET or VLOOKUP to select data????
  19. How do I replace a negative number with zero
  20. multiple hyperlinks
  21. Pivot tables - Fonts etc
  22. VLookup Function
  23. How do I make the fill color of a cell on one sheet follow the co.
  24. web query for Excel
  25. Combining today +1 and weekday function
  26. pivot table logical calculation
  27. Need to find the right-most cell value in a string of cells
  28. Highlight a row if a specific cell is specific numbers/words
  29. sorting numbers more than one decimal
  30. Bernie My New Macro
  31. Return lowest quantity
  32. how do I get lookup to work
  33. How do I find a column entry closest to a particular value
  34. PMT 30/365 vs 30/360
  35. Capital Letters
  36. ? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???
  37. How do I autocalculate a single number?
  38. How do I return a calculation based on several ranges?
  39. Frequency of occurence
  40. Excel workbook fails to display when selecting from my documents.
  41. CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS
  42. Count the number of dates in a range that are earlier than today.
  43. Control cursor direction in highlighted group of cells/Page setup
  44. can anyone help with times not coming across correctly in pivot t.
  45. can anyone help with times not coming across correctly in pivot t.
  46. Problems with the VLOOKUP formula
  47. i need help with the "count" function
  48. Excel Formulas and formatting
  49. Listbox Question
  50. Minutes to Hours:minutes
  51. One file splitted into worksheets
  52. substituting two text occurances in same cell.
  53. Dave My New Macro
  54. How do I set up a stock control template?
  55. Excel lookup and calculation
  56. Formula to convert/transpose columns to rows (and vice versa)
  57. How to convert hours in days?
  58. VLookUp Tables
  59. Formula Question
  60. counting based on criteria
  61. combining an if statement
  62. Highlight row given certain conditions
  63. Pivot table
  64. Can excel have a button to input (stamp) the systems date and/or .
  65. Vlookup #value
  66. Lookup Lookup Lookup
  67. How do I set up a conditional format with more than three options.
  68. Multiply one cell by a factor and make that result round
  69. Distance between zip codes
  70. how to merge mutliple columns vertically
  71. add only positive numbers and avg in a column
  72. formula IF returning current date
  73. Comparing contents of two spreadsheets and outputting results to a
  74. how to link from column to row?
  75. 3 questions about automated c++ com add-in worksheet functions
  76. Making list with unique columns
  77. RE: Get "Error 1327" message when trying to run setup.
  78. Can't break a link, all links are removed
  79. function
  80. need a formula
  81. Sumproduct help
  82. shared file
  83. Adding Cells
  84. Text Next Line
  85. Group
  86. Compound Interest
  87. Sumif or Sumproduct
  88. delete a macro button is grayed out.
  89. mistakes in the Excel functions (help on line french version at le
  90. How can I copy an .xls worksheet to another worksheet
  91. Unmovable absolute reference
  92. If Statement Question
  93. Look up function
  94. Multiple IF factors
  95. Macro
  96. concatenate cell
  97. autonumber values
  98. offset and indirect function
  99. how to: circular reference
  100. In Excel, have time of day appear automatically.
  101. Counting Dates
  102. business days between 2 date feilds
  103. Copy workbook
  104. Moving selected data
  105. Function WEEKNUM does not show correct result for 15.2.2005
  106. Match and add
  107. putting a number equal to writing commands
  108. What function would I create?
  109. Can this be done???
  110. How to sort merged cells
  111. How do I get my formula to stop rounding up
  112. Help with Pivot Tables
  113. Pivot Tables
  114. Average formulas
  115. Show missing data as 0
  116. Print and Print Preview don't match screen
  117. Function Help
  118. Auto page numbering for several worksheets
  119. Hyper link within same workbook
  120. NPER - Retirement Example
  121. I can't get a worksheet to copy onto the workbook
  122. How can I sum only amounts that are formated B O L D?
  123. Can I format my worksheet so that the cursor goes only to cells t.
  124. ISNA and VLOOKUP
  125. Employees across midnight (2200-0100) -repost (attn: Bob)
  126. Function HELP!!!
  127. Excel: Use a name with external workbook reference for data valida
  128. Can vlookup or hlookup look to other worksheets within a workbook.
  129. Multiple lookup value's
  130. numbers not adding up correctly in spreadsheet
  131. numbers not adding up correctly in spreadsheet
  132. still having trouble with this....
  133. Help with a formula
  134. I want to select the first blank cell in column A
  135. strike out feature in excel
  136. Re: Transfer From one to another sheet
  137. Analysis ToolPak
  138. How do I color cells within a formula in excel?
  139. Looooooooooooong links.
  140. How do I create formula to identify duplicate cells?
  141. Copying a spreadsheet with macros
  142. Calculating percentage
  143. 23:00 <> 23:00
  144. Problems with Google
  145. How to match two different cells text, if the text is not in the .
  146. Highlight automatically anything that is other than required
  147. Conditional Formating on calculated data in a pivot table
  148. Decision Tree Add-In?
  149. leading 0
  150. Calculating % in a pivot table
  151. Calculatng bowling averages
  152. Multiple Functions
  153. Between calculations
  154. How do I add a command button on a worksheet to "paste" from the .
  155. auto protection of cells
  156. Moving total
  157. Worksheet Changes and applying code
  158. Index and Match
  159. how do i use > or = to in a formual for excel
  160. EXCEL FORMULAS
  161. Standard Balance Sheet format in Microsoft Office Excel 2003(2)
  162. Open two worksheets at the same time
  163. Formula for Kilometers to time Please
  164. HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
  165. Check boxes
  166. brainteaser?
  167. Screen Updating
  168. ComboBox data
  169. macros errors
  170. Hours and Minutes
  171. =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF
  172. SUM Function
  173. Text formula
  174. hide a button
  175. how do I delete all rows that match a condition?
  176. Sum function when pasting
  177. Formula for calculating interest payments?
  178. How to add in an array formula if iisna index match
  179. Excel - Addition Running
  180. Suggestions for creating Issues Log using Excel?
  181. Data Validation using a Calendar
  182. Transpose-relative cell references would be useful.
  183. help with excell to outlook for mail merge
  184. eliminate data entered to a worksheet that copies to another work.
  185. VLOOKUP function
  186. calculate date differences in years and months
  187. if function, multiple characters from right
  188. i cannot open excel file error Cannot access read-only document me
  189. counting cells (COUNTIF) based on two or more criteria
  190. split a single column into 2 separate columns
  191. Unique sumproduct with criteria!
  192. COUNTIF Function
  193. Date difference taking into account weekends.
  194. Linking between worksheets- then sorting data
  195. DOS Data in Excel Format with Date and Military Time in same cell
  196. how do i set an equation that uses a cubic root in excel?
  197. how do i set an equation that uses a cubic root in excel?
  198. Percent increase
  199. how to convert GETPIVOTDATA from excel 2000 to excel 2002...
  200. FILTER ONE MULTIPLE SHEETS
  201. What does the ! stand for in formulas?
  202. 2 Question: Coloumn width, Filename
  203. External Data Source updating on open, how to turn back on prompt.
  204. FORMATTING CELLS
  205. Indexing an Array with VLOOKUP
  206. Worksheet references another tab in formula
  207. Row counter in formula
  208. Excel
  209. can excel find the last used line in a column and display it?
  210. How do I repeat rows on the bottom of each sheet in excel?
  211. Number formatting question
  212. External link using calculated cell value
  213. Scheduling
  214. How do I make formula in Excel from other worksheet?
  215. Moving average
  216. Creating League tables
  217. How do I insert a heading into a column
  218. Numbers after decimal point excel to word mail merge
  219. Sumproduct with offset?
  220. protection issue
  221. calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets)
  222. Back-testing trade data
  223. I need to find the Average from Column A - but Reference Column B
  224. How do I integrate a variablebased formula in excel?
  225. combine columns
  226. using links to show data
  227. Not printing a single cell's value.
  228. Using the average function
  229. Excel: How can I freeze some of a workbook
  230. How can I enter 8 digits in excel (eg 19710625) and get it to dis.
  231. Excel user defined functions.
  232. need help using the offset function differently
  233. is there a way to write this function?
  234. H - SumProduct
  235. Questions on combin and permut
  236. how do I add/subtract time when I'm going from PM to AM (ex. 11:4.
  237. Returning colours from a function
  238. How do I use an average function, not counting cells containing a
  239. change value by date range
  240. if...or....function
  241. How do I automatically transfer data to a 2nd worksheet page?
  242. how do I figure the difference between two times when one is in p.
  243. pivot tables interface with queries
  244. how do I search by more than one criteria in excel?
  245. Importing Microsoft Word File Names
  246. How can I share a macro with other users in the network within a .
  247. Finding the last row entered
  248. VLookup or Index Match ?
  249. Re: Time/DateSerial Numeric Value
  250. For Ron de Bruin Please
Google