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. Extending Conditional Formatting
  2. Summing Across Many Sheets - Need a formula
  3. Editing part of formula-whole column
  4. Bullets and Numbering
  5. CountIf with two criteria
  6. Calculating compound interest per period over several years for an investment
  7. Aggravated by Autoshapes
  8. From info in text file to Excel fields
  9. Odd CF Question
  10. combinations of colums
  11. Is this possible? How? 2 sheets/2 variables
  12. Protecting an excel file
  13. Viewing category column
  14. Add Formula Automatically?
  15. Which format to use for minutes and seconds?
  16. add free text to combo box
  17. Create a a MTD sum funtion
  18. Formulas accross Workbooks
  19. Auto generate number???
  20. Download
  21. change cell to blank insted of #NA
  22. Macro to select only rows with a value in a range
  23. fill series in excel
  24. web query
  25. Excel worksheet problems!!
  26. 1 macro built of smaller macros
  27. conditional formatting
  28. Changing one aspect to a formula in multiple cells.
  29. Help - protection works too well
  30. If Right Left Query
  31. One spreadsheet opens two copies!!
  32. Macro for paste-special
  33. Colour Names
  34. Quotes
  35. Pivot Table Question
  36. Referencing a Worksheet using a cell reference
  37. Need a formula please
  38. Help with formula
  39. Custom Validation Criteria
  40. Formula Scripts
  41. Accounts Receivable Aging Worksheet
  42. 1 instance of excel
  43. linking worksheets (linking cell B4 in worksheet1 to worksheet 5 and so on)
  44. WBS numbering help, auto numbering with indenture
  45. Sorting numbers with different placeholders.
  46. Sumproduct
  47. auto filter
  48. Auto sum????? Help
  49. re: events/undo
  50. converting numbers stored as text to numbers...
  51. Problem returning value with 0700-1530
  52. Help With a Formula
  53. Populating lists
  54. I need a formula
  55. Help with text in charts
  56. Filters not working properly
  57. Same row and colum
  58. help with copy sheets of data
  59. Formula Problem
  60. Keyboard Shortcuts
  61. Opening Sheets
  62. Worksheet- avoiding cells
  63. decimal places and rounding up
  64. Error message when to input values add up to more than 100%
  65. Linking cells and still be able to edit both of them
  66. Hiding and unhiding rows - two scenarios
  67. Multiple column entries to single ones
  68. Importing charts from internet?
  69. Unhiding sheets progressively
  70. Help with data organisation
  71. Addition of cells.
  72. need to find simple sum %
  73. How can I make a random list ...
  74. auto data update not text addes lines
  75. Importing a worksheet
  76. Template--for want of a better term
  77. special paste
  78. If statement doesn't work for range?
  79. Header/Footer Resizing
  80. Importing images to Excel and macros/web queries?
  81. Noncontiguous Dynamic Ranges
  82. Macro - sending email
  83. Urgent - Numerically dependent cell fill color
  84. Macro help please!
  85. vlookup reversed
  86. Linking
  87. Validation Issues
  88. Macro - Combine/Insert Sheet
  89. Timesheet - Maximum carry over of hours
  90. Custom Auto Filter for more than two cells
  91. Adding following Zero
  92. hide all events during a macro
  93. Conditional Format
  94. Drop downs
  95. Greyed out cell property field
  96. Need help with many things :D
  97. Probability question
  98. Trouble Displaying PNG from Web Query...?
  99. years of work
  100. Conditional Formatting
  101. Read a number with a blank space at the end
  102. Leading zeroes in a text field
  103. Data lookup
  104. Workbook conected to another one
  105. Find & highlight duplicates
  106. macro question and count question... thanks!
  107. =if(iserror
  108. Deleting in excel
  109. Define Names
  110. Freeze Rows
  111. creating a report referencing another worksheet
  112. Is It Possible To Put A Vlookup Table On To A Vlook Up Table?
  113. Date - Look Up
  114. Simple question - big help
  115. Data Validation
  116. How many week days in a month
  117. Multi-user Spreadsheet - How do I do this ...
  118. A second of your time...
  119. please help with simple formula!
  120. using links in excel
  121. Macro that will open another workbook, update the links, and close it
  122. creating an email list
  123. UDF Similar To ASAPCELLCOLORINDEX?
  124. absolute reference
  125. Create a polished look
  126. Help with linking cells $ rows
  127. Conversion Excel Spreadsheets to One Access File
  128. Using the result of a combo box in a formula
  129. Help with PASS/FAIL function
  130. Identify certain ASCII characters in a text.
  131. help with multiple criteria
  132. If statement
  133. Maximum IF statements
  134. Filter & IF-THEN-ELSE help!
  135. Filter & IF-THEN-ELSE help!
  136. Sum of values
  137. Search and count formula??
  138. Date Dependent Rolling Averages
  139. Macro Help
  140. Graph and correlation help
  141. Cell recording & overwriting
  142. Help with If()
  143. Background Text
  144. Filter type bar on left side of column A, help anyone??
  145. Count Function
  146. correlation help
  147. add code line
  148. Need Help
  149. Excel Filters?
  150. Forumals Turning Off (ie., not working)?
  151. Lookup and ifs help please
  152. VBA programming reference
  153. Need help with errors using Trim and Mid
  154. Cell Reset
  155. help
  156. How to run a macro in a lot of files?
  157. Cell Rounding
  158. IF Condition
  159. referencing data from other sheets
  160. dynamic range - sort
  161. pivot table formatting
  162. Database functions
  163. Autofilter Pet Peeve
  164. Moving data to a variable location based on a cell value
  165. Conditional Format
  166. Help required!
  167. #VALUE! error from spaces in the fields
  168. Message Box Query
  169. Can This Email Be Done
  170. >today()-1
  171. Hi! Can anyone help me with a staff payroll system i am makingin Excel?
  172. Comparing worksheets
  173. macro to hide rows
  174. Recover excel document
  175. divide
  176. Extraction of Data
  177. adding a range then round up
  178. Date formula
  179. Exporting fixed width columns
  180. adding positive and negative hours in a spreadsheet
  181. help pls
  182. Hyphens
  183. referencing data on another sheet using row and column headers from current sheet
  184. Formula for retrieval of data
  185. delete extra rows at bottom
  186. Turn off auto update on opening
  187. Excel hates me!
  188. Searching on this forum
  189. excel patch differences?
  190. if statement
  191. excel opens the same file twice
  192. uppercase to lowercase
  193. Linked File Help!!!
  194. terminate spreadsheet at a column or row?
  195. Default Sort Order
  196. Preserving hypperlinks when converting to CSV, is it possible?
  197. VLookup or ??
  198. Multiple Look Up's
  199. Drop days from dates to just month and year
  200. conditional formatting in pivot table
  201. Leading Zeros and Concatenation
  202. E-mailing protected sheets?? HELP!!?
  203. AND OR IF question
  204. Mouse click value return from list
  205. Further Help Needed URGENT!!!!!
  206. formatting
  207. =average <> time problem
  208. column date formula help needed!!!!!
  209. Match
  210. one cell responding to data from another cell
  211. Quirky Data Formatting
  212. Advanced weblink functions.
  213. Inserting Comments on Protected Sheets
  214. IF / AND formula??
  215. Lookup not returning data due to "~"
  216. Vlookup HELP PLEASE
  217. Vlookup formula for more than one result
  218. Question on adding data to cells
  219. autofill
  220. Excel button desapear when using projector
  221. Desparate!!!!! - Payroll tax calculation
  222. Desparate!!!!! - Payroll tax calculation
  223. Can't create Array
  224. Looking for a high-skill Excel spreadsheet developer
  225. No Control
  226. Help figureing time differences...
  227. error with date funtion
  228. referencing the previous sheet
  229. Randbetween
  230. VLOOKUP problem
  231. Limit Text
  232. How do I calculate how many years an employee has been working?
  233. Problems with copying & pasting formulas
  234. Lost Menu
  235. Protect Sheet or Workbook
  236. Lock Keyboard & Mouse
  237. Logic- Extract Data into summary form from a list
  238. Problem Linking Cells in Different Workbooks
  239. Repeating sum of several columns
  240. Logic - Extract Data from List
  241. adding new row every other one
  242. Excel cell mouse movement problem
  243. Changing cell date in a file
  244. Round to nearest 50?
  245. sum product
  246. calculation confusion
  247. Creating Data Sets From Master Sheet?
  248. dates
  249. Sorting sheets acording to a input cell.
  250. days past