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. Change format of SSN with ' in front?
  2. Pivot table calculation. Showing differences
  3. divide a column into three blocks which all have the same average
  4. Calculating end date
  5. Code for Experiments
  6. Defining names
  7. Checkboxes and filters
  8. Pasting Formatted Text
  9. Multi-Page Range synchronization
  10. Random Sampling
  11. Choosing images to display
  12. Sheet color
  13. Index Matching
  14. old problem subtotaling
  15. Matching Values + Adding Values
  16. exclude non-numeric data from functions
  17. Control End
  18. referencing a particular row in another sheet
  19. Dynamic link to non-open files
  20. My hyperlinks are being changed when I hit save in excel.
  21. averaging nonzero data
  22. Search/Find function integrated into worksheet?
  23. Excel VBA Version Conditional Statements 2000 2003
  24. Sum of column which includes #N/A values
  25. ISERROR VB Solution?
  26. Uk Bank Holidays
  27. percentage of the dates where + or -
  28. Hidden Chart
  29. Iterations reurning a #Div/0
  30. Scrubbing data using excel
  31. Formula to return year of date in a cell
  32. Constant display of dimensions of object label.
  33. Missing Results
  34. increment order number
  35. Balance the books
  36. Help in simple macro
  37. Data Transfer From One Worksheet To Multiple Worksheets
  38. Protect all but one cell
  39. Double click to run a macro
  40. Object with macro that duplicates object (without macro)
  41. If formula
  42. a way to send someone a file after they submit
  43. leaving cell blank as a result of two blanks cells
  44. applying formula to entire sheet
  45. How I can keep all the lines that appear with a certain word
  46. Turn Automatic Date Format Off
  47. macro to copy row based on drop down list
  48. Referencing ALL worksheets
  49. An "IF" question
  50. Automate cell references for tracking purposes?
  51. simple question.. i think
  52. Assigning values to text - but displaying the text!
  53. a way to hide the letters and numbers
  54. End formula by date
  55. put in something other than True or False
  56. Print without fill?
  57. Find a Range and move to different columns
  58. a way to leave a cell blank?
  59. sumproduct with an if?
  60. Crashed computer - Lost VBA
  61. Changing #DIV/0! into 0
  62. MAX with criteria
  63. Data Entry-Time
  64. Cannot open .iqy file
  65. copy cell to cell
  66. What size should I make a form to print on A4?
  67. Unable to print gridlines.
  68. Formula BOx shows Results but Cell Does not
  69. Countif()
  70. Release All Autofilters
  71. Pivort Table Auto Update
  72. looking up data
  73. row header from active cell
  74. True
  75. split cell
  76. Student t distribution critical values
  77. concatenation in with dates
  78. Excel 4.0
  79. Schedule setup to view in hour increments?
  80. formula >0
  81. Cell Protection Issue when opening Excel 2000 spreadsheet in Excel 2003
  82. What does this mean: "=F11*$K$18" ?
  83. Text Boxes on Chart
  84. Please help, sorry i cant use excel to save my life!!
  85. formula for fantasy baseball!
  86. VBA Fill
  87. match
  88. splitting info from one cell into two cell
  89. Multi Sheet functionality
  90. Formula Be Sped Up?
  91. Dynamic formulas
  92. using lists & searches
  93. Expanding drop down box
  94. Printing Forms
  95. Dates -match
  96. Weirdest Excel Problem?
  97. create a matrix
  98. cell format - cannot change?
  99. How to delete every other row! quickly!!
  100. limit access to worksheets?
  101. Mandatory fields
  102. Deletion of Unused Lines
  103. count cell by text
  104. How to detect the cell reference in a formula
  105. Retrieving unique items & sort
  106. Top 25% of times
  107. how to divide total?
  108. No. of Mondays in Date Range
  109. If statement
  110. Permission and Saving Error
  111. Date formats, userforms
  112. PDF hyperlink error message in Excel
  113. Total Time
  114. Return cell contents during a time slot.
  115. Sorting/Numbering query
  116. contents of the cell instantly duplicated to a designated cell
  117. looking up and summing from a table with conditions
  118. copy data from row across to colum down
  119. Disappearing numbers after the decimal
  120. cell Formating
  121. Data Refresh
  122. Hlookup / Match
  123. Header
  124. How can I RETAIN formatting in a pivot table?
  125. Data retrieve from different file based on date
  126. Sum Product
  127. unremovable '(blank)s' in Pivot table
  128. VLOOKUP from LARGE formula = #N/A??
  129. conditional formatting
  130. Matching data between tables with a column being time values
  131. Linking pivot table fields
  132. Scatter plot trouble?
  133. Posts
  134. Help me figure this out
  135. Batch changes to graphs
  136. not equal to
  137. unlock certain cells which are different for multiple users
  138. Pivot table design dilema
  139. How to change "2/2/2007" into text "2/2"
  140. Offset & Indirect
  141. Paintbrush-Why is it apprearing when I insert a row?
  142. Formatting Issue
  143. How to separate a List???
  144. Converting data from columnar to row format
  145. Formula Help
  146. keep the bottom-most row
  147. Question regarding formulas
  148. Converting Pricing lists to PO's
  149. Countif fuction with two criteria
  150. finding the last non-zero value and deleting cells to the right
  151. Hide error messages
  152. Looking for a little help with a run of numbers
  153. Percentage of people in an age group?
  154. Linking excel 2007 charts to powerpoint 2007 doesent work
  155. Freezing panes?
  156. Linking excel 2007 charts and texts to powerpoint 2007 may change the charts
  157. Datevalue #Value error?
  158. Please Guide Me , I Need Some Help ?
  159. Calculating Change
  160. Setting links
  161. Datestamp in spreadsheet problem
  162. assign SEQ# for same values
  163. store & compress old workbook versions
  164. format cells
  165. multiple conditional statements
  166. Date & Time
  167. Time Series Charting Excel
  168. Inter-dependant Formulas
  169. Unable to Text to columns due to data size
  170. VBA to place a picture
  171. Capture Email Name Or Address
  172. excel computations (if, offset, countif)
  173. Highlight Data after Certain Date
  174. Validation: Update/Refresh?
  175. compare and align data
  176. Simultaneous Viewing of Multiple sheets
  177. Print one page for each record in a data list
  178. Validation
  179. Importing external data from CSV
  180. Link word text to excel
  181. Hyperlinking to a hidden sheet
  182. GoTo cell Value
  183. Insert Blank Row
  184. Cell Reference
  185. Last Day of June via formula
  186. How do I add ranking in the pivot table?
  187. Excel Quiz
  188. Restricting Cell Size
  189. Moving Files to Archive - Preserving Links
  190. Logging real time
  191. Sort Options
  192. Project
  193. Look for a number and format the cell
  194. Protect a Sheet after certain date
  195. Changing the look of a Button on a Form
  196. Create formulas on second sheet
  197. The insert row disappeared from my list
  198. Moving cells from vertical to horizontal
  199. Cross post on another forum >> user forms and coding
  200. Changing colour of a cell on another worksheet
  201. [SOLVED] Auto Filter won't sort
  202. handicap system for golf league
  203. graph to refer to the activesheet
  204. Detecting whether a time falls within a military time range
  205. YTD Calculation
  206. Import data from on xls to another with macro
  207. Data into a cell from a list
  208. using string variable
  209. tabbing to data entry fields by default?
  210. Sum Minus Only
  211. Question related to text entry
  212. Pivot chart from Multiple Access Queries
  213. Import filenames into spreadsheet
  214. Shortcut key to find linked data in other tabs
  215. #value! error in excel 2007
  216. Posted on another forum - if and formular
  217. Charts
  218. Sorting Data By Date
  219. How to create a list of items for use in a dropdown list with data from a different..
  220. Macro reads 3 digit #'s but not 4 digit #'s
  221. Pivot Table View
  222. data anlysis tool
  223. If Statement
  224. Create column of tracking numbers from cells
  225. option botton assign 1 or 0 to a cell based on selection
  226. Spin Button
  227. Running Macros Truly the best forum in the world
  228. Clear Cut
  229. filter data
  230. Percentage of one choice and the percentage of the other choice
  231. scroll lock nightmare
  232. Excel Closes by itself
  233. Excel and DB Table Data Retrieval
  234. Reduce block of code
  235. Add * to number
  236. time conversion
  237. reduction Excel files size
  238. SUMPRODUCT but using a filter?
  239. Max Min Array
  240. Using Excel in a mail merge
  241. single document multiple access
  242. Printer
  243. Long equation
  244. pivot table-source data attached
  245. Excel file cannot be accessed
  246. Filtering - Comparing Tables
  247. symbol for between
  248. If Then else
  249. Need 01 not 1 if possible?
  250. Finding an average across multiple worksheets in the same workbook