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. A Few Add-In Problems
  2. Boosting the scope of Large-, MIN- or AVERAGE difference-formulae with some more cond
  3. Stumped on what should be a simple answer
  4. Open excel in new window?
  5. More than 3 conditional formats
  6. divide hours
  7. copying cells
  8. Finding an alpha numeric close match
  9. Sorting problems...
  10. Quick Help with a formula
  11. Not enough power, RAM or what?
  12. Random line showing up on spreadsheet
  13. help please
  14. Formula help
  15. Macro help
  16. Need a little help
  17. Bashing Data Lists in EXCEL 2003 - Pls Help
  18. Displaying toolbars based on UserName and Workbook...?
  19. Header & Footer
  20. Formatting my cell contents
  21. Creating constants - Getting text entries to be calculated as numbers
  22. Counting records by department
  23. "A65536" what does it means...
  24. Problem with Tools>Options...
  25. Problems adding time formats
  26. How can i save specific cells onto another sheet??
  27. Before Save Macro
  28. Active Cell
  29. passwords??
  30. Is an array formula tha answer
  31. Blank cells but commas in Notepad
  32. Running Macros Automatically
  33. formulas displaying and I don't want them to!
  34. simple question
  35. how do i mail merge sort of report?
  36. vlookup help
  37. Changing Font etc in a Validation list
  38. pivot table results
  39. How do I get the drop down arrow to stay
  40. filter and copy
  41. how to SAVE AS ZIP FILE
  42. =IF(L7=-100,E7,W7) <-- problem totalling
  43. Emailing sheets.
  44. selective totalling
  45. if theories???
  46. Ignore values
  47. hide & unhide sheet
  48. Disable calculation on selected sheets only
  49. Have toolbar automatically open on user's machines
  50. Drop down list
  51. COUNTIF not like
  52. Ctrl + F, change cell colour
  53. vlookup?
  54. Quick question
  55. Adding Color Shading to a Cell is Cell is Blank Automatically
  56. correlation matrix
  57. How is this done?? don't know french
  58. How do I
  59. countif function to count text numeric data in same cell
  60. Excel file with macros won't run in IE7
  61. Adding Names to the next empty cell..Pls help!!!!
  62. Some VBA
  63. How to ignore formula in a cell
  64. Worksheet calculation
  65. pivot table
  66. Finding multiple instances of the minimum value
  67. Grouping and Levels
  68. finding references before deleting a sheet
  69. Selection prints on one page
  70. Converting Time i.e. 7:24 to Decimal 7.4
  71. Extract 1st letter from each cell??
  72. Accounting Guru Needed / Excel or Programming
  73. Summing the same cell
  74. Absence Tracking (97-2000)
  75. Kill autoformat when importing external data
  76. Excel 2002 disappearing on startup
  77. Email Macro: File Name Is Subject
  78. Cross platform issue
  79. Finding the data in the database
  80. Need VBA Help
  81. Pivot Table Question
  82. Auto Filter
  83. Help with .exe extension on Excel
  84. Solver Frustration
  85. help with lookup
  86. IF - Combines Some Ands & a OR - Problem
  87. Colors will not show on screen?
  88. Address splitting
  89. Locking Date
  90. SUMIF with dual criteria?
  91. Time cards
  92. character count
  93. Print only used area
  94. Protection
  95. Do not return zero if cell is blank
  96. Help with merging cells
  97. Random sample
  98. Text Length
  99. Help with = if forumulas
  100. repeating macro
  101. Problems with Conditional Formatting
  102. removing hyperlinks
  103. Control boxes disappear after opening sheet
  104. Clear multiple cells
  105. Attaching images
  106. Using a look up table.....
  107. Changing the number of cells calculated
  108. Using Relative & Abolute addressing
  109. Combo boxes - can I type data directly into a combo box??
  110. General problem
  111. Passing cell in macro -- better way to write this???
  112. Cell referencing
  113. Conditional formatting
  114. Exponential Number to Text
  115. Converting second counter to date
  116. Worksheet to Worksheet
  117. Problem with a pivot table in my macro
  118. Sorting Multiple Worksheets
  119. Excel Web Page File Size
  120. Counting Unique Occurrences in a Database
  121. Importing from PDF
  122. Excel: tallying results
  123. Importing comma separated email addresses into excel
  124. Tracking students progess in Middle school
  125. IF, DATE? pension multiple criteria...
  126. Value instead of formula
  127. String comparison
  128. Hiding or unhiding a picture
  129. Too many text characters
  130. Macro for Saving and Closing Program
  131. Formula or maybe Macro?
  132. row coloring question
  133. filters
  134. Need Help for Time Calculation
  135. Sorting by Team
  136. Filtering based on first 2 numbers in sequence
  137. macros
  138. Advanced Filter
  139. Don't know if this can be done
  140. Passing a cell/worksheet/workbook in a macro
  141. Locking Cells for auto filter?
  142. Formual vs Value
  143. read non specified text to return numerical value
  144. Countif in a Pivot Table?
  145. Deleting Charts using macro
  146. Sorting
  147. VLookup Blank Help
  148. Formula to copy and paste the only occurence of 2 characters together
  149. Formula if> then <
  150. Colorcoding cells
  151. How to clear zeros
  152. Find and Replace Text with If Then Condition
  153. File dependable picture in Excelsheet
  154. count length for each line in one cell
  155. How do i please add seasons to a reference?
  156. Automatic data refresh
  157. How do I refer to a range of cells across ALL worksheets
  158. Help with Macro's and locking/disabling cells!?!?
  159. Finding the last non blank cell in a row
  160. IF Statement
  161. No. of sheets in a workbook???
  162. Batch stock info lookup in Excel 2003
  163. help with Pivot Tables
  164. Tabbing to and from a combo box
  165. Static Header row
  166. If Statement
  167. Statistics in Excel HELP!
  168. Scrolling Issue
  169. Finding unique combinations of data
  170. formulas in 1/4 increments?
  171. Date Converting Incorrectly HELP!
  172. No duplicates in 2 columns on 2 different worksheets.
  173. Ranking in alphabetical order
  174. count down minutes
  175. Link Spreadsheets - Merge Data
  176. Help with dates please - novice alert!
  177. Re-arrange rows by column
  178. Reference Another Sheet
  179. Average Function with Rounding
  180. User Form Help
  181. No data source specified error
  182. Paste Special Question
  183. Printing column headings
  184. inserting long formula in macro's
  185. Macro question
  186. Excel number formatting messed up in large sheets
  187. Isn't Excel RGB friendly?
  188. Sorting Numerical data..
  189. Help with dates
  190. Applying function to a column
  191. Linking sum totals between two workbooks
  192. Help with formula
  193. Excel with Apple
  194. Need help on payroll sheet
  195. Auto displaying comments of protected cell
  196. Pedotti or butterfly diagram using excel charts
  197. Function?????
  198. use cell content as cell address in formula
  199. Refreshing Pivot table problem?
  200. Rounding numbers to specific integers
  201. Using a function in a reference
  202. Macro Help
  203. Combining sumif, subtotal with filters?
  204. Computing conditional probabilities, comparing with chi-square test
  205. copying text to another sheet
  206. Column printing headache
  207. cut and paste conditional formatting ?
  208. Scenario
  209. How to do a function with Fifteen Ifs
  210. Help Required
  211. Sort Button to sort a column?
  212. Problem with figuring this out?
  213. getting data from multiple columns into 1 column
  214. How do I save a pivot table and
  215. Hyperlink: Open file in text editor, regardless of association
  216. Dynamically create reports
  217. Prompting
  218. text
  219. finding breakpoint
  220. #N/A error
  221. Calculate Miles per hour
  222. Protect Worksheet
  223. linking data from network users folder
  224. Need help with creating a commission worksheet
  225. List Management
  226. Delete rows using macro
  227. Time question
  228. Sumproduct, or Index / Match Formula
  229. Protection of validation list cell entry
  230. Resize the comment window
  231. Help turn some rows into into columns
  232. enhanced hours
  233. Fibonacci Calculator
  234. My formula no longer works?
  235. Filter based on whether a cell contains numbers
  236. Column & Row Auto Hide
  237. Aligning similar data in several columns
  238. Comparing Lists - F2 - Format Cells
  239. Skip Blanks in Paste Functions
  240. Excel Formatting Help
  241. true "ghost" mystery
  242. Summing whole numbers leaves fractions?
  243. SUMPRODUCT and named ranges
  244. Heat Map - shaded activity chart
  245. make link / anchor
  246. Deleting Charts
  247. F2
  248. Another "IF" function question
  249. using VB in excel
  250. conditional update to date field