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. Set default save as name?
  2. List boxes
  3. Cell contents, conditional format - hardcode vs functionresult
  4. Mass email thru excel
  5. UserForm Date Labels
  6. Date format changes when I mailmerge
  7. import refesh
  8. Saving a chart as a picture
  9. Date and Time Formatting
  10. How do I lock a cell based on content of another cell?
  11. SUMIF to meet a criteria within a date range
  12. Compare two columns
  13. Linking Worksheets
  14. change "TRUE" to something else
  15. Healthy Search engine
  16. Manual Recalculation of Cells
  17. Naming
  18. Subtotals
  19. Best way to solve new problem!
  20. Help required
  21. Mac Excel Web Query - Help!
  22. Help with hyperlinks in Excel
  23. formula to a macro
  24. Copy Rows from 1 worksheet to another
  25. mouse over to show pictures
  26. Time not adding up?
  27. generating list of names ending by a variable string
  28. Conditional formatting, OR operator
  29. the problem of counting and listing...
  30. Cell shading according to date
  31. Alert on date passed
  32. Combobox text placement
  33. date format
  34. Changing text to upper case
  35. uppdating dde links
  36. Conditional Formatting
  37. SUMIF within date range
  38. Custom AutoFilter
  39. Trendline for only part of data?
  40. auto fill cell
  41. time sum with overtime
  42. circular reference
  43. Emulating memory in excel
  44. Invalid references
  45. Collapsing Calculated Data into A Succint Format
  46. Conditional formatting of weekend dates
  47. Forecasting
  48. Slight problem
  49. Count points given per week
  50. ActiveX ComboBox: Almost there!!!
  51. Address List Sort Problem
  52. hello everybody! just want to say hello
  53. macro at startup
  54. DOn't know how to get this macro to run..
  55. Don't Print Cells when Formula results Zero
  56. link edits in sub-list to the main list
  57. 2 pages per sheet
  58. hiding formulas
  59. Insert Flash game
  60. I want to know as I create one functrion
  61. close without save
  62. Entering variable data into a formula
  63. Filter
  64. cell formatting
  65. Give formular a range of cells which selectively creates total based on other column
  66. IF , THEN functions
  67. sorting?
  68. Creating formulas based on Pivot Tables in Excel 2002
  69. edits a sub-list have it show in the main list?
  70. counting words with a specific ending
  71. Question about sorting two lists
  72. SumIf help
  73. Matching Two Cells and ...
  74. converting data from column to rows
  75. Check Normality of the data in Excel
  76. Variable Range Names in Formulas
  77. Date Sorting with Pivot Tables
  78. Conditional Formating
  79. How to get column placeholders to continue in CSV
  80. Help with Forumula for Whole Numbers
  81. Automatically open another worksheet. . .
  82. Sumproduct(PartNR="100*") doesnt work?
  83. Convert an Excel list to .exe or other
  84. Boken Page Break Lines
  85. Right Justified
  86. > < = arguments
  87. VBA to close workbooks
  88. Decimal with . instead of ,
  89. Excel to Access
  90. Normal Chart From Pivot Table Data
  91. Data Validation - drop down problem
  92. Top 3
  93. Code to open another workbook
  94. Queston Regarding Conditional Formatting
  95. Vlook Up Help
  96. remove "all" choice from pivot table page area
  97. SUM using string tag as start point
  98. VLOOKUP Funtion within a User Form
  99. Counting Cells
  100. Conditional formatting by date
  101. Reference book
  102. sheetname = cell name in sheet
  103. There’s a SUM, an IF & an AND in there somewhere
  104. multiple lines into same cell...sort of
  105. Start week on Monday
  106. looking for analysis toolpak for excel 2000
  107. can you drag this down to save time????
  108. Modifying Drop-Down Text in an ActiveX Combo Box
  109. Newbie needs help with String Manipulation & Macros
  110. Static Column
  111. text direction
  112. Validation from another WorkBook
  113. Add in the best solution?
  114. Worksheet was 4MB - Now 20MB. Why/how?
  115. condition
  116. Frequency table
  117. Need serious help. Please
  118. Button to search
  119. Pounds and ounces ???
  120. Tricky Formula
  121. Prevent user from renaming worksheet tabs
  122. Make the Zero line Darker
  123. Chart Plotarea nightmare
  124. Copying Charts
  125. Cost Analysis problem
  126. consolidating diffrent workbooks
  127. Need help with Formula
  128. Removing formatting in HTML output
  129. Viewing spreadsheets
  130. Odd question re: cell referencing
  131. Formual: Percent of range
  132. Removing Text from numbers
  133. Currency Conversions w/ If Statements?
  134. Restore size
  135. Seriously...Excel/Word experts only, I'm amazed no one can find the answer on this!
  136. Excel Tabs
  137. Excel security
  138. I am New to Excel. Need Help with mailing list.
  139. Duplicate Data
  140. change formular
  141. filter on coloured cells
  142. Selected cells in Vba?
  143. Highlighting Values
  144. CUMIPMT Function
  145. Can not REPLACE number (formula) in a cell
  146. Worksheet naming
  147. Cel Format From Number To Percent
  148. Method 'ExecuteExcel4Macro' of object '_Global' failed
  149. How do I unmask a link in Excel 2002?
  150. can you please help!!
  151. How do you create a combo box where you can both add to AND select values from a list
  152. IF THEN Newbie question
  153. Sort Columns by Cell Character length?
  154. how do you omit part of a cell in a vlookup?
  155. Rolling 12 month average
  156. done by excel experts only
  157. Filter Records
  158. Change order of query updates in pivot tables
  159. Labels and a Formula
  160. Range Formula
  161. Formula
  162. Duplicate Worksheets
  163. importing text but it spreads across cells
  164. moving data from one column to another
  165. need help in sum up multi criterias (index & match)
  166. Questions on using solver function
  167. macros?
  168. Adding Cells in multiple worksheets
  169. data more than rows
  170. Help with formula
  171. Text into formula
  172. Print Problem With Columns
  173. how to filter data and delete double records
  174. query
  175. adding pages
  176. How is that number changing?
  177. done by excell expert only
  178. Vlookup question
  179. Vlookup Help
  180. Highlighting Every Other Row..?
  181. creating names?
  182. AND conditional statement and nesting IF funtions
  183. clear all data values
  184. Getting ################# in cell
  185. Help with functions
  186. Date
  187. Printing Question - changing formats - print like a database!
  188. Adding values within date range
  189. #value!
  190. pasting data to a specific cell
  191. Checking for and then deleting duplicate data
  192. Graphic X=cte
  193. Weekly/Monthly Averages
  194. Vlookup for non-sorted data
  195. excel does not prompt me to save when clicking on X
  196. seconds to minutes
  197. Critical Emergency, Strawberries to The Fixer.
  198. Filtering data dependent on the date
  199. to display only the value of a cell
  200. Sort (But cells change)
  201. Date now Time Now
  202. Insert Copied Cells problem
  203. Opening a document to a new window
  204. Comparing values in two columns
  205. i NEED help major! on lookup tables PLEASE!
  206. vlookup returning last value
  207. conditional formatting What else is there?
  208. Getting header and footer on all worksheets
  209. MAX value with multiple keys
  210. Combo-box fails in a protected sheet
  211. Adding 3 calendar months to a date
  212. Compiling One Sheet on Top of Another
  213. Is there a Formula to ...
  214. Using Macro To Find & Replace Names
  215. COUNT IF statement looking for greater than zero
  216. this is a tricky one
  217. summing different info from one column
  218. Formula Bar
  219. importing specific data
  220. entering 1 number automatically moves over one cell to the right
  221. symbols input
  222. counting if not duplicated
  223. Date Format
  224. Incorperating Hyperlinks
  225. Renaming a worksheet tab is stuck in a loop. Help!
  226. Active Directory References? help...
  227. text manipulation
  228. Count Coloured or formattedcells
  229. formula help please
  230. Why oh Why...
  231. Result by Colour
  232. VLOOKUP/MID Issue
  233. Excel Formula to Sort then Avg??
  234. Workbook Page Variable Name?
  235. Count with an AND statement
  236. Combine Unique data for Same Identifier
  237. Can I identify entries NOT done in Proper case?
  238. Declining Balance Depreciation
  239. Fornula for interest rate
  240. weekday formulae
  241. Auto Date and Time functions
  242. intra workbook links with blanks
  243. Flip a column
  244. save as text somehow data is now in quotes?
  245. #n/a
  246. Filtering
  247. Finding/Deleting Old Links
  248. Sharing Workbooks
  249. Pulling the entire row
  250. Annualized Turnover as a %