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. Relative Printing
  2. Retaining Formatting in Filtered Cells
  3. Prevent password removing software from working
  4. Excel 2007 - When can I get it?
  5. issue opening workbooks
  6. Sorting
  7. Index & Match query
  8. Translation of terms between different languages?
  9. help on macro plz
  10. Numerical error in IF-sentence
  11. Number of days in a month
  12. Print Labels off Excel sheet
  13. macro help
  14. template with auto-numbering
  15. How to look up a value in a list and return multiple corresponding values
  16. cells the same sum and delete
  17. Button for custom graphic
  18. formatting
  19. "Height" of dropdown lists?
  20. Disappearing data
  21. 12-hour time data treated as text
  22. help
  23. public const
  24. Pivot Tables - Removing old dropdown items
  25. handling of pics bug
  26. Require help for spreadsheet calculation of longest winning streak
  27. formulas stopped working
  28. maintenance problem
  29. Problem with INDEX formula
  30. MONTH as a string
  31. Images in Excel
  32. Vlookup
  33. Link to other workbooks
  34. Conditional Format Help
  35. Compare and Add 3 worksheets
  36. random no button
  37. Highlighting Cells
  38. Logging data with DDE link
  39. Number Formating based on Formula
  40. Need help with Linking / Delinking Excel Files
  41. Summing a Vlookup
  42. Get data from active row.
  43. help with sorting
  44. Macro help
  45. A random table.
  46. Bar Code
  47. Need help to Create a drop-down list from a range of cells.
  48. AutoFilter
  49. Unique List from table
  50. Subtract two values in Sumproduct
  51. Entering the Time value of Money Tables
  52. Reducing data set, how to choose every 'n'th row
  53. Blank Cell Charting
  54. Copying data from one workbook to another
  55. Need formula to count rows
  56. Prevent Paste
  57. Worksheet Data Transfer/Carryover
  58. Two Questions, for One Document
  59. Excel + Linking data to maps
  60. combining multiple sheets & removing blank lines
  61. named cell reference
  62. Auditing/validation
  63. This ones tricky
  64. Copy and Past from PDF formating
  65. Zeros in Formulas
  66. Advanced filter to show unique records
  67. pivot table field contents
  68. Excel formatting
  69. Conditional Formatting Again
  70. Converting numbers to letters
  71. Payroll formula ?
  72. Count colors and nonblank cells
  73. Sum Same Cell over Multiple Worksheets -- HELP
  74. Header index
  75. charting
  76. Moving Average
  77. How to use multiple record in Mail Merge
  78. find blank then sum and delete row
  79. sorting, odd - even ?
  80. Remove Digital Certificate
  81. Macro maybe???
  82. Any given day in a month?
  83. Excel Lock Up !
  84. I'm sure this is easy but.....
  85. time manipulation: 13:20 + 2:40 =???
  86. Putting results on a single line
  87. Excel and Word connection
  88. Unusual Time Conversion
  89. protect formula
  90. conditional format question
  91. 2 questions on referencing other cells
  92. Excel 2003 Web Query Error - "strict parse error"
  93. changing multiplier.
  94. page break on every cell
  95. Right mouse clicking
  96. Date Format
  97. Deleting empty cells
  98. Display last row of Multiple cells
  99. make excel start in particular cell
  100. Not found message
  101. vlookup related maybe
  102. Display cell content in message box.
  103. auto adjust row height
  104. Old Timers
  105. pls turn this into VB macro
  106. Refresh data problem
  107. Insert Cut Cells still leaves original row?
  108. pivot results
  109. Excel Workbook crashes
  110. data validation drop down list
  111. Cannot Shade cells
  112. Combine worksheets into one book?
  113. Text to Date Format
  114. Call Function
  115. Deleting ALL copies of file
  116. Returning multiple values with VLOOKUP?
  117. Can Pivot Tables break years into months?
  118. Pivot Table "Data Field" for text rows
  119. Custom validation
  120. Sum by cell formatting
  121. Data Summary by Week
  122. Formula to delete any blank spaces after the last character in a cell
  123. Is there a formula to cut the first word of each cell and paste it to the cell above
  124. VLOOKUP to Create List
  125. Excel spreadsheet question using solver...HELP!?!?!
  126. Autofilling with both column and row counting up
  127. 5 col switch
  128. Makro for Link update
  129. sum in pivot table
  130. "Workbook contains automatic links"
  131. Look up table problem
  132. All In Pivot Table Field
  133. Hidden Data Page
  134. Hiding Formulas
  135. problem regarding macros
  136. Using Find/Replace to delete contents of cell
  137. Help with this layered function....
  138. Creating a to do list
  139. adding non-adjacent cells depending on another cell
  140. Excel 2000 problem
  141. excel database
  142. Conditional Formatting .000's and %'s !
  143. Really Weird #REF Error in Complex Excel File?
  144. macro for moving rows to other sheet
  145. I think I need to use an If statement...
  146. Print 2 columns across the page?
  147. Formula to Balance call center staffing
  148. building database
  149. Nested Subtotals
  150. Equation in Macro
  151. Assignment Formatting!
  152. Pivot Table - character max
  153. Reading Fractions
  154. show error messages as blank?
  155. eliminate the blank total in my pivot table
  156. Help needed with IF Statement
  157. minus sign
  158. Help - File Not Found
  159. comparing dates in a field
  160. Protect Cells from Copy and Paste
  161. Error Handling Question
  162. Cell Colouring Diagonally
  163. Rotating through a range of integers
  164. Way to scale a page but not header/footer?
  165. Conditional Formatting Formula
  166. unable to drag version 2.1 from ftp site
  167. group of numbers frequency
  168. Find a Value in a Table
  169. pivot table macro
  170. Auto dynamic Chart
  171. Cells without simple text were ignored.
  172. Worksheet frozen but still editable - Help please!
  173. VLOOKUP Across Multiple Worksheets
  174. Validation Grouping
  175. Assign a numeric value to a text string
  176. Moving selections by buttons
  177. Pivot Table
  178. Returning multiple Corresponding values
  179. Is it possible to lock a subtotal?
  180. How do I link a sum to it's multiple factors with arrows or color format?
  181. How do I add sheets to a spreadsheet?
  182. Combo Box Font sizing
  183. Help with invoices
  184. Yield to Maturity
  185. scrolling page
  186. Password protecting & hiding columns
  187. Refreshing worksheet
  188. Vlookup
  189. Switching a row to a column?
  190. Converting Price to Code
  191. "Writing" into a cell
  192. Math question: Creating a ratio?
  193. sumproduct() and search()
  194. Sort Text & Number
  195. Mail Merge MS Word
  196. adding an image to excel that opens in a small window
  197. referencing other cells
  198. checkbox for selecting options and summing
  199. Removing duplicated values in a column
  200. Where Are The Cell References?
  201. Insert Comments Help
  202. is there a command to stop the calculating process
  203. "sum" returns spooky hidden decimal figures
  204. Negative Time-values
  205. Number format problem
  206. Show/hide jpg picture
  207. Need help with %
  208. Move data from horizontal to vertical
  209. How to auto-advance an array formula
  210. read the last number in a column
  211. help turning off confirmation dialog in 97
  212. VLOOKUP - Copy Results.
  213. can't save external link values
  214. number displayed as E+
  215. hyperlink confusion
  216. Unhide sheets
  217. Freeze Panes
  218. IF Function
  219. If statement issue
  220. Can't Cut, Copy or Paste
  221. Joining Data between two excel files
  222. How to break up a text string?
  223. Problem Maneuvering within formulas
  224. Setting Hyperlinks
  225. Inserting picture or changing the font in Macro Msgbox
  226. Cell colours not displayed
  227. Data Re-arrange
  228. Auto run macro when excel closes
  229. Basic Question - Making 3 columns out of one
  230. hyperlink formula to other sheet/cell
  231. Data Cleaning
  232. Return a list of unique matches
  233. Currency Converter
  234. Too stupid for copy/paste? Error message
  235. Save and Exit Macro
  236. Replace cell value when saving a file
  237. Help with datedif
  238. IF statement within if statements
  239. Excel change numbers to date
  240. important and probably easy to solve
  241. Page break???
  242. I need help from you smart people.
  243. Multiple Worksheet Change Events???
  244. Search box
  245. Macro to compare names on sheets and go to row in second sheet
  246. Probability Question
  247. Response Time - Opening a 15MB workbook?
  248. auto complete for dropdown lists
  249. 1001001004006_001.tif to 001.001.001.004.006_001.tif
  250. Sheetlist in two rows