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. Excel Sidebar interface Error
  2. merging sheets to one
  3. today() help
  4. Partially splitting cells
  5. Creating a drop down list that is based on the contents of another cell
  6. negative time
  7. Automating an MS Access to Excel query
  8. Trouble getting a "0" not to show
  9. Excel XP file goes into endless loop in Excel 2003
  10. Help with dates formulas please
  11. Urgent help with this logic
  12. Quotation Project
  13. copying cells at a specific interval
  14. I did something stupid, please help (menu bar)
  15. counting number of dates AND check for true false
  16. sumproduct vs lookup
  17. Excel Favicons?
  18. Hyperlinks - Any utilities or shortcuts to expedite the process?
  19. How can I retrun month name from a number
  20. ctrl+c
  21. Min excluding zero's
  22. "Set print area" problem
  23. DateDif
  24. Seeing text in the left hand column...
  25. Multiple Data in One Cell
  26. Rounding to next friday or two or three...
  27. Excel updating source data issue...
  28. database problem in excel
  29. Choosing which sheets to be accumulated
  30. Customised toolbox with macro buttons
  31. formula logic..please help
  32. Format only 2 columns to CAPS
  33. Probability Simulation
  34. Sort question
  35. AutoFilter and uncontinuous data obtaining
  36. COUNTIF Help?!?
  37. statistical function
  38. formula problems!
  39. Automatic vs Manual Calculation
  40. Combine different rows cells to create an new row - Flight Leg vs Flight Segment
  41. Referencing and sorting via data sheet which filters itself
  42. Web Queries
  43. tranferring/compacting data in new column
  44. Reporting with MSQuery in Excel - how to preconfigure one to ship?
  45. Lookup
  46. Excel 2003 glitches??
  47. Excel 2003 Com Addin question
  48. Reconciling and merging 2 tables with almost identical 1st two columns?
  49. lookup problem
  50. I am new to excel and need some help.
  51. Rownddown?
  52. IRR Problem
  53. Sort by state?
  54. lookup based on two columns
  55. Date stamping entry into a cell
  56. using date range in formula
  57. Smaller font
  58. Referencing another spreadsheet
  59. Copying Forumulas down a column - HELP!
  60. Excel/Word selection formatting issues
  61. Excel 03 - Pivottable - Group by Day/Year
  62. Date Format Problem
  63. Cell Change Private Sub
  64. Batch Import External Data?
  65. count the row from my vlookup number to zero
  66. Sales Commision Help
  67. Column continuity and page break prob; now taking epic proportions :-)
  68. update not functioning???
  69. Filtering blank rows from a column
  70. need help using vlookup function
  71. Moving Macros Around
  72. Is it possible to change and entire sheet to Upper case???
  73. Locking cells problem
  74. Help with vlookup/match function
  75. Financial Functions
  76. Command Button - Insert Lines
  77. And if
  78. Calculating Data Once
  79. Copy information from one spread to another file
  80. Question About averaging numbers Read below.
  81. Paste
  82. Calculate
  83. Return cell value
  84. huge spreadsheet-need to track adds,dels,$changes
  85. Deleting selected rows using InputBox?
  86. Copy ranges of formulas w/ sheet ref. but w/o wbook address to other wbooks
  87. "calculate"
  88. Need to find next empty column-VBA
  89. Insert Row with Copied Formulas
  90. Is this impossible, logic genius required.
  91. Drop Down Menu
  92. change cell value and not change formula
  93. Using forrmula on whole column yields 1171 pages!!
  94. Countif Validation question
  95. sheet2!A1 to reference sheet1!A1 at all times
  96. Assigning a locale to an Excel-file
  97. macro for merging cells.....
  98. Combining strings of numbers and ordering them
  99. User form read only question
  100. Startup workbook no longer opening
  101. Naming a sheet to equal a cell
  102. Read Pdf files from excel??
  103. Is it possible to auto-fill cells based on a validation?
  104. Filling the numbers
  105. Enabling/Disabling a Series of Macros Buttons
  106. Opening a file using a macro based on a file name held within a cell
  107. split text
  108. Conditional Formatting
  109. Help - Format of ISNA
  110. Coding a list
  111. Search a space starting from right.
  112. Additional Zero's in front of a number
  113. Choose data from different sheets using one input cell?
  114. VBA & Conditiona Formatting
  115. Referencing different pages in another workbook
  116. Conditional Formating
  117. Cut - Special paste - Transpose ?
  118. Field Codes for Excel?
  119. I grew up with VisiCalc - Excel throwing me
  120. Drop down issues
  121. Dynamic Range won't maintain my formula
  122. Cell doesn't take my font color change
  123. vlookup on multiple references
  124. Copying values
  125. Confused.Com
  126. Controlling Word 2003 documents in Excel 2003
  127. auto hide and protect columns
  128. how to download information from bottom to top
  129. Theory question
  130. Linking and updating cells between workbooks
  131. Format and Delete
  132. Format font case in range
  133. Question about locking MACROs
  134. Bloating when removing $ character
  135. populating columns in excel depending on a selection
  136. Sum formula or macro
  137. Timesheets
  138. dates
  139. Saving
  140. Keeping a column or row in view all the time.
  141. Comparing 2 worksheets
  142. Find column index
  143. Copying Conditionally Formatted Cells and cell references
  144. Inserting spaces into cells
  145. Import is single column; want multiple columns
  146. I want (8) to appear like (8) not like -8 in a cell
  147. Keeping preceding Zeros.
  148. =if, Forumla help
  149. Creating Export to Excel feature on web site
  150. Option Group Box question
  151. calculating length of service within age bands
  152. Pick the earliest date from a selection of dates...
  153. Dynamic Links??
  154. Is there a function that returns the first value in an array?
  155. One button number increase
  156. Print specific number of pages?
  157. Commandbutton Question.
  158. More questions re: option boxes
  159. Count Unique
  160. Help with Month specific formula
  161. Enabling Edit>Paste when a textbox on a protected form has the focus.
  162. Two graphs types on one chart
  163. high and low level part numbers
  164. Excel Cell's Are Not Lining Up Correctly
  165. Stop printing sheets by default
  166. Tab Titles
  167. How do I attach an Excel Worksheet to an email?
  168. Sumproduct problems with #N/A
  169. how to divide time with a number?
  170. Problems with Edit Menu
  171. Using VLOOKUP to return multiple results for the same lookup value
  172. Incrementing value of a cell.
  173. Need help with IF function in Excel
  174. WorkSheet Name
  175. payroll formula
  176. Urgent help on this logic
  177. creating an if statement using the internal date
  178. Formula
  179. Macros How to...
  180. Headers and Footers / getting command of 'em
  181. How to add "00" to "52002"?
  182. transferring data from 1 sheet to another.
  183. Formula issue
  184. Return a list of unique matches (data source file different from formula file)
  185. Possible to add space between rows?
  186. Highlight an entire row and a search query
  187. Removal of Hyphens from Number or Text formatted cells
  188. Conditional formatting, more than 3 options
  189. Need Option Button help please
  190. How to Paste only displayed number values?
  191. Need some basic direction
  192. Mortgage Pmt Comparison
  193. Save As CSV commas stop after 16 rows
  194. Sorting Issue
  195. Is there a way to set up a column with same formula w/o manual entry?
  196. Freeze Panes - Freeze Tabs
  197. Filtering Issue - Pls Help
  198. Validating Data
  199. Convert Excel worksheets to PDF. Help
  200. Excel is not asking me if I want to save...
  201. Help With Formula
  202. Is there a way to Copy "if"?
  203. data table print outcome
  204. embeding another programme into excel
  205. Combo box trouble
  206. Repeating rows
  207. vlookup using absolute cell references in VBA
  208. backup /linking
  209. Import external data......from clipboard?
  210. filtering list into workbooks
  211. Using Excel to Diplay Data - Font
  212. Printing: Page break preview - need help
  213. Web Query Help
  214. Date and Time Concatenate Help
  215. How to add hours?
  216. Need formula
  217. Stripping text from a cell
  218. Please help Again
  219. Mysterious Macro!!! Please help
  220. How do add hyphens to a number? 0052002 to 005-2002
  221. days left till contact
  222. I'm stuck on how to do these formulaes
  223. Print moves objects
  224. Pull Info From Internet
  225. curses, stumped again
  226. Name working
  227. Weird Bug
  228. Cell Spacing
  229. Linking rows
  230. Thousands separator in hours format
  231. Convert months to months and years
  232. Upper and Lower case in a Count
  233. pivot table
  234. linking a combo box to a text box
  235. keyboard shortcut for search
  236. retrive the distance between any two cities from distance table
  237. Exceed 255 characters on a text box on a form
  238. update/refresh problem
  239. Macro to save "A2" in preset directory
  240. Can't select a single cell but a whole range is highlighted.
  241. searching feature
  242. sum matching cells
  243. making cumulative return graph change automatically
  244. correlation function with offset function in it
  245. SUM every other row/column?
  246. easy excel question
  247. Getting External Data.. New Web Query
  248. autofill the column cell down the row
  249. MSN Query help needed
  250. linking sequential data between worksheets