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. Deleting Duplicate items in a ListBox
  2. Counting unique entries based on given condition
  3. Protecting Macro and selected sheets
  4. Template for new entries
  5. Formula for cell=exact(left...&2)
  6. How do you permanently hide and password protect a column?
  7. Cell Protection over Excel 2000 and 2003
  8. Formula Help based around countif and counta
  9. Calculating fields in pivot tables
  10. How To disable Alt Key Research Pane
  11. Preformance problems
  12. data match
  13. how do i make a cell absolute
  14. General Question about Moduals
  15. Tab
  16. Numerical Grouping of 10,00,000.00 lacs not possible in Excel
  17. How administrator can delete temporary excel file generated on se
  18. comma in indian style
  19. Text to columns with carage return as deliminator
  20. partially protecting a worksheet?
  21. conference planning budget
  22. #NA
  23. Changeable Row sizes to fit in the text!
  24. Office Clipboard
  25. Relationships / Calculations
  26. How can I change the currency to words?i.e. $10 to Ten Dollars
  27. counting text example of a cell with multiple words inside
  28. counting text example of a cell with multiple words inside
  29. Vlookup help
  30. Summing large numbers with decimals in Excel
  31. restricting use of certain characters
  32. Unable to merge cells
  33. how do search a list of numbers to find what adds up to a large #
  34. excel 97 vs excel 2003
  35. 97 excel vs excel 2003
  36. Can you open files from excel 97 in excel 03
  37. Error opening Excel in different version
  38. get rid of the "insert option pop up window paintbrush"
  39. Checking documents into Sharepoint
  40. Print Size
  41. Change default gridline color in Excel 2007
  42. Question about "Update Values" Box when using Sum(If)
  43. deleting worksheet and associated references
  44. Why is Excel's "solver" not always available on new worksheets?
  45. how do i insert numbers from Random list (1-45) without repeating
  46. how do i insert numbers from Random list (1-60) without repeating
  47. Randomly sorting the alphabet
  48. How do I get total hours from 2 date/time cells?
  49. re: Bob phillipps answer for counting text
  50. calculation of standard deviation is not as help document says
  51. Match (merge) components from 2 spreadsheets
  52. moving pivot table data source files
  53. Add comments without deleting.
  54. Double clicking an Excel file is not working. What's wrong?
  55. Spreasheet converted from 123 prints funny
  56. tilt wheel does not work
  57. Excel Toolbar does not save
  58. Data Orientation
  59. How To Remove all caps in column?
  60. Scaled Prints and shapes in Excel
  61. Help!!!
  62. Add tab with ID to hidden columns in Excel
  63. Match cells from 2 different sheets
  64. Range("cell").Select Problem
  65. Why does my print job split up when printing the entire workbook?
  66. Macro to hide and unhide based on criteria
  67. auto filter not working
  68. Non-calculation in large workbook
  69. Column reference and column count
  70. Change scroll bar to end at end of text not bottom of worksheet??
  71. Where to start?
  72. less noise when working with CSV files
  73. Excel: replace all 2 spaces to FF/LR in column of text
  74. Add-in for crossconnects on drawings?
  75. Can a combo box activate different macros
  76. Why a plus sign after the equal sign?
  77. Looping Question
  78. inserting rows automatically?
  79. how to automatically jumble a list of numbers
  80. DATES
  81. Need help for a macro
  82. Macro to enlarge a picture
  83. How do I replace ('S) with ('s) within an excel list of company na
  84. Protect macro
  85. Run Time Error '1004'
  86. Import a video into Excel
  87. Macro that can run combo boxes
  88. Missing Rows?
  89. listing winners formula
  90. Flashing text in a cell
  91. paste special not working in excel
  92. Undefined function error
  93. sumproduct help
  94. remove characters from a text under a condition
  95. Typewriter Effect
  96. Validation
  97. using dcount on a variable data range
  98. Data Validation - List - keeping the format of the list - shading
  99. Lookup more than one workbook
  100. Automatic Calculation switching to manual
  101. Can't create AutoFiltered Excel worksheet using VB.NET
  102. Delete Forms CommandButton on Worksheet
  103. How prompt Excel user to fill cell with text, i.e., proposal name
  104. TRUE condition???
  105. Projection of Intersection values on Y and X axis
  106. Worksheet_Range Problem
  107. VLOOKUP *Left* Value
  108. Excel crashes when I try to Delete Columns
  109. Cell Formatting will not show up
  110. IF () program
  111. Tough: Vlookup, Match, Sumproduct? To create list of persistence
  112. HOW DO I MAKE A BACKGROUND FOR AN EXCEL SPREADSHEET?
  113. New to pivot tables-can they do this....?
  114. Macro help:replacing figures
  115. Cell borders with formula edits
  116. Stuck in a loop
  117. How to pass a variable into an SQL statement
  118. Footer edits
  119. Convert HH:MM to number as minutes only
  120. Show username in a cell
  121. How do i create a countdown by days?
  122. Vlookup and #N/A
  123. Linked network workbooks revert to pointing at my hard drive
  124. Function help!
  125. Vp
  126. Print Picture in Excel
  127. If / And / Or...
  128. World Cup Competition
  129. insert a blank in every second line of a row
  130. data in multiple columns moved to one column
  131. Function help!
  132. Excel 2000 macro not working in Excel 2003
  133. Case specific LOOKUP alternative
  134. vlookup with trim function
  135. How do I make them all negative??
  136. Lists
  137. countif formula for text
  138. How to change the default font
  139. Using count formulas with '<='
  140. How do i fill the adjacent cell formulas in user form when i press
  141. IF formula & Percentage
  142. IF formula & Percentage
  143. Advanced Filter
  144. frequency distributions
  145. pivot table formulas for calculated field or calculated item
  146. Excel 2007 Compatability
  147. Can vlookup find the last row without it in the formula?
  148. Combining Excel worksheets
  149. Can I write a Macro into an IF Function?
  150. Conditional Format based on range
  151. LEFT function
  152. How to hide a text file using macro
  153. Copy a formula down in a macro
  154. pivot default settings
  155. Remove html markup tags in an EXCEL cell?
  156. keeping excel program confidential
  157. Dual Monitors: Viewing different tabs in same workbook?
  158. IF conditions
  159. Grouping Percentages
  160. Sorting and copying data to another worksheet in a workbook.
  161. How do I copy and print a picture of my screen to teach people?
  162. Trying to get my questions answered again...updating charts in a w
  163. drop down then populate
  164. How do I increase a column of numbers by a percentage-same cell
  165. Macro to import modules into a worksheet
  166. Formula help
  167. rounding to 25 cent incriments
  168. Retaining Excel graph format
  169. Subtotal based discounts
  170. Employees shift schedule
  171. CD Programming
  172. Converting between different frequencies for time series data
  173. Deleting a $ sign in Excel
  174. insert lines
  175. copying named range
  176. DDE and updating
  177. How to set the default "summarized by" of a data field to "Sum"?
  178. Field and Worksheet Restrictions
  179. insert a line on condition
  180. auto change line
  181. how do i change the default location of my picture files in Excel
  182. locking template?
  183. mulitiple droplist
  184. Picture Placement
  185. vlookup
  186. Combining an IF and MAX function
  187. Text to rows?
  188. Selecting offset cells
  189. substitution
  190. Subtracting 2 hours from time
  191. inserting a named range into new cells based on a named cell
  192. format painter wont copy mixed font colors from one cell to next
  193. Find & replace question.....I believe
  194. First Page
  195. Interest earned formula
  196. adminstrator access
  197. email from excel w/ thunderbird?
  198. excel
  199. Excel should calculate sums quicker in status bar
  200. Grouping of icons in the Quick Access Toolbar... Excel 2007
  201. "Average" Function in Excel
  202. = (other sheet, but transposed!)
  203. What calculation can I use to find income on a fixed investment?
  204. Pivot Tables and Column Labels
  205. Averages from different worksheets
  206. Sales Taxes
  207. Sharing workbook, show last user change?
  208. Buttons for ", & ?
  209. Linking a cell to the previous tab?
  210. Sort and print .pdf files into one .pdf document via VBA code?
  211. Linking to a worksheet in a separate workbook
  212. Returning To Previous Worksheet - Help with sebastienm's code
  213. Saving data in Excel
  214. Formula Conditional formatting on numbers
  215. Creation Date
  216. using an IF function for a total
  217. date format help
  218. can numbers be assigned to values, replacing values for numbers
  219. Narly one...compare columns with other columns
  220. excel 03- sheets stay grouped even when I ungroup
  221. Sorting Sorting Sorting
  222. Customize Icons In Toolbar
  223. Clipboard in Excel
  224. How do I do this?
  225. Excel Spreadsheet Not Saved Dialog Error
  226. Recalculation of formulae disabled
  227. conditional drop down list
  228. Replace Function
  229. Pictures not showing or printing
  230. "word unable to open data source" message when trying to do mail m
  231. How do create a formula to add IP addresses?
  232. pivot table data display in cell
  233. getting font color to stay black!
  234. After 2 days of frustration...Formula
  235. After 2 days of frustration...Formula
  236. Sumproduct Average
  237. Go To Dialog box
  238. Input original save date
  239. Multilple linked Cells with Combo box
  240. Lining up data from concatenation
  241. Is there a way to sort by format in Excel?
  242. Subscript shortcut?
  243. Best way to learn/use macros?
  244. save workbook created from templete to a specific folder
  245. Count Function 2 Columns
  246. #REF in Sheets that refer to Pivot Tables
  247. scheduling problems
  248. How can I save a file in Excel 2007 beta 2 as a .dbf extension?
  249. Format entire column with Calendar activex control?
  250. COUNTIF statement with 3 criteria checks