Excel Archives [Archive] - Page 66 - The Code Cage Forums

View Full Version : Excel Archives



  1. How would you do this calculation?
  2. Get External Data
  3. Hide rows in EXCEL
  4. FORMULA VS VALUE
  5. Index Help
  6. Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003?
  7. format a cell
  8. Pivot Table Trend Limes
  9. [SOLVED] Can I Turn PivotCache Refresh (Calc) off & on in VBA?
  10. Suppress @VALUE! on a template.
  11. Lookup Formula Using Multiple Values
  12. [SOLVED] Find Ranking
  13. [SOLVED] IF cell A1 contains "X", enter "X" in cell B1, if not enter "Y" HE
  14. [SOLVED] SUM DATA RANGE
  15. MACROs Are Turned Off
  16. Automating to autofill column B based on column A entry
  17. Capitalize only first letter in sentence
  18. do not delete "0"
  19. Assigning Range Names using VBA and R1C1
  20. Pivot Chart Question
  21. Formula to Delete Duplicates but keep one record
  22. [SOLVED] Help for Excel time format "MACRO"
  23. Charts change colour in 2003
  24. rows to repeat at the top
  25. Can't use arrow keys when manuvering through Excel 07
  26. Macro I think????
  27. Header rows
  28. [SOLVED] Fixed Decimal QHelp
  29. Write a row to a email
  30. Margin Lines in Print-Preview Mode
  31. Shaded Cells and gridlines
  32. I have to rewrite the following for Excel 2003
  33. Copying Formula
  34. will Vlookup work for this...
  35. Validation Question
  36. Function to return a range of cells from a PivotTable
  37. Count if formula error
  38. Two color fill between two lines
  39. List Comparison
  40. [SOLVED] hi
  41. [SOLVED]: Excel spreadsheet won't open full size.
  42. [SOLVED] Clean-up Code
  43. [SOLVED] [Statistical functions] Function to return result from Z table?
  44. Hlookup, range_lookup parameter
  45. Text box format missing when saved from 2007 to 2003
  46. Excel 2007 - Can't scroll thru worksheet
  47. index help
  48. Summing random cells as you click on them
  49. Command button
  50. [SOLVED] Pivot Table Help
  51. need to turn a word into numbers (or ascii codes)
  52. IF statement to generate nothing
  53. [SOLVED]: center table on page
  54. [SOLVED] Need help
  55. MICROSOFT OFFICE 2007 HOME & STUDENT
  56. Mailing Labels
  57. Where can I find Tools : Data Analysis : Regression in Excel (Vist
  58. Can I create a statement from a spreadsheet
  59. Find the last Cell in a column in VB
  60. If formula result = 0, do not display-leave cell blank
  61. [SOLVED] Counting cells that are shaded in black?
  62. lookup help
  63. Query returns blank cells where there should be data
  64. How do you get a macro not to go to or change a locked cell?
  65. Macro to copy values then delete row for entire sheet
  66. Get the last row
  67. [SOLVED] Second Smallest Number in a Set
  68. Pivot table - How To Obtain a External data Source??
  69. drop down list dependant of previous selection
  70. [SOLVED] formula to add 6 months to a date entered on one worksheet, in ano
  71. worksheets
  72. [SOLVED] Excel
  73. Sum of each row.
  74. Hyperlinks stopped working
  75. Data Validation Custom with V Lookup
  76. [SOLVED] Tracking Changes
  77. Text to data
  78. Convert American Date to Australian Date format
  79. =TEXT()
  80. how to resolve incompatibility of saving an excel to csv format
  81. [SOLVED] saving an excel "print preview" view
  82. Extract specified fields with criteria from Excel.cvs workbook
  83. Monthly Bill Payment Running Totals
  84. AUTO FILL ADJACENT CELL WITH SPECIFIED VALUE
  85. Extract first word for a highlighted selection (non contiguoes)
  86. [SOLVED] creating checkboxes and radio buttons in excel
  87. Vlookup??
  88. Chart Formating
  89. CF for specific ranges of time for an entire column
  90. Multi threaded calculation (multi CPU) - impact on calculation spe
  91. If result of formula is zero disgard it?
  92. [SOLVED] MAX() of a range of negative values?
  93. Using a cell in the worksheet as a range in a VBA routine
  94. Charting Text
  95. [SOLVED] Totalling data used in drop down boxes?
  96. is this not working because i am using 03?
  97. I could not opened Excel 2002 files from Windows Explorer
  98. Default charts changed from 2003 to 2007
  99. Hyperlinks to show on top left corner of screen
  100. pick list and Data Validation
  101. Converting RTF file into TXT file
  102. How to export plain text from web site to Excel without data conve
  103. [SOLVED] How can Enter Page Numbers and/or page ranges separated by commas.
  104. [SOLVED] How do I highlight a row in Excel based on the current time?
  105. [SOLVED] VBA, 'implements', and occasional failure to upcast. [probably messyVBA internal bug?]
  106. cross referencing 2 workbooks at same time
  107. Formula Problem
  108. Add multiple columns in between
  109. [SOLVED] how to give variable range
  110. [SOLVED] Requiring a value in a cell before allowing user to print
  111. [SOLVED] SQL update statement in excel vba
  112. [SOLVED] IRR Calculation Frustrations
  113. [SOLVED] Referencing a workbook in a lookup
  114. [SOLVED] How do I set up multiple values in a pie chart
  115. Line chart categoray axis labels issue - Excel 2007
  116. [SOLVED] SaveAs call changes text to #####
  117. Conditional Formatting Excel 2007
  118. [SOLVED] Dates in Excel
  119. [SOLVED] How to set the formula - 3 Dec?
  120. Is there a way to find the max in a set of data that meet a certaincriteria w/o using an array formula?
  121. Returning a value from the cell next to my match
  122. [SOLVED] Re: How to convert positive figures to negative ones?
  123. Getting data from another worksheet
  124. [SOLVED] scroll function not working in excel 2007
  125. [SOLVED] Subtl column A based on column B. Each time B changes pattern?
  126. RELATIVE REFERENCE WHEN MATCHING 2 PRODUCTS
  127. Can someone help with this problem please
  128. Custom Color Palettes
  129. Web query causes excel crash!
  130. [SOLVED] IF value = "DEC" or "MAR" cut and paste 3 cells
  131. top ten filter
  132. [SOLVED] [SOLVED]: Program find a 5 minute gap
  133. Multiple Ranges = same value
  134. [SOLVED] sendmail won't run on some computers
  135. [SOLVED] Using workday function to populate schedule
  136. Running a Macro when cell value is a specified value
  137. trying to copy a worksheet containing named ranges to anotherworksheet
  138. Multiple conditions
  139. Locate values in range
  140. [SOLVED] Plain .TXT file to Word .DOC file via Excel VBA - Possible?
  141. can I split a worksheet then have the 2 sections work independent
  142. VB to send email via outlook to a distrobution list
  143. [SOLVED] Ensure range of cells each contain an value
  144. [SOLVED] Can I pass network logon name to a cell in a spreadsheet?
  145. Chart connected to an Access data base
  146. Set Sheets as variable
  147. [SOLVED] How to do lists
  148. How to set worksheets to print in different order in the same file
  149. [SOLVED] Set range with Find method
  150. Text to speech particular cell
  151. sort non delimeted non fixed width alpha numeric column
  152. How do I copy a formula from one spreadsheet to another
  153. [SOLVED] EXCEL WILL CLOSE IF I CLICK PAGE
  154. Macro Modification Help
  155. [SOLVED] Macro Modification help needed
  156. EULA keeps popping up after Activation??
  157. Change last number to 9
  158. [SOLVED] Sorting percentages
  159. [SOLVED] Rentacoder project: seeking spreadsheet/script/macro developer.
  160. Exporting to DB2 Database
  161. Text to Rows?
  162. [SOLVED] Missing worksheet menu bar Excel 2003
  163. Expand Selection in Auto filter
  164. Formula for Serial Date n+2 +2 +3 +2 +2 +3...
  165. [SOLVED]: how to get microsoft word to do math eqations.
  166. [SOLVED]: Moving Cursor after Cell Entry
  167. insert rows based on criteria
  168. [SOLVED] recovering overwritten Excel workbook
  169. [SOLVED] some exotic error
  170. [SOLVED] [SOLVED]: Array with Sum and multiply
  171. [SOLVED] [SOLVED]: percentage computation
  172. [SOLVED] VLOOKUP - Referencing seperate workbook getting #N/A erros
  173. Help!
  174. Count Unique Items
  175. Need help using solver
  176. Option Button Value Zero?
  177. Pull Information from one sheet to another
  178. [SOLVED] I am trying to find a function for a list
  179. Formatting or removing data within a column
  180. format cells
  181. Formatting
  182. Lookup Question
  183. [SOLVED] Excel form
  184. Once a column is marked as $, how do I change it back?
  185. x-axis value setting
  186. Custom Sort of Filter?
  187. [SOLVED] copy hyperlink to clipboard
  188. [SOLVED] Preventing row numbers from sorting
  189. [SOLVED] Autofilter problem unresolved
  190. After print preview it changes the format, what could it be?
  191. [SOLVED] Hide Middle Levels
  192. [SOLVED] Sumproduct criteria
  193. [SOLVED] Loop Check for Workbooks already open
  194. Average exluding max and min values
  195. [SOLVED] SUMIF being used properly?
  196. What type of formula should I use?
  197. SUMIF function being used properly?
  198. cell format printing
  199. vat formula
  200. [SOLVED] range.value changes
  201. Macros
  202. [SOLVED] HOW TO SAVE AS DATABASE III A 2007 EXCEL FILE?
  203. [SOLVED] hyperlink to word
  204. [SOLVED] Conditional Saving
  205. [SOLVED] Formula R1C1
  206. How to do it - please help me! Urgent.
  207. "Combining 2 sheets" - urgent!
  208. Sort in Greek alphabetical order
  209. [SOLVED] INVENTORY CONTROL BY SPECIFIC ITEM
  210. Counting Numbers
  211. [SOLVED] 97 Pop-Up Calendar
  212. Connecting two series in a scatter chart - Excel 2007
  213. [SOLVED] Excel 2003 temporary files remains on network shares
  214. [SOLVED]: Problem using tab in TextBoxes not in Userform
  215. If a value is found return a true/false
  216. multiple cells in a spreadsheet
  217. Left() Need the equivalent of this
  218. [SOLVED] Break Up Data
  219. [SOLVED] Commission Percentage
  220. Why formula should I use?
  221. Conditional Format on another cell's value
  222. [SOLVED] wait for data to be stable
  223. [SOLVED] Excel 2003 VBA - Select a range based on a date
  224. Excel 2003 VBA Assistance needed
  225. Mac Auto-filter
  226. More than 65,536 lines
  227. [SOLVED] VBA for Lookup to other Columns
  228. Can you calculate the number of years between two dates in Excel 0
  229. [SOLVED] Percentage increase of one cell to another in Excel?
  230. Incrementing numbers in a column
  231. add a double digit number together
  232. Making the worksheet.hyperlinks.add method work!
  233. Import Multiple Web Pages
  234. ADO access to excel workbook on website
  235. counting colords cells with letters in them
  236. Dropdown Menu?
  237. How to calculate Stochastic Oscillator within Excel?
  238. [SOLVED] Import data from zip file through Internet
  239. Search with "Workbook" and "columns" built-in somehow?
  240. [SOLVED] Macro to reset Validation box
  241. Sum for two criteria
  242. [SOLVED] training tracker
  243. [SOLVED] Conditional Formatting
  244. vlookup question
  245. Deleting sheets within a workbook
  246. [SOLVED] Auto-filter with Sum product?
  247. Sumproduct with autofilter
  248. Referencing Icon Sets
  249. How do I change my Display Name?
  250. Array Range