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. Only list some conditionals
  2. Countdown timer
  3. #N/A Value
  4. Copy/Paste
  5. Eigenvalues and Eigenvectors
  6. Calculating Time Intervals
  7. Too many arguments
  8. macros?
  9. Print Area
  10. Complex manipulation of aggregated dates and times ?
  11. sizing columns and rows.
  12. If, vlookup, and concatenate all in the same formula
  13. Importing / updating most recent datafile
  14. Characters such as ~ causing trouble
  15. Nested Formulas
  16. Not able to view other worksheets
  17. Draw in Userform
  18. Conditional Formatting
  19. Conditional Formatting date more than 5 days old
  20. Header and Margins...
  21. Lookup Table
  22. VlookUp
  23. if sum of cells is 0 then ignore total
  24. Conditional Format For Error
  25. Counting the number of rows with data
  26. Find Text
  27. Data lookup help
  28. Getting rid of Enable/Disable Macro prompt on launch
  29. Combo Box in a Cell
  30. cant see drawing toolbar
  31. Date conversion & calculation
  32. shared workbook
  33. Pivot Tbl Q
  34. Defining a Name in excel with a Indirect() range
  35. Ignore #N/A to calculate running total
  36. how do I sort a macro address problem?
  37. Auto Calculate Profit By Part #
  38. Display a list without scrolling. (Floating textbox?)
  39. Probability table and function
  40. Countif
  41. How to calculate conditional sum?
  42. Sort by bold
  43. How many quantity eache seller sold
  44. Find ()
  45. Formula with statement
  46. Formula for Last Used Cell in a Column
  47. Using condition format to check if day equals Friday
  48. HTML Paypal Buttons in Excel
  49. Problem sorting columns
  50. Microsoft Query returns truncated data to Excel
  51. Delete File after Execution from Macro
  52. Cell grouping problem
  53. Question re Conditional Formatting
  54. V lookups in the Execl
  55. How to find entries from two seperate files?
  56. Popup if Condition on Spreadsheet Open
  57. Assignment
  58. Filter by date
  59. Date clearance
  60. Macro To clear tick boxes
  61. formatting assistance
  62. Edit and Replace
  63. Format in cell changes automatically
  64. Counting
  65. conditional format wont run 2 formats at once
  66. Why doesn't my query allow me to edit?
  67. I need a volunteer to train me in VBA for a project!
  68. Quickbooks Templates
  69. Reverse HLOOKUP
  70. month name to number
  71. Password Protecting a Folder
  72. Sorting from row A6 onwards
  73. Perform Action on Cell determined by another cell's value
  74. Setting a dynamic path for VBA
  75. workbook formulas stopped working
  76. grouping cells
  77. Change Sheet Reference w/o Find/Replace
  78. Finding Start Position of string in list of strings
  79. Vlookup Help
  80. cell data move to left
  81. Pivot table formula
  82. How to prevent cut/copy in Excel 2003?
  83. Grand Totals for Rows #DIV/0 error
  84. Working out the time?
  85. automatic values in a cell
  86. VBA - tick boxs
  87. Excel shortcut for highlighting data
  88. Database - Using form
  89. Find Text
  90. Extract Data
  91. Referncing a price to get the part
  92. Sorting using a dropdown from another sheet
  93. Hyperlinks
  94. Excel crashing
  95. Margin error
  96. Settings for forum
  97. Print output is too small
  98. trying to generate cell number from array
  99. Adding shortcuts to open menu
  100. Comparing and isolating data in lists...
  101. Pivot Table not Retaining Formatting
  102. Measuring Productivity
  103. Andif syntax, date format
  104. Autofilter and sheet protection problems
  105. Truncated: copy excel worksheet to powerpoint
  106. Calling applications through excel ?
  107. Validation from other worksheet
  108. formula in Weightloss sheet
  109. Sheets size
  110. Advanced Filter - Unique Records Only
  111. Excel Life
  112. Inserting table in Excel
  113. Convert TODAY() Value To Text
  114. NETWORKDAYS (Including Saturday)
  115. One entery of identical values in a list
  116. linking to open workbook
  117. Linking sections of different workbooks
  118. Rounding.
  119. Error message: To many different cell formats
  120. Line adding /Change
  121. Pivot Table Subtotals
  122. Add Up Values across Excel Workbooks
  123. shorten this code
  124. Nesting IF functions
  125. Searching for Varying Text in a Range of Cells
  126. Help with Header and Margin
  127. Sumif
  128. Sum Last values in a Row
  129. Vlookup 051407
  130. Need to find names not used
  131. Blank Cells Affecting Sum function
  132. Removing Duplicate names from 2 seperate spreadsheets
  133. Adding Arrows to Numbers
  134. Copying and Incrementing Values
  135. count different non blank values
  136. Displaying title of item in one cell depending the price entered in another
  137. countif on nonconnected ranges
  138. Vlookup with a range of numbers
  139. spread text over variable number of cells
  140. import outlook calender automaticly using vb
  141. Text in Row's / Columns Need to Merge
  142. help combining/merging two columns in Excel 2007
  143. cell move up ?
  144. Chart Labeling
  145. Auto row insert?
  146. Moving Specific Data
  147. Filtering/Sorting question
  148. addresses
  149. Excell Or Access???
  150. multiple % discount dependent on sales value
  151. Worksheet menu Bar missing? I want it back!
  152. Problem in summing up a row
  153. Changing Hyperlink Properties
  154. Reversing Cells
  155. open multiple password protected files
  156. I've got too many worksheets
  157. Case Format
  158. Remove text after an '&' symbol in a cell
  159. Using pounds and ounces (weight) in excel
  160. Can I lock IF statements?
  161. Sorting data in sheet with frozen, protected column headings
  162. Pivot tables
  163. Disount Percentage
  164. Reseting Data Validations
  165. pivot table
  166. Excel Template
  167. change fill colour row when specific text entered
  168. Auto Number Columns in predefined steps ?
  169. Macro box trick
  170. security question
  171. auto filter problem
  172. Keeping the web toolbar hidden
  173. excel export csv or text to import into phpmyadmin
  174. Copy data to filtered column on another sheet in row order?
  175. Value on bottom
  176. mix vlookup and hlookup or another function
  177. percentile value when input changes
  178. Need to know what 1 inch is equal to for cell width.
  179. How do I clear unused rows or columns
  180. Merge and Remove Duplicates in Excel List
  181. formula based on cell background color
  182. Excel vs Crystal Reports
  183. Cell Animation
  184. Excel Zip Code Map & Distance Calculator
  185. File already exists (error 58)
  186. OnOpen Event for Excel Sheet.
  187. Sheet to Sheet Keyboard shortcut
  188. Delete multiple rows of data?
  189. Blank if statements
  190. Removing Duplicates
  191. Variable Cell Name
  192. Code assistance Required
  193. Conditional drop down menus?
  194. Hlookup - Automatic row fill??
  195. Sumif value is in a different range
  196. Advanced Sorting, Deletion of Duplicates
  197. Finding values
  198. Automatic Sorting
  199. More lines in a cell?
  200. Text Date into Number Date
  201. how to use vlookup to return 2 set of values
  202. Assigning random priority with RAND function
  203. Linking to restricted workbook
  204. Excel Spreadsheet Not Visible when opened.
  205. Problem with data sheet and linking it to another sheet to make a report
  206. Golf League handicap with a twist
  207. udf inside excel functions
  208. NETWORKDAYS function not available to users
  209. Trouble with Excel Formula?
  210. Using IF / AND
  211. Hours Worked
  212. OK here's one you've heard befor
  213. Automatically move to the next cell
  214. Import XLM file in Excel 2k7?
  215. kinda like freeze panes, but not really...
  216. protecting my sheet
  217. Adding workbooks as worksheets
  218. Use cell in open workbook to id path to wanted data
  219. counting letters
  220. Another VERY weird crash
  221. Replacing 0 with -
  222. Formula Help
  223. Creating Backup file! (Not Save-as)
  224. split details in a cell into different cells.
  225. Pivot Table Query
  226. Strange Crash
  227. Refence another workbook based on value in a cell
  228. How to use validation in this example
  229. Pivot Table Problem
  230. Using auto filter in protected worksheeets
  231. Restrict edit cell,row, column
  232. Hide Rows
  233. Quick way of checking the frequency of 2 numbers
  234. Can you sort a row?
  235. Address Block Problem
  236. IF Statement Question dealing with Dates
  237. Portable Hyperlinks?
  238. VLOOKUP not working
  239. Trying to create an Inventory adjustment Form
  240. SUMIF across closed worksheets
  241. adding rows automatically
  242. ActiveCell.Next.Select not working
  243. VLOOKUP for merged cells
  244. Search array for text, return column #
  245. Find which values in a list add up to a given total
  246. Looking for formula to leave cell zero if no detail in cell before it?
  247. Which formula should I use?
  248. Iserror??
  249. Find The Friday!
  250. Extending Seriers Problem