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. formulas in cell auto formatting as text
  2. Complicated number searching
  3. Merge date and time columns without loosing time
  4. Need help w/ a startup page
  5. Removing info from a cell
  6. Help on excel sheet
  7. Advanced filter help
  8. Can someone help me create a calculation that can count using three criteria?
  9. USB drive
  10. sort numbers
  11. random no
  12. splitting a text into two cells
  13. A Tough one.
  14. Working with multiple Workbooks...
  15. importing from db "bracketing" error
  16. Output result of a formula to a different cell?
  17. Error Message
  18. Renaming sheet3 to sheet1 not enough!
  19. Two Way formula....
  20. multiple of 3
  21. Refresh external data source?
  22. Decimal places in a concatenation
  23. problem running macro with drop down
  24. format an entire row
  25. Hyperlink to set cell value
  26. Manipulating data in a vector
  27. Downloading data into Excel
  28. Excluding the zeroes from the calculation
  29. Saved as Changed
  30. Sum Column as Displayed not As Calculated
  31. Thick Borders
  32. Still working on the comment box
  33. Sorting Problem
  34. Is this possible ??
  35. rownumber as a value in a cel
  36. I need a little help
  37. autofill a cells like 709 125 gives 710 125 but should give 709 126
  38. Getting date to display after number input
  39. Validation based on a range of values
  40. Open Excel from email
  41. Pivot table running total
  42. How do you delete a formula in a cell without deleting the information in the cell?
  43. Finding the most common (and 2nd, 3rd most common) text
  44. COUNTIF On Two Columns
  45. Kris Kringle Spreadsheet
  46. Where am I going wrong with this formula
  47. print every day at fixed time, automatically
  48. external data source security
  49. formating
  50. Password protection...
  51. Compare two columns
  52. I can't merge cells :(
  53. This sounds "wrong" but I need to do this
  54. My formulas stopped working
  55. Can this be done?
  56. Running History of values?
  57. Pivot Autoformat
  58. Deleting rows or columns
  59. Validate IP Schema Formula
  60. Adding Symbols to Cell Format
  61. Match and display
  62. req: Help with Sorting
  63. Counting Only Visible Rows
  64. Formatting Cell Fill Based on Adjacent Value
  65. Getting a formula to treat a fraction as a whole number
  66. simple loop through data and write result in cell
  67. Count the criteria which have the range value
  68. Pivot Tables (Access Vs. Excel)
  69. Excel "date and time" section in excel tips are missing.
  70. Data Inside And Outside Pivot Tables
  71. Formating
  72. External Data Range
  73. Protected Fields on Page not staying protected
  74. help for macro
  75. Update Total
  76. Basic Excel formula query
  77. Date Cell last updated
  78. I have a dream...(about formula help)
  79. hyperlink - Word-->Excel (Specific Tab)
  80. Identifing or Selecting Rowes that add up to a fixed sum?
  81. Hiding Check boxes
  82. hatching an area
  83. Running Total???
  84. Selecting from one list and adding to another
  85. Exgtrmely slow: Changing default directory during [file-save as]
  86. Multiple Conditional Formating
  87. Display only the numbers that don't match
  88. Changing time format without losing data
  89. Is this even possible?
  90. Pivot table colum width
  91. finding duplicates between 2 columns
  92. Counting days worked and Averaging Totals
  93. Simplify a function to save speed?
  94. Very Slow Saves and Autofilters
  95. New Web Query help
  96. Lookup formula help
  97. Distance Formula for Latitude and Longitude
  98. Using a list from Excel as parameters in MS Query
  99. How can excel list how many times an entry is in the database?
  100. Formula to consolidate different pivots table into one
  101. Filter
  102. Greater than Date Function
  103. Save As
  104. Numbers don't compute
  105. Changing the scale of the x-axis in PI values
  106. Can I override default
  107. Currency Conversions
  108. Change an IF statement(s) into a script
  109. Option Buttons, copying
  110. saving excel doc to webpage
  111. Updating Showcase Queries
  112. Ordinal Numbers in Dates
  113. Sum on Multiple Criteria
  114. Naming a range in a macro
  115. If col. A is match, return col. B
  116. Copying data for specific dates
  117. Pasting and Embedding
  118. Excell error
  119. Pivot issue in a macro
  120. Date/year problem
  121. run macro automatically
  122. How do I?
  123. Extracting Data to another Workbook
  124. Check that a value is a number
  125. Using count() with embeded logic
  126. form to list
  127. Formula Calculation Help
  128. Adding Cells
  129. Excel Training (night School ?)
  130. How do I
  131. Lock different properties for different cells
  132. Sorting range of dates in Pivot Table
  133. Conditional formatting question
  134. Help with design.
  135. Updating the Customer Resource Managment
  136. Flagging event due dates
  137. Long Strings
  138. sumif issue
  139. Repeated Question
  140. increase using macro my +1
  141. Variable Data Ranges
  142. password security
  143. Extracting last four digits
  144. Loosing Leading Zeros
  145. Drop-down box
  146. How to calculate the percentage a returned average represents of cond. measured range
  147. Filter List
  148. Copying Formulas
  149. lock cell
  150. Excel data formatting
  151. Chart Automatically update and extend
  152. Querky behavior
  153. Multiplying rows and cloumns
  154. Comments Menu Option Greyed Out
  155. Imported Data vs. Excel Data - Comparison Problems
  156. average results of vlookup
  157. CountIf - User Names with ><'s
  158. Combo box - Text size
  159. Highlighting non-unique items in a list
  160. Saving excel from email attachment (HELP)
  161. Can Excel possibly even do this?
  162. beyond conditional formatting abilities
  163. Copy Rows to a new worksheet with unmatching cells
  164. Winzip problem
  165. Numbers to text
  166. Help with Menus
  167. Using output from one cell to create a formul
  168. Drop down menu
  169. Subtotal Sort
  170. Trim File Size & Speed Up Excel?
  171. Executing the delete command in a macro
  172. Vlookup
  173. Summing Worksheets in Same Workbook
  174. vlookup
  175. Count uniques, 2 columns
  176. Another formatting problem
  177. Organising dates
  178. Pick up and Calculate specific data
  179. Conversion (hh:mm:ss) to seconds
  180. Round up to nearest quarter
  181. Links to other workbooks
  182. Excel's Formulas recognition
  183. workbook changed by other user since last save...!
  184. vlookup returning #N/A
  185. Running a Macro every 10 mins.
  186. creating a bar graph
  187. Very Hidden Sheets
  188. Once-off And Duplicate Entries
  189. Help with a nested formula.
  190. Insert Comma for 1000 lines
  191. This is strange! (Excel 2003)
  192. How to conditionally lock cells
  193. I'm an idiot trying to learn...
  194. Linking Workbooks
  195. Insert apostrophe in front of a date
  196. Exporting/Sorting Outlook Contacts
  197. Return remainder start/remainder of text string before/after a specific character
  198. "IF" Function
  199. Count rows that meet 3 or more conditions
  200. Entering values in a cell
  201. Surface Area
  202. shortcut toolbar to wrao/unwrap text
  203. Figuring Out My Paycheck
  204. Divide cell contents into multiple rows
  205. Roundup to .99
  206. Formula to import image?
  207. Data Validation/Combo Boxes - HELP NEEDED ASAP!
  208. convert unit change to percentile rank change
  209. create BOM
  210. Principal Calculations Question
  211. User Form
  212. Using If command
  213. Stop my worksheet updating!!
  214. Hide sheets based on cell value input
  215. reversing a column of names
  216. Disable cell format
  217. HOUR formula problem
  218. eliminating hidden cells from sumtotal
  219. identify last 2 digits in a long data phrase
  220. 'Colors' as criteria?
  221. Refer to another worksheet
  222. Countif forumla question with time, please help!
  223. Count if italics?
  224. What am I doing wrong?
  225. protect in macro
  226. change an existing equation
  227. Date Format
  228. Time and billing on Excel
  229. Dates being accepted in an accounting cell
  230. Pivot Table Field Settings Help
  231. Number of Times A Player
  232. Combo box problem
  233. numbers won't add
  234. Help with Formula
  235. If Formula
  236. Formula help
  237. Select
  238. AutoFilter 2+ Categories [Macro]
  239. Change all cell references n cells to the right?
  240. Combo boxes - options and performing calculations
  241. Hide Row Number only
  242. Copying cells
  243. select cell range??
  244. Applying header to first page of worksheet only
  245. Looking up in a table
  246. Populating a combo box from rows in a table??
  247. Help with links to macros in other workbook
  248. If Help
  249. Excel Not responding has DDE links saved on Network Drive
  250. Putting accents into Excel