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. Show Zero value in front of my numbers
  2. Date / Calender Advise before I start
  3. setting permissions on Excel
  4. Smear ut negative values over positive
  5. Prevent Paste over Data Validation
  6. Extraction of data - Advanced Filtering
  7. Stocktaking
  8. Can Excel Do This?
  9. Question on sheets with multiple pages
  10. Insert Rows- Formulae
  11. Alt+enter lines and merge
  12. Broken links between excel and word...
  13. Calculate the distance to the next negative cell value.
  14. How to calculate characters in a cell?
  15. smart offset
  16. First post . clearing autofilters
  17. Text Color To Fill Color
  18. Formula-fill does not work
  19. Adding Multiple Worksheets...
  20. A Real challenge....
  21. recommendation for a book/website to learn VBA?
  22. AND function
  23. If Function Question
  24. How to find a value in a worksheet which matches an array value?
  25. when a cell is selected the row also automatically highlights a chosen colour
  26. Rename groups in pivot table
  27. Cell value(s) into Outlook
  28. Calculating Time
  29. User Defined type not defined Error
  30. Filtering data
  31. Date comparison
  32. Concatenated Hyperlinks - Help Desperately Needed
  33. Read Write Access Restrictions
  34. Pivot table field question
  35. randbetween
  36. formulae
  37. end of the week based on the date
  38. Copy partial row based on 1 column value
  39. Adding a space to text in multiple cells
  40. Margin Calculator
  41. vlookup...again
  42. Combo Box: with dynamic input range?
  43. Drop-downs + calculations
  44. pulling data from several worksheets based on dates
  45. Do I need to learn how to do Macros?
  46. Disappearing Text
  47. Text in one cell, # in another cell; Want together in one cell w/ # formats
  48. if outcome is less then zero
  49. subtract time
  50. booking system.
  51. Custom Message for Protected Cells
  52. Can Excel do this?
  53. Not enough memory
  54. Automatically setting currency
  55. Format Data Series problem
  56. Querying Data within an Excel Workbook
  57. change a text cell into a number format
  58. Using OFFSET in INDEX
  59. Macro not working correctly
  60. Select Non-Adjacent Cell Range in VBA
  61. Linking worksheets
  62. Formatting bar charts
  63. V-Lookup Help
  64. vlookup function
  65. Help with count function
  66. Rank by value and date?
  67. Across files
  68. create a dynamic array skipping #N/A and blank rows?
  69. Alerts
  70. Need formula to pick up cell in row to left that is not empty
  71. Text to rows????
  72. Excel not recalc'ng completely?
  73. Can't recalc an Excel workbook
  74. convert seconds to minutes and seconds
  75. text strings
  76. can't scroll with arrows
  77. Sorting
  78. Find which range a name falls into?
  79. Adjusting Sum Product for Date
  80. get cell data as text into another cell
  81. Is there a limit to functions in a formula?
  82. Quick Formula Help
  83. Excel to Word
  84. Need to get daily count..Used sumproduct but getting funny results
  85. Floating Button - Possible?
  86. auto filling help
  87. adjusting the row height for source data
  88. Move cursor to specified cell on next worksheet
  89. Index, Match
  90. Sumproduct is beating me!!!
  91. selecting certain data from one cell
  92. Dynamic macro
  93. How to add values instead of spaces???
  94. Changing Color of text based on a number
  95. Drop Down List
  96. Pivot
  97. Rounding a result in the same cell
  98. Excel Hand Tool
  99. Search & Insert Formula Help
  100. Formula to backout percentage markup
  101. How to capitalize first letter of every word
  102. Automatic Task Display
  103. Percentage Formula
  104. Ranking Formula
  105. Formula question
  106. Identifying which group customers belong to
  107. Excel Pro's
  108. how to hide formula?
  109. multi sumif
  110. Excel interest rate/calculator formulae
  111. Macro? - inserting a cell value for target sheet data entry
  112. BlackBerry Outlook - Pasting Tables and Retaining Columns
  113. Result based upon a list
  114. Change Format <99,888.21> to (99,888.21)
  115. Got a Problem
  116. Match problem
  117. Office 2002 vs 2007
  118. The Gods of Excel - Is it possible
  119. someone me
  120. Vlookup and N/A result
  121. Sumproduct
  122. How to Look up to other work sheet
  123. Multiple Series Charts
  124. If/left
  125. Can't find right formula
  126. Find back originale file before changes occured ?
  127. Mail merge from excel to excel
  128. Somewhat Advanced Prob...I believe
  129. Do I need to be good at math to do excel??
  130. another IF query
  131. show status of my team compared to other teams(based on scores)
  132. formula to increase a number by 10%?
  133. using IF to return text if the reference cell is blank
  134. matching names and data
  135. How to find position of capital letter in a text string?
  136. Is it possible to change multiple cell values at once?
  137. Mouse scroll function on drop-down lists
  138. which formula to use?
  139. Darn Sumproduct
  140. Pilot Logbook problem
  141. Logitech LX 300 Keyboard F Keys with Excel 2007
  142. Test Formatting Problem
  143. Couple of Excel Questions...
  144. Drop Down List
  145. Pivot Table
  146. Stuck again!!
  147. Dragging cell content to auto fill...I think
  148. Newbie problem
  149. find difference between tables
  150. Problem with web query all of a sudden
  151. Conditional Lookup Problem
  152. Removing Duplicates
  153. Filter Question
  154. Identifying Duplicates
  155. Count down clock
  156. Nested array functions in SUMIF
  157. SUMIF and only picking up currency values
  158. filters
  159. Multiple Lookups
  160. Web Query
  161. Advanced Autofiltering
  162. Get Value from Other Sheet Failure
  163. hyperlink
  164. How to maintain Print Settings for multi users?
  165. Time issue
  166. Multiple Column Lookup?
  167. Producing a bar chart to display hours and minutes
  168. Excel Filtering
  169. Is it possible to populate a Drop Down List from a database
  170. Always caps Lock in a certain range
  171. Simple userform rolling status bar
  172. count
  173. Help Required To Use SUMIF Function
  174. Information back and forth
  175. WorkBook Expire
  176. Excel neighbour row compare and mark
  177. String problem - UK postcodes
  178. Formula to do more than one action?? Please!
  179. COUNT IF, AND, OR assistance !!
  180. Combine Two Cells into One
  181. Time Sheets
  182. Protection and hidden sheets
  183. Removing dashes
  184. Errors when opening Excel
  185. round up or down
  186. Urgent Help
  187. Lock a cell conditionally
  188. Table to list
  189. Lottery Number Checking
  190. Column total issue
  191. Multiple Results
  192. Pivottable grandtotal range
  193. UK Postcode Formatting
  194. Wacky Clock Question
  195. Copy and Paste from many workbooks into one worksheet
  196. Copying over e-commerce (oscommerce) data to Excel
  197. Stopping Excel from inserting a path....
  198. returning data from cell next to MAX value
  199. Counting case-sensitive values withon a range of cells
  200. Auto-formatting Rows With iLastRow Variable
  201. Conditional Formatting
  202. excel - displaying all possible combinations
  203. Linking information between sheets
  204. Sorting values from two columns
  205. Excel and Java?
  206. Help out a Navy man.
  207. finding a value in a "if" statement
  208. Index & Match
  209. Printing Issue - Fit to Print 1 Page Wide
  210. merging worksheets
  211. Variable Column Entry
  212. Excel saved file
  213. Macro to Protect and UnProtect
  214. HELP! Complicated nested IF Statement is returning wrong information
  215. Excel Calc function not refreshing
  216. protection
  217. If Statement
  218. Stopping Disable/Enable Macro Message
  219. Mask Listbox Values
  220. check if the workbook is already open
  221. Protection properties
  222. Removing little green triangle
  223. Smart Macro
  224. Attach Signature to Protected Document
  225. 400 text files into one worksheet?
  226. Copy totals to new cells at top for summary
  227. Excel Subtotals in version 2003
  228. Summing Numbers With Specific Values To The Left Of Them
  229. Compound Interest with Annual Investment
  230. vlookup to return blank if condition met
  231. Inserted Columns and Automatic Entries
  232. Userform
  233. Delete Macro from personal.xls .. cannot find
  234. Hard Code Login to SQL DB
  235. sort method
  236. Lookup data on specific sheet and cell when I type Sheet name in...
  237. Macro for Creating Hyperlinks
  238. Still looking for assistance on previous thread...
  239. How do I lock a section of cells?
  240. Validation? VLOOKUP?
  241. Copy cell with space into 3 columns?
  242. Probability Simulation
  243. Limit Decimals
  244. Input Box at Start Of Workbook
  245. Excel Idle Time Close
  246. Custom Toolbar
  247. adding quantities from similar dates
  248. Publishing Pivot Tables with Interactivity
  249. Rounding formulae up and down
  250. format in a certain way, transpose