PDA

View Full Version : Excel Miscellaneous


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

  1. Scrollbar
  2. Data Validation - dependent lists
  3. Variable in path of the hyperlink
  4. Cut, Paste, and Delete
  5. Macro Code issue
  6. Extract data from a formula
  7. IF and CONCATENATE issue
  8. Macro Question: Leaving the cell blank but allowing the macro to run
  9. Date Change in macro
  10. Removing Zeros
  11. Cell containing it's workbooks' filename
  12. Pulling data from other sheets?
  13. Hide numbers in Pivot table
  14. Getting Minimum and maximum level from a cell
  15. Creating multiple identical worksheets
  16. MS Query Not Auto Refreshing
  17. Find A Value On Specific Date – In A Date Range
  18. Consolidate some data from other excel files to a master list
  19. How to convert negative values to zero?
  20. listing problem
  21. How to write code to search for a desired string in external independent excels files
  22. Sort names automatically
  23. conditional find and replace
  24. PrintScreen as XL VBA event
  25. Automated Template Creation
  26. tally score
  27. Data Validation
  28. InputBox
  29. Multiple Date and Time Calculations
  30. automating cut and paste?
  31. Objects
  32. Last Modified Date
  33. Range name on multiple sheets
  34. Conditional Formatting
  35. Drop down list (color)
  36. Sum Function
  37. scientific notation
  38. #Ref Error
  39. define/name a range based on a formula?
  40. DLL function Declaration
  41. index and match
  42. Is (not a number)
  43. Leading Quote in Text Strings
  44. Sum not showing
  45. New spreadsheet getting information from an existing document.
  46. Conditionally assigning number of decimal places displayed
  47. Linking cells in two directions
  48. Grpahs Using VBa
  49. Converting Week to Date
  50. validate multiple text entries based on a formula
  51. finding number of days between dates
  52. Sorting Worksheets Tabs
  53. SUMIF 3D across multiple workbooks
  54. how to find missing sequence
  55. how to add date of entry for each new row automatically?
  56. Copying data from one worksheet to another....
  57. Data you'd like to see in Excel?
  58. Date Formats
  59. How to mass extract http links out of excel columns
  60. Linking multiple cell data to a single cell
  61. Graphs
  62. Drop Down Lists: change neighboring cell
  63. Open Files Separately
  64. Microsoft Access
  65. IndexMatch w/3 (or more) criteria
  66. newsletter style printing
  67. Many to one
  68. Custom Lists in Excel where data contains a Comma....
  69. Break-even Tool?
  70. Check boxes, and Conditional Formatting
  71. Pivot Table - Top 10 Autoshow
  72. Save changes
  73. Ascending Number Querry
  74. Mark Where A Phrase Appears Twice
  75. Relative values
  76. name list
  77. Convert old excel version formulas to 2003
  78. Character Limit applied to each cell of a sheet when opened through another sheet?
  79. Taking values from cells for use in Macros
  80. Sumif
  81. Change number to date
  82. How to copy from one sheet to another
  83. sumproduct?
  84. How to delete an inserted object
  85. Inputbox Uppercase
  86. Object Insert from AutoCAD
  87. Line that expands/hides columns
  88. Index / Match - Formula
  89. Separating name from a cell.
  90. Copy row of data
  91. Don't paste empty cells???
  92. adding salaries with the same names
  93. VLOOKUP Limitation?
  94. formula error
  95. Conditional Formatting
  96. Data Refresh
  97. blank cells for specific row only
  98. Count Vowels
  99. adding percentage and multipication
  100. Merging Pivot tables
  101. Increment # on print
  102. INDIRECT cell referencing question.
  103. Un-Naming a group of cells
  104. Import Query
  105. rowfilter reads wrong values
  106. Identify Outlook Recipient Membership
  107. Adding Times
  108. Creating a chart of a list of Dates
  109. Excel 2000 Problem opening files
  110. Search and Replace
  111. Sum a column that contains #N/A errors
  112. Textbox Capital Letters Only
  113. totaling figures from multiple sheets
  114. Can I create a formula using concatenate?
  115. SUM Variable Range
  116. Duplicating records by a quantity
  117. IF Function
  118. formula to count cells
  119. Combining 2 conditional formats?
  120. Pivot Table.
  121. Rating of values
  122. Entering text, convert to date
  123. Macro to pull and paste from Access?
  124. auto sort
  125. VLookup
  126. Lookup for Min&Max
  127. all arrangements of 8 letter words with 3 symbols
  128. Date Formula
  129. Memory
  130. loop question
  131. binary search
  132. Tally Tables
  133. Weeknum
  134. Solving for net amount
  135. Save as Tab delimited file errors
  136. Countif
  137. Using IF Functions to Evaluate GRADES
  138. Conditional Max Statement
  139. mid and if functions
  140. Excel database comments export
  141. How can I get the 'as-displayed' value
  142. Finding Specific Data Random Locations
  143. position of graphs using vba
  144. Left and Right Functions
  145. Counting Vowels
  146. Rearreanging Data
  147. Protect Cells But Allow Macros?
  148. Selective copy of data in a range
  149. copying cells from one sheet to the next
  150. averages....
  151. How to update excel templates??
  152. Nested IF??
  153. Send Excel Spreadsheet via hyperlink
  154. Descriptions based on cell value
  155. How to recover overwritten spreadsheet...
  156. How to get rid of a function?
  157. emailing in excel
  158. March Madness Spreadsheet
  159. Setting cells to "Wrap text" makes contents invisible
  160. ListBox
  161. How to take data from multiple cells that are not together?
  162. Color Printing Worksheets
  163. Vlookup not working.
  164. dropdown list
  165. #value!
  166. number format
  167. calculate values in status column
  168. Selective Save
  169. Page set up issues
  170. Save As
  171. Nested IF & AND formula puzzle
  172. Dynamic Numeric Data Sort
  173. Automate daily copying of data from one wksht to another wksht
  174. sheet name in a cell?
  175. Cell value is trying to be a formula
  176. Define Cell Range as C
  177. check here button
  178. Adding Data to a Cell
  179. calculating profit
  180. Replicating Rows to other Worksheets
  181. Insert data from table to seperate worksheet
  182. Countif()
  183. numbers to date
  184. D=R*T --> Convert "Time" to hh:mm:ss ???
  185. Number of weeks from a date
  186. Clipboard
  187. Sorting in worksheet1 affecting worksheet2
  188. Colouring a certain cell depending on the value in another cell
  189. Count on multiple criteria
  190. Worksheet in a Worksheet
  191. Autofilter Problem
  192. Opening Form... window using VB
  193. Save As
  194. Spreadsheet List
  195. Pivot Table - Dates not displayed in date Order - Why?
  196. adding a string prefix/suffix to a cell
  197. Pivot table issue
  198. Numbers sorting question?
  199. trying to make a report card database
  200. conditional formatting
  201. creating new worksheets sequentially
  202. Does Excel DB connection lockout other DB connections?
  203. Pivot Table Exclusion
  204. Format / Merge 'X' qty of Columned Cells where 'X' is a value at start of range
  205. Transposing
  206. activate VBO on entering cell
  207. Problem adding cells with alpha characters
  208. Can I copy color with an equals sign?
  209. Hyperlinking cells
  210. xlDialogSendMail
  211. cell wont calculate
  212. Dependent Validation -- How can I enter information that is not in a named range?
  213. Time format conversion
  214. shift-key issue in Excel
  215. View multiple worksheets
  216. 65536 Lines - More Needed !!
  217. copy formulas
  218. Web Query based on variable URL addresses
  219. Not dragging values, only formulas
  220. Sumproduct(LEFT(Number;1=6)).....
  221. Count COL B where COL B = X AND COL A = Y
  222. Text to Columns but using a formula
  223. Macros for multiple graphs
  224. Conditional Format of column, if cell contains *name*
  225. AVERAGEs
  226. Default date
  227. How to get date intervall in Index and Match?
  228. Userform - Activation
  229. Deleting Rows - a new issue
  230. cell referencing
  231. Unsure what function to use
  232. Finding value in a Table
  233. Convert excel file to ascii textfile
  234. Excel WMF
  235. Pivot table across multiple tabs in a workbook
  236. Pivot Table - Data - Can't Show All
  237. Retreving Numbers Only out of Formula
  238. Subtotal average
  239. Pivot table - Changing OLAP Source
  240. Formula
  241. Linked cell question
  242. Add-in distribution
  243. Unhide 1 specific hidden column
  244. Solution for display require XL area in Powerpoint
  245. Pivot Table - Criteria Totalling
  246. Imbed SQL in an excel spreadsheet
  247. COD2 League Cup Tournament - VERY STUCK
  248. Why is Excel File so large?
  249. forum use questions, where?
  250. seeking Excel Guru..