Play Friv Now - Play Friv Games

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

View Full Version : Excel Archives



  1. [SOLVED] How would you do this calculation?
  2. Get External Data
  3. [SOLVED] Hide rows in EXCEL
  4. FORMULA VS VALUE
  5. [SOLVED] Index Help
  6. [SOLVED] Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003?
  7. [SOLVED] format a cell
  8. [SOLVED] Pivot Table Trend Limes
  9. [SOLVED] Can I Turn PivotCache Refresh (Calc) off & on in VBA?
  10. Suppress @VALUE! on a template.
  11. [SOLVED] 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. [SOLVED] MACROs Are Turned Off
  16. Automating to autofill column B based on column A entry
  17. Capitalize only first letter in sentence
  18. [SOLVED] do not delete "0"
  19. Assigning Range Names using VBA and R1C1
  20. [SOLVED] 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. [SOLVED] rows to repeat at the top
  25. [SOLVED] Can't use arrow keys when manuvering through Excel 07
  26. Macro I think????
  27. [SOLVED] Header rows
  28. [SOLVED] Fixed Decimal QHelp
  29. [SOLVED] Write a row to a email
  30. Margin Lines in Print-Preview Mode
  31. Shaded Cells and gridlines
  32. [SOLVED] I have to rewrite the following for Excel 2003
  33. Copying Formula
  34. will Vlookup work for this...
  35. [SOLVED] Validation Question
  36. [SOLVED] Function to return a range of cells from a PivotTable
  37. Count if formula error
  38. [SOLVED] Two color fill between two lines
  39. [SOLVED] 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. [SOLVED] Hlookup, range_lookup parameter
  45. [SOLVED] Text box format missing when saved from 2007 to 2003
  46. [SOLVED] Excel 2007 - Can't scroll thru worksheet
  47. index help
  48. [SOLVED] Summing random cells as you click on them
  49. [SOLVED] Command button
  50. [SOLVED] Pivot Table Help
  51. need to turn a word into numbers (or ascii codes)
  52. [SOLVED] IF statement to generate nothing
  53. [SOLVED]: center table on page
  54. [SOLVED] Need help
  55. [SOLVED] MICROSOFT OFFICE 2007 HOME & STUDENT
  56. [SOLVED] Mailing Labels
  57. Where can I find Tools : Data Analysis : Regression in Excel (Vist
  58. [SOLVED] Can I create a statement from a spreadsheet
  59. [SOLVED] 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. [SOLVED] 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. [SOLVED] Pivot table - How To Obtain a External data Source??
  69. [SOLVED] 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. [SOLVED] Sum of each row.
  74. Hyperlinks stopped working
  75. [SOLVED] Data Validation Custom with V Lookup
  76. [SOLVED] Tracking Changes
  77. Text to data
  78. [SOLVED] Convert American Date to Australian Date format
  79. =TEXT()
  80. [SOLVED] how to resolve incompatibility of saving an excel to csv format
  81. [SOLVED] saving an excel "print preview" view
  82. [SOLVED] Extract specified fields with criteria from Excel.cvs workbook
  83. [SOLVED] Monthly Bill Payment Running Totals
  84. [SOLVED] AUTO FILL ADJACENT CELL WITH SPECIFIED VALUE
  85. [SOLVED] Extract first word for a highlighted selection (non contiguoes)
  86. [SOLVED] creating checkboxes and radio buttons in excel
  87. Vlookup??
  88. [SOLVED] Chart Formating
  89. CF for specific ranges of time for an entire column
  90. Multi threaded calculation (multi CPU) - impact on calculation spe
  91. [SOLVED] If result of formula is zero disgard it?
  92. [SOLVED] MAX() of a range of negative values?
  93. [SOLVED] Using a cell in the worksheet as a range in a VBA routine
  94. [SOLVED] Charting Text
  95. [SOLVED] Totalling data used in drop down boxes?
  96. [SOLVED] is this not working because i am using 03?
  97. [SOLVED] I could not opened Excel 2002 files from Windows Explorer
  98. Default charts changed from 2003 to 2007
  99. [SOLVED] Hyperlinks to show on top left corner of screen
  100. [SOLVED] pick list and Data Validation
  101. [SOLVED] Converting RTF file into TXT file
  102. [SOLVED] 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. [SOLVED] cross referencing 2 workbooks at same time
  107. Formula Problem
  108. [SOLVED] 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. [SOLVED] 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. [SOLVED] Can someone help with this problem please
  128. [SOLVED] Custom Color Palettes
  129. [SOLVED] Web query causes excel crash!
  130. [SOLVED] IF value = "DEC" or "MAR" cut and paste 3 cells
  131. [SOLVED] 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. [SOLVED] Running a Macro when cell value is a specified value
  137. [SOLVED] 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. [SOLVED] 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. [SOLVED] 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. [SOLVED] 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. [SOLVED] Macro Modification Help
  155. [SOLVED] Macro Modification help needed
  156. EULA keeps popping up after Activation??
  157. [SOLVED] Change last number to 9
  158. [SOLVED] Sorting percentages
  159. [SOLVED] Rentacoder project: seeking spreadsheet/script/macro developer.
  160. Exporting to DB2 Database
  161. [SOLVED] 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] [SOLVED]: how to get microsoft word to do math eqations.
  166. [SOLVED] [SOLVED]: Moving Cursor after Cell Entry
  167. [SOLVED] 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. [SOLVED] Help!
  174. [SOLVED] Count Unique Items
  175. [SOLVED] Need help using solver
  176. [SOLVED] Option Button Value Zero?
  177. [SOLVED] 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. [SOLVED] format cells
  181. [SOLVED] Formatting
  182. Lookup Question
  183. [SOLVED] Excel form
  184. Once a column is marked as $, how do I change it back?
  185. [SOLVED] 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. [SOLVED] 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. [SOLVED] cell format printing
  199. vat formula
  200. [SOLVED] range.value changes
  201. [SOLVED] 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. [SOLVED] How to do it - please help me! Urgent.
  207. [SOLVED] "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. [SOLVED] Connecting two series in a scatter chart - Excel 2007
  213. [SOLVED] Excel 2003 temporary files remains on network shares
  214. [SOLVED] [SOLVED]: Problem using tab in TextBoxes not in Userform
  215. [SOLVED] If a value is found return a true/false
  216. [SOLVED] multiple cells in a spreadsheet
  217. [SOLVED] Left() Need the equivalent of this
  218. [SOLVED] Break Up Data
  219. [SOLVED] Commission Percentage
  220. Why formula should I use?
  221. [SOLVED] 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. [SOLVED] Excel 2003 VBA Assistance needed
  225. [SOLVED] Mac Auto-filter
  226. [SOLVED] More than 65,536 lines
  227. [SOLVED] VBA for Lookup to other Columns
  228. [SOLVED] 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. [SOLVED] Incrementing numbers in a column
  231. add a double digit number together
  232. [SOLVED] Making the worksheet.hyperlinks.add method work!
  233. [SOLVED] Import Multiple Web Pages
  234. [SOLVED] ADO access to excel workbook on website
  235. counting colords cells with letters in them
  236. [SOLVED] Dropdown Menu?
  237. [SOLVED] 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. [SOLVED] vlookup question
  245. Deleting sheets within a workbook
  246. [SOLVED] Auto-filter with Sum product?
  247. [SOLVED] Sumproduct with autofilter
  248. [SOLVED] Referencing Icon Sets
  249. [SOLVED] How do I change my Display Name?
  250. [SOLVED] Array Range