PDA

View Full Version : Excel Miscellaneous


  1. workbook sheet form editing
  2. Greater than Less than in embedded IF statement
  3. [SOLVED] Extracting data between parentheses
  4. =IF (cell color) then?
  5. Sheet Tab Names
  6. Massive file size even when empty
  7. [SOLVED] min value with format
  8. Conditional Format A Bubble Chart
  9. [SOLVED] Copy Values not Formulas
  10. How do I link multiple cells to edit parts of an embedded object?
  11. Return a consolidated array?
  12. How to add icon Reset print area?
  13. How to defined date 3 days before real start of project?
  14. How to start excel file after windows XP starts?
  15. How to change colour of value in cell if there is more than 0?
  16. How to notify per e-mail if excel shows less than 0 in cell?
  17. Importing CSV files
  18. Book for Pivot Tables for Excel 2000??
  19. Lost cells in worksheet
  20. [SOLVED] Reverse pivot table
  21. Event study
  22. Using =SUMPRODUCT with Multiple Criteria
  23. how to separate data from 1 column to 3 column
  24. combination of cells = given total
  25. [SOLVED] Lookup
  26. Unwanted formatting of downloads
  27. Lookup Question
  28. Auto Data Search and Entry
  29. Calling a macro from SOLVER (Excel 2007)
  30. Summing between known characters #2
  31. Statistical Analysis
  32. [SOLVED] Summing between known characters
  33. Summing Totals of Quantities
  34. [SOLVED] using vba to reference column headers
  35. drop down list help
  36. VLOOKUP: ignore first 58 characters in cell, return value, export XML
  37. Row Duplication
  38. Thread moved to programming please ignore
  39. Text to Columns
  40. Counting within a list
  41. [SOLVED] External data directly into an array
  42. [SOLVED] Finding sums using conditionally formatted cells
  43. Excel 2003 does not remember user defined options
  44. chart
  45. excel format csv
  46. How to arrange Many check boxes
  47. [SOLVED] Formula for two column sum
  48. Checkbox To Enables or Disables a Button in Userform
  49. Conditional Formatting
  50. Auto Copy Contents of 1 WS to Another Based on Value of 1 Cell
  51. Select particular column
  52. [SOLVED] count values from same dates in list (without VBA)
  53. combining data from multiple tabs inc colour of cells
  54. Format a specific cell to be written only in English
  55. Conditional_formatting
  56. Microcharts
  57. 3-D chart losing the fronts of the columns
  58. Comparison Site Question
  59. [SOLVED] Phone Numbers
  60. [SOLVED] Autofill cell references
  61. Classify by textcolour?
  62. How to find out Remaining time clock and escalation
  63. [SOLVED] Manipulating Dates and Format
  64. Formatting
  65. Grey "Split" bar disappeared...
  66. "Last Modified" Problem
  67. Excluding formatting from print output
  68. Using a function to select a cell
  69. Vlookup not returning all values
  70. Finding streaks in large sets of numbers
  71. [SOLVED] averaging problem
  72. [SOLVED] Conditional formatting with < symbol
  73. Objects to becom one object
  74. Linking cells in the non-usual order
  75. IF-ELSE Question
  76. Command buttons for filtering
  77. How to add listbox with size in cell?
  78. How to block empty cells within excel?
  79. Count_Question
  80. how to add text in beginning/end of each row in excel
  81. How to arrange 2nd column according to 1st column?
  82. Auto-populate with one day prior to "today"
  83. [SOLVED] Put Find code in Loop to find all matches
  84. [SOLVED] How to write a macro for command button
  85. Saving_calculation
  86. convert all my data to new format with Macros!!!
  87. waterfall_calculation
  88. [SOLVED] Index/Match formula to find multiple data
  89. Validate multiple Date and Time for getting TAT
  90. Tat
  91. [SOLVED] Accessing data from a closed workbook w/formula
  92. [SOLVED] Compare Two Lists
  93. Percentage
  94. count_within_time
  95. Date Validation to get perfect TAT
  96. vlookup on multiple workbooks into 1 main sheet
  97. Speedometer guage
  98. Macro will not work
  99. need help on a short program
  100. Need help! Limited Columns
  101. How lookup numbers between range numbers in 1 cell ?
  102. [SOLVED] COUNTIF date will expire in a date range
  103. Progress_Tracker
  104. need help very urgent
  105. Pivot from two worksheets
  106. Merging cells without losing zeros
  107. Timetables printout question
  108. Refrencing Dates in excel 2007
  109. multiple_countif
  110. Vlookup problem - Getting error results
  111. Data entry / cell format problem?
  112. [SOLVED] Ranking Numbers
  113. Vlookup not working
  114. Pivot table on a formatted date returns date to origin code
  115. [SOLVED] reference a cell then reference the next row and overwrite the new cell reference
  116. Regional Dates
  117. cell data
  118. How to get the number of rows or columns in a merged cell?
  119. How to make value 1 if there is NOT empty field?
  120. Excel 2007 Lottery Spreadsheet
  121. can the text of two cells be combined with merge
  122. [SOLVED] upside down
  123. How to import files "MP3" to Excel or other files ?
  124. Conditional Formatting & Finding Duplicates
  125. Send mail error
  126. [SOLVED] Disabled VBE and Macro button on workbook open
  127. Deleting row using excel 2007 causes data to loose
  128. Why it does not detect text inside field?
  129. Matching Data Between Sheets
  130. [SOLVED] trying to open a spreadsheet locks up Excel
  131. finding values on a graph
  132. SEARCH function returning cell ID
  133. Counting IFs?
  134. Tabs management
  135. display .43 instead of 0.43?
  136. Entering Date in merged Cells
  137. [SOLVED] Whose birthday this month?
  138. Why is formula with error?
  139. Extracting Particular from a cell
  140. Set colors depending on cell value
  141. D v d cover
  142. Applying Vlookup on cell characteristic
  143. creating subtotals outside a pivot table
  144. [SOLVED] Copy numbers out of a list of errors
  145. [SOLVED] If formula with multiple true instances
  146. Protect Data Validation
  147. how to keep data before auto recalculation
  148. [SOLVED] cells shows month & day only?
  149. Conditional formatting by date
  150. Defining a Variable Range
  151. [SOLVED] Find Cell Value
  152. "Flatten" an Excel File
  153. Hide #DIV0! With a formula
  154. Get rid of duplicates in an comma array in one cell
  155. Batch file to open the most recent excel file
  156. [SOLVED] Number Formatting
  157. Copy column values to a row
  158. Auto Generate Ticket Numbers
  159. If(A1=1;"show image") ???
  160. How can i match numerics(with decimals) in text with numbers
  161. [SOLVED] Convert file PDF to Excel
  162. How to create script to convert the DOC file into Excel file
  163. Configure Pivot Table Print/screen output
  164. Add Combo Box to a Sheet
  165. Cell Link to workbook
  166. printed sheet in different format than worksheet
  167. [SOLVED] Sorting column by contents of every 7th row
  168. [SOLVED] Formula yesterday's date
  169. Repeat names in pivot table
  170. formula not finding data
  171. Summing problems
  172. [SOLVED] Adding values reference to date today
  173. [SOLVED] How to protect worksheet and have the "Group and Outline" func usable?
  174. Show Textbox Caption
  175. Vlookup
  176. [SOLVED] Vlookup not returning values
  177. [SOLVED] Login - Logout report
  178. [SOLVED] How to add a row collapser and expander
  179. problems with copying and special pasting
  180. guide me to learn macros.