PDA

View Full Version : Excel General


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 450 451 452 453 454 455 456 457

  1. Cycle between next lowest number
  2. Importing multiple rows of data from another workbook
  3. refresh data
  4. How to fill out with list?
  5. Formulas to calculate off of a pivot table?
  6. Conditional Formatting Disappears
  7. Export Excel Table to XML (via XSD -> XML Mapping)
  8. Help with formula to pull multiple criterian from one sheet to an organized list
  9. Charts help
  10. Replace a formula with its result
  11. Formula Help for Newbie! Example Included...
  12. [SOLVED] automatic date stamp if a cell value changes
  13. SumIf
  14. [SOLVED] Imported data reads time as hh:mm should be mm:ss
  15. Pivot table
  16. INDEX array not working over mutliple sheets
  17. [SOLVED] SUMIF?? Adding cells based on criteria
  18. [SOLVED] Using data validation to look up & then return an answer
  19. Converting from GMT -> EST and Date & Time in HH.MM.DD.SS.MS format
  20. [SOLVED] VLOOKUP with data BEHIND referenced field?
  21. Combined Right with Left Formula problems
  22. Creating scorecard type data
  23. Sorting Multiple ranges on one sheet
  24. Date
  25. How to I protect a worksheet, yet still use List feature in 2003
  26. finding closest value in an array
  27. lookup formula
  28. Sorting Pivot Tables
  29. Drop Down Box with Multiple values
  30. Sum with conditions
  31. suming last 3 columns in pivot table
  32. Paste link problem
  33. Continued Formula
  34. stop rather than print
  35. How can I Filter a list to a new tab
  36. Complex Conditional Formatting Help Needed
  37. [SOLVED] Countif - 2 criterias
  38. Adding rows due to comparing
  39. Cross Sheet Linking problem
  40. Chart with bars and lines - help
  41. putting data within its main category
  42. Header & Footer in Excel
  43. List
  44. Job Numbering system
  45. IF / VLOOKUP / OR question
  46. inventory running count
  47. Conditional formula that will round result
  48. Column and Row Reference?
  49. [SOLVED] Combine two lists to form single unique
  50. Deleting everything after certain character
  51. Sensitivity Analysis-Data Table
  52. add/sub to a number already in the cell
  53. Can't find formula for a weighted random point system
  54. can't collapse subtotaled data
  55. Multiple Find and Flag
  56. If/Then statements
  57. Offset sum based on criteria
  58. Math function help
  59. Multiple Find and Replace
  60. Sort data containing cells validation
  61. Excel Template for D V D Cover
  62. Separating text from numbers
  63. Calculated Field/Item using the same column header
  64. Summarize data from multiple worksheets onto one
  65. Shade a selected cell's row and column
  66. Error in Excel data to Access Database
  67. [SOLVED] Repeat groups
  68. Can print screen figures by input into excel? (automatically)
  69. Change Macro to enter full amount
  70. Extract Data to right and left of numbers
  71. Summing data from a table with multiple entries
  72. [SOLVED] Check column for any text
  73. [SOLVED] Autofill question involving a forumla
  74. formula changing when cell is added
  75. Combo Line & Scatter Chart
  76. [SOLVED] Conditional Format Date Formula
  77. VLOOKUP no exact matched
  78. Allow access to specific users for protected cells (Excel 2003)
  79. Dynamic Charts
  80. help with DTG and military time
  81. Cannot get chart to behave
  82. Deleting Rows
  83. [SOLVED] Count daynames in a defined week
  84. [SOLVED] Turning Calendar month into Fiscal Year problem
  85. Automatically copying rows
  86. Change the sheet number
  87. "Expired" and "Live" dates.
  88. Run macro on formula result?
  89. Conditional Formatting on pivot tables
  90. When .. is .. goto line ..
  91. Inserting rows per new entry
  92. [SOLVED] Sorting by date (different date formats)
  93. Insert word doc
  94. Reading Info
  95. Generate Visio Document for excel data using VBA in excel
  96. Count hours for given period
  97. [SOLVED] Count dayname equal to
  98. Lookup the highest value per criteria
  99. Deleting rows with certain data in them
  100. Exchange Rate calculation
  101. set column type to "Text"
  102. [SOLVED] Payment Date
  103. indent formula or macro
  104. COUNTIF Formula based on cell formatting
  105. exclude zero value from being displayed in chart
  106. Array search
  107. [SOLVED] Calculation Discounted Amount base on Discount Rate
  108. Number to text a word formula
  109. Report help (needed for a job)
  110. Skip Repeats without Deleting w/Multi-Criteria involved
  111. Page Breaks
  112. Range / Selection "In between cells" (VBA)
  113. Dividing text
  114. cursors move screen position instead of current cell selection - excel 2003
  115. Pulling off a specific value from a table
  116. Group and Outline
  117. Conditional Formatting
  118. [SOLVED] Finding the Sum of Squares
  119. Picture and FIle name Matching
  120. [SOLVED] Conditional Formatting with condition formula
  121. [SOLVED] Vlookup - variable table_array
  122. How to print same sheet 3 times using button?
  123. Having create list reference > 1 column
  124. [SOLVED] Two sumif formulas
  125. [SOLVED] Countifs with OR functions
  126. Refresh Multipe Pivot Table Macro
  127. Adding an "IF" statement to a formula
  128. Setting up dynamic tables
  129. Filter
  130. Recognizing Patterns
  131. aggregate multiple transactions with same date...
  132. [SOLVED] Problem with Duplicates
  133. filter list based on another list - exact matches only
  134. Variable Data Validation
  135. [SOLVED] conditional hyperlink to different sheet
  136. Problem with formula referencing a pivot table's Grand Total
  137. [SOLVED] Sum formula for time with breaks between cells
  138. How do I concatenate a Time Value with other text?
  139. Excel 07: Pivot Tables/Updating Column Header Names
  140. IF Statement with bitmap
  141. Sumif or Sumproduct?
  142. Dynamic table row update
  143. Conditional Formatting more than 3 for Excle 2000
  144. [SOLVED] Inputting rounded off values
  145. How to delete empty wells?
  146. [SOLVED] Sumif with about 1,000 criterias
  147. [SOLVED] Formula to show the specific result
  148. charting frequency of times
  149. to find line into a matrix
  150. How to sorting ?
  151. Open Thunderbird folder from XL
  152. How do you plot 2 sets of data on the same scatter graph?
  153. Converting/arranging columns
  154. Update values from externa workbook does not work
  155. [SOLVED] Insert Author into footer
  156. [SOLVED] match function for multiple column
  157. Link in Cell
  158. Data Selection Issues
  159. Creating a list
  160. Changing the column width
  161. converting date format to text format
  162. Text to Columns help
  163. [SOLVED] Extended Dates
  164. [SOLVED] Find position in matrix (not array)
  165. Pivot Table: How to create a Calculate Field that uses a "Difference From" column
  166. [SOLVED] Have #N/A appear as a blank cell?
  167. Show Billing Cycle for a month
  168. Creating an If formula
  169. Ignore hidden cols during external data import
  170. Move the last word to first
  171. [SOLVED] Problem creating an 'If' formula
  172. matching help
  173. Trigger cell from mulitple criteria
  174. Range Change
  175. Column Comparison
  176. MS Query in Excel 2007 is selecting .mdb instead of .accdb
  177. Changing Uppercase letters to lowercase
  178. Pivot Table Patch
  179. [SOLVED] merged cells error
  180. [SOLVED] Return a Random Column Value
  181. Change Column Headings to Words
  182. Unprotect Text box
  183. Loop not looping
  184. Substitute, find and mid
  185. array formula pasting
  186. pivot table percentage calculation
  187. [SOLVED] formula to equate total forecast cost and total budget cost
  188. [SOLVED] Filter Two lists (multiple columns)
  189. VLOOKUP Text vs. Numbers
  190. Sum query
  191. Referencing within hyperlinks
  192. Mailmerge from spreadsheet with lists and subtotals
  193. Need help with formula involving dates
  194. Running total based on previous If statement
  195. scatter chart labelling
  196. .csv file: Char(34) produces three sets of quotations?
  197. [SOLVED] Modifying specific series in an overlayed chart
  198. [SOLVED] Possible to auto update formula?
  199. Remove Duplicates
  200. [SOLVED] Change column formatting
  201. To vLookup or not to vLookup?
  202. auto format if is input not formula in cell
  203. lookup_value in VLOOKUP formula
  204. Formula for a Rolling 12 month Average
  205. >= with times
  206. [SOLVED] Vlookup/Index/Match help?
  207. count second sheet rows according to first sheet
  208. Help with formula
  209. [SOLVED] change rows to colums
  210. menus in top column allowing you to sort rows.
  211. [SOLVED] Report Table: VLookUp, Match, Index Formula
  212. [SOLVED] Copy & Paste without removing conditional formatting
  213. Return cell value as header text
  214. Apply formula on Sheet1 from Sheet2
  215. date / edate
  216. TextBox Difficulties
  217. Worksheet_SelectionChange references
  218. Summerize Formula with 3 IFs and 3 part SUMs
  219. Multiple users
  220. Need to return data in excel (not vlookup!?)
  221. need a function to clean a cell after i put something into it.
  222. Vlookup and ifblank
  223. VLOOKUP Across Several Sheets
  224. Inserting several "Filter" (/"Sort & Filter") in the same sheet
  225. Drop-down list & filter
  226. cell matching...kind of..
  227. Remove Data Labels on a bar chart if value = 0
  228. Sorting by numbers in a cell not text
  229. combine 2 excel files based on a common name
  230. implement discounts in a Loan spreadsheet
  231. Auto Complete in a Data Validation cell technique (feedback wanted)
  232. Employee Work Schedule
  233. Is there a Windows mobile excel help forum?
  234. Date formula
  235. reports in excel
  236. Exporting Data to Different Cells at Set Intervals
  237. Export Data from Cell at Set Intervals
  238. Showing every monday
  239. contribution based on dates and todays date
  240. [SOLVED] Removing a dash
  241. Duplicate counting adjacent cells
  242. conditional formatting expiration dates
  243. time based calculation
  244. Convert decimal text into hh:mm:ss
  245. [SOLVED] Can you have validation information carry a color?
  246. [SOLVED] Sumproduct with multiple criteria & dynamic range
  247. [SOLVED] Column Headers to Column Data
  248. Return a yes no value for dat tolerance
  249. change cell reference every nth row
  250. ISNA Cell #REF! Error