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. Exporting to Access-Error Message
  2. keyboard shortcut
  3. renaming multiple sheets in a workbook w/ autofill?
  4. Calculating annual payments
  5. IF_Else statements and times
  6. Imported numerical data keeps rounding up - help please!
  7. User Defined Functions - slowing down spreadsheet
  8. sUM OF ROWS
  9. database problem
  10. Formula auditing!
  11. WorkDay Count Formula
  12. Loop through range and get all emailadresses in the To:field.
  13. Grouping Dates into Monthly Totals - Pivot Table.
  14. cont based on different criteria
  15. Lookup functions
  16. Who wants a challenge?
  17. Using Solver
  18. Min & Max & Na()
  19. Randomly generate numbers in 4 cells where the total of all 4 cells doesn't exceed
  20. Alert Box
  21. Count Help Needed
  22. Links in Tabs not working
  23. Cell format.
  24. Excel online/workspace help
  25. Dynamic list of customers
  26. Import external data
  27. Moving a Page Break
  28. Forgot to Save... How can I recover backup file?
  29. Conditional Formatting and dates
  30. Userform Help
  31. cell color based on value
  32. Randomizer Help
  33. DNS and Excel
  34. Checking filename on startup
  35. Constant Reference Point
  36. access to text convertion
  37. decimal point
  38. Do I need an Array formula??
  39. Email Hyperlink problem
  40. Conditional Formatting or...
  41. Using Macro To Find & Replace Names
  42. Count
  43. Placing a value into a range of cell based on two dates
  44. Re-name a named range - Please help people!
  45. Please Help
  46. N/a Not Showing On Chart.
  47. Zip-Code Format Issue
  48. Extracting data using a formula
  49. How to create an "anagram solver" ?
  50. Sum If Another Cell Has The Word (1=2) In It
  51. can't see audit tool arrows - Please HELP!
  52. Extract the nth character in a string of text
  53. Merging Data in Excel - Help please!
  54. Cleaning up dates
  55. Return Cell References
  56. if statement
  57. Email workbook macro
  58. Re-name a named range
  59. SubTotal function. How do I keep reuse Subtotal criteria.
  60. Urgent help reqd. in calculating working hours
  61. Setting control limit for macro comparison
  62. COUNT function returns zero
  63. Need help from the real world experts in Excel
  64. Recongnizing values for Cells.
  65. Excel reports - format different on different machines
  66. Advanced Filter Criteria
  67. Trying to insert a function
  68. Pulling the whole Row
  69. SECOND REQUEST...HELP!Excel Hyperlink doesn't open Word doc the same way as Word does
  70. Incrementing a sheet name
  71. Better computer specs for running excel
  72. Sync Daily Input Spreadsheet w/Individual Spreadsheets
  73. If Formula
  74. Date Formula....help!!!
  75. Speeding up macros in Excel
  76. Help Please (Hard to describe in topic)
  77. extracting just numbers from a cell
  78. Choose from List
  79. IF logic_test=true, "how do I input text from the same table into another cell?"
  80. array formula and divisions
  81. Formula in a Header/Footer
  82. exporting access to excel
  83. Automatically update links to other workbooks
  84. Change Cell Colour
  85. Another Vlookup
  86. = Autofilter
  87. formular copy &paste disfunction
  88. Clever Excel person needed!
  89. Formula Q
  90. Need help counting
  91. Find Info On Different File?
  92. Excel 2003 Not Excelling in Handling 2000 .xls File
  93. Some one help me please
  94. automatic character replace?
  95. Hyperlinking
  96. Looking Up Values
  97. from .txt to .xls how past data in seperate cells
  98. Making cells sort thru lists of data
  99. how to crack in opened password ?
  100. Activate a file in my macro
  101. Need Cells to Recognize Certain Numbers and Change Colors
  102. Excel Charts in Word
  103. Freeze/Split
  104. Nice easy one...
  105. Conditional Formatting and Protection
  106. Excel 03 conflict with Windows Guest user login
  107. Hiding a row
  108. Excel 2003 Linked data returns Cell Reference Display
  109. Formating
  110. Removing unwanted, unknown character?
  111. find the smallest number greater than Zero
  112. forumla help
  113. Blank Cells - Highlighting them
  114. Grey box with buttons
  115. no file found
  116. I need help...any kind souls out there..? :)
  117. starrynight64
  118. Summation top x of y
  119. Removing unwanted text
  120. recover a deleted worksheets
  121. Showing Images In Excel
  122. skipping #DIV/0 when averaging range
  123. Setting default date format
  124. Dependent list doesn't work
  125. Zip-Code Format Issue
  126. wildcard help
  127. percenatges
  128. one more thing
  129. Indirect Formula
  130. template is locked out
  131. Macro from List?
  132. count Re-occurrences
  133. How to get rid of a toolbar
  134. Link Problems
  135. How to make VLOOKUP return 0 (ZERO) if the search criteria is not found
  136. excel - format copying ...
  137. Summing a v lookup
  138. Date
  139. synchronise records and insert a row where they dont
  140. Opening an Excel file Problem
  141. Please help. Novice.
  142. Scripting the Syncronization of 2 Excel spreadsheets.
  143. Automated Data Extraction from Multiple Workbooks
  144. Replacing excel sheets
  145. Excel - can't deselect a cell once picked
  146. Pivot Table Autoformat Help
  147. detecting duplicate numbers
  148. Linked Cell Finder Apps/Add-Ons
  149. Histogram (Intervals)
  150. Filtering the Data
  151. Cells that average differences between 2 columns
  152. Duplication issue when filtering unique records
  153. Collating many rows into one?
  154. Please Help
  155. Removing everything after a dash
  156. Need help calculating project hours
  157. charting using height AND width
  158. Multiple Workbooks, please help
  159. Regression problem – please help!
  160. Possible or Impossible
  161. search for partial match
  162. Sort with 2 excel file
  163. vlookup
  164. Find and Replace - Selecting a cell while box is active
  165. earch & Highlight - All instances of "r"
  166. Excel Problem
  167. data position
  168. Links do not automatically update
  169. New to excel need some help please.
  170. @if function to sort the product of division
  171. Trim Function
  172. Continuous error messages when entering any formula in a cell.
  173. Linked Spreadsheet Error Message
  174. Circular Reference
  175. Login feature, help on adapting it for multiple users
  176. Weekly report with dynamic data
  177. Getting the oldest date with criteria
  178. Linking only selected rows/cells to another worksheet
  179. Filter: "Begins With" does not work with numeric values
  180. test
  181. COUNTA help please
  182. Calculate an average when two criterias are met
  183. Relative reference of worksheets?
  184. Cell color definition
  185. excel help - advise
  186. Help selecting random rows of data
  187. How do i do this....
  188. Draw: Connectors: Problem
  189. Lost my Shortcut Menu
  190. sum values that are coloured in red
  191. Reversing Positive and Negative Values - Possible?
  192. execl x compatibility with excel xp
  193. Please help me to keep the zeros in my cells
  194. Emmed Picture into Cell as Background
  195. Dividing And Zeroing
  196. Division Of Range Of Cells..help!!
  197. Repeat VBA Function Across All Worksheets
  198. Problem with custom toolbars
  199. Longest Time
  200. Compatibility test
  201. Excel for datalogger
  202. Whiteboard
  203. Postcode Frequency Count
  204. Double click cell to follow formula?
  205. 2007 Beta Comand Buttons
  206. Help
  207. Help Please...
  208. Macro
  209. Tasks for work
  210. Strange Cell Format ?Bug?
  211. Shared Workbook - Protect Worksheet
  212. Insert date when adjacent cell changed
  213. Select a range
  214. Macro to group, insert rows & Sum
  215. Help - sheets greyed out!
  216. How to keep a line or a column static while moving all the rest?
  217. Hyperlink doesn't open Word doc the same way as Word does
  218. Faster alternative to SUMPRODUCT?
  219. PivotTable - Calculated Fields based on field of a previous week?
  220. insert rows depending on how many are required
  221. Subtotal
  222. Counting from one table and plotting in the second
  223. Taking data from one table then finding and deleting in another
  224. user level authentication excel 03
  225. Open Ended VBA Criteria
  226. Pivot Table and Cell References??
  227. Pivot Table & Formulas??
  228. Formula returns #Value! empty cell value
  229. Detecting formulas vs. constants
  230. Whats Wrong With This Formula
  231. Better Approach to Generating Quarterly and Annual Reports
  232. troubleshooting generate
  233. Count of filtered items
  234. if statement where cell is not empty
  235. Lookup up values
  236. Values in cell help (easy)
  237. Hyperlinks
  238. Searching for the day of the week
  239. 0 hrs. 27 min. 53 sec. convert to decimal
  240. assigning a point value to cells
  241. Several If Conditions In a Userform
  242. Can someone please help! Formula Question
  243. Macro search problems
  244. Maximum number of saves for a spreadsheet
  245. Filtering with blanc rows
  246. Cut and Paste Hell
  247. search by LastName using a form
  248. Excel Format Conversion and Compare Tools Question
  249. Save As Issue
  250. Displaying data