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. Checking for duplicate entries over multiple worksheets
  2. Thanks for your help
  3. Linking Colums???
  4. Creat Formula for Counting Text
  5. Grid Boxes
  6. Trying to use VBA to Extract emailaddress from hyperlink using ie DOM
  7. IF Formula
  8. How to Generate a calender of Events from data/ Pivot Table
  9. Solver32.dll is unavailable... how do i get it to work
  10. save .xls files to a server
  11. Date format in string
  12. Data Import - formatting
  13. Percentage problem in Excel 2003
  14. MS Query - How Can I Launch It
  15. Can I protect columns w/in a "List" using Protect Sheet?
  16. Formatting the date
  17. Increment Date Based on Number of Pages Printed
  18. Changing default "import" folder
  19. From Macro in Excel find cursor location eg.C7
  20. Create a formula using cell format
  21. Office 2000 Excel Macro runs very slow in 2003, why?
  22. Advanced Filter/Extracting Data
  23. How recover a lost file in Excel 2003?
  24. truncating text
  25. Indirect Formula
  26. Repeatition of the same item
  27. Getting the values of the points in a trendline
  28. Unprotect worksheet is greyed out. How do I make it available?
  29. Customizing Excel's 'Format Cells' defaults - how?
  30. Formatting a cell
  31. Assign charts names in VBA?
  32. Apostrophes in numbers with 16 characters
  33. data validation or message box
  34. Copy/Paste Problem - AndeTech
  35. If I type in 3, I get .003 after hitting enter. All .xls files.
  36. count for empty cells
  37. How do I link data between spreadsheets?
  38. Paste Values
  39. Excel follow question for Ardus.petus@laposte.net
  40. How do I keep blank pages from printing at end of spreadsheet.
  41. Debra Dalgleish
  42. Condontionally format bold cells
  43. saving excel sheet as csv
  44. Excel number format problems
  45. Generate 1-to-1 outputs for a list of inputs into a excel formula
  46. Variable Text on a Button
  47. July 19-21 London Excel User Conference
  48. converting international characters in English in Excel 2003
  49. Counting Problem
  50. Sort using 2 different parameters
  51. Sort using 2 different parameters
  52. Replace function
  53. Linking cells from different workbooks
  54. Linking cells from different workbooks
  55. calculate averages
  56. linking cells
  57. Value part of formula exlusion/ Not affects neg's: value
  58. A calculator for inventory safety stock
  59. How to automate daily interest in a balance sheet?
  60. why is the alignment print different in different computers?
  61. Postging Excel Table on Intranet
  62. How can I collapse Excel data into categories?
  63. Tracked Changes viewing problem
  64. help on INDEX
  65. excel menu inactive
  66. running balances
  67. Look up Data from Worksheet within same Workbook
  68. Why do people use SUM() unnecessarily?
  69. Add info into main body of email
  70. Pls need help with changing data
  71. numerical integration
  72. Stumped on Lookup Function
  73. Page Numbering starting on 3
  74. In office 2003 how can FIXEDSYS font avail in EXCEL & not in WORD
  75. I think this should be pretty simple...
  76. Memory or power issue
  77. How to disable macro prompts for OK in Excel?
  78. Divide by 3
  79. Help Counting
  80. Help Counting
  81. Formula Showing Zero instead of nothing
  82. Hard values to convert to number
  83. I have a small business would like to set up a contact base
  84. Divide by 3
  85. Percent change
  86. Sum total costs for multiple entries
  87. Is it possible to plot discontiguous cells?
  88. Change justification in right Excel header box to left justify.
  89. How can I insert a blank row after every row with data with Excel
  90. 4+ Zip Code Conversion
  91. Why does the cell data print ouside the cell (over the line)
  92. Calculation of named cell ranges
  93. Format cell color based on multiple cell values
  94. Linking to protected worksheet(s)
  95. How to use Add Ins / Formula Colours
  96. calculating the volatility of a stock
  97. Dates Problem
  98. LINE CHARTS
  99. Using '% of Total' in calculated field in Pivot Table
  100. excel macro
  101. Save as prompt missing saving a .csv file
  102. Page Orientation
  103. Filter records in a table to extract to another table
  104. exel list copying
  105. Filter for blanks - nonblanks problem
  106. Why doesn't the automatic fill feature work in excel?
  107. find values that add up to certain amount
  108. Searchable archive
  109. Help with connection macro?
  110. How does this formula work?
  111. blank worksheet
  112. Grand total time between two total cells
  113. Automatic Alphabetize
  114. wrap text function causes data to disappear in cell (visually only
  115. Retrieve a number value from a word
  116. Array Formula to find Average Return
  117. Excel cells change color after reopened
  118. How do I add the option "edit with Microsoft Excel" to toolbar?
  119. Combining multiple length columns to one
  120. macro
  121. Light grey grid-lines
  122. Dialogbox use Pivot or Array Forms?
  123. How to prevent Reviewing Toolbar from appearing constantly?
  124. pivot table - multiple excel sources
  125. how do i print booklet format in excel?
  126. Excel OLAP Connection Settings
  127. Time calculation for attendance, tardy/late to work?
  128. Blank Cells - conditioning format
  129. Gridlines distorting when saving as a web page...
  130. using advance filter when shared
  131. Protect/Unprotect Multiple Worksheets
  132. conditional formating if cell not empty
  133. Insert to a protected doc
  134. What version of Excel comes with Office 2004 for Mac?
  135. Can I insert a pop up window in Excel to ask a ? b/4 closing?
  136. Ranking numbers that are close together with the SAME RANK?
  137. MVP
  138. Disable ActiveX warning message
  139. MICROSOFT VALUED PROFESSIONAL
  140. getpivotdata having multiple items
  141. Calculated fields
  142. In Excel the colums which used to be A,B,C D etc are now 1,2,3
  143. Location of n-th highest value in the range
  144. need the extra button of "Allocation" next to help.
  145. Sum Function
  146. Help needed with VBA code
  147. If Statements...
  148. Unable to access Excel Help
  149. I want to do a workbook with dates and times
  150. How do I copy a worksheet for each day of the year?
  151. Disable find files error message for missing links on opening WB
  152. worksheet on disc downloaded now not able to email
  153. link to identify lastest entry in the row
  154. Lock Data in Cell after entered
  155. How do I remove a formula in Excel?
  156. Pull, can't get working
  157. Getting #REF1 because re-pasted a replacement worksheet
  158. using conditional formatting - blank cells
  159. Change base 6 to base 10?
  160. Using INDEX to find the match
  161. How do I breaks links in Excel 2000?
  162. how do I remove multiple pagebreaks in an excel document in one g
  163. Pivot tables - Insert Calculated field
  164. Menu bar on excel is missing?
  165. Row and Column Headings
  166. totalling
  167. DGET FUNCTION
  168. how do i stop tab jumping 10 cells to right?
  169. Index, Match, Sum ??
  170. File not opening
  171. Oh God the Pain! Help Please!
  172. Hi,
  173. combobox with vlookup
  174. How do I reverse text (ie. get a 'mirror image') in Excel?
  175. have to change all the comments in the sheet simultaneously
  176. difficulty with Search function that incorporates multiple workshe
  177. Fill color in a cell
  178. Difficult query?
  179. worksheet tabs
  180. Filtring a dynamic list
  181. Pivot table details
  182. Read Only Not Working
  183. macro to compile columns on multiple sheets
  184. If Statement-selecting from a drop down menu??
  185. #VALUE! error nesting IF function
  186. Floppy Disc has blocked all file access
  187. Consolidate Spreadsheets
  188. Y not make it possible to use an ampersand (&) in a custom header
  189. My cursor is a black square. How do I fix.
  190. Automation Formula almost complete
  191. analysis tool
  192. need help to solve this
  193. If cell contains text then ......
  194. How do i hide the field list in a pivot table?
  195. error message in excel 2002 too many cell formats
  196. Creating automatic listings
  197. How do I take only one word out of a cell and move to another cell
  198. Error using Advanced Filter Unique Records
  199. Conditional Statement with many variables
  200. Auto insert a range
  201. sort dates by dd/mm/yyyyy
  202. Settings Template for Excel?
  203. expand toolbar automaticly
  204. cell references increase by 3 per row "=I1" then "=I4"
  205. Data Analysis and Graphs
  206. Entering numbers in a cel formula
  207. Database Connection Nested VLookup option
  208. Formulas do not work any more ?
  209. Selecting data from database sheet
  210. Deleting Page Breaks
  211. Tool/template to track available time on calendar
  212. where can i get some design examples spreadsheets in excel 2000
  213. Copying from one spreadsheet to another - formulas don't come alon
  214. Excel: want to have linked icon fit into cell for each row
  215. why does the calculation summery not change
  216. Drop Down Sublist
  217. Array Problem
  218. Variable Incrementing
  219. Help! Still looking for answr: editing unlocked cells in prtctd wr
  220. Ignore - Just testing...
  221. Calculating the average of a sum in Pivot Table
  222. Why can't I get 'alt enter' to create a line break in Excel?
  223. VB.net '05
  224. how do i total more then one category for each column in a pivot t
  225. Gridlines
  226. Really need help creating pop ups
  227. Excel macro settings change back to low
  228. formatting cells
  229. excel or access template/application for baseball statistics
  230. How do I outline data in a pivot table
  231. excel or access template/application for baseball statistics
  232. Removing an inch mark
  233. Copying data across different worksheets
  234. capture unique values and calculate
  235. Up/down arrows
  236. How do I record Excel data from each Monte Carlo run?
  237. Subtotal when using XML data
  238. loop bunny needs help
  239. Formula Help
  240. How do I change worksheet background?
  241. How do I link data between multiple excel spreadsheets
  242. Drive Erased, got Files back but only excel files scrambled, help.
  243. Data from Rows into columns
  244. List First Friday's Date of the year
  245. Weekday Formula
  246. calculating total time
  247. When entering one name in a cell a different name shows up, why?
  248. Referencing to cells in a sorted list
  249. error 126
  250. Loan Amortization calculater (Canadian version)