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. both indirect and shifted cell value
  2. delete cells until value in equal
  3. saving formulas/ functions
  4. Save As with Version Number
  5. is it possible
  6. Countif???
  7. Goal seek to find break even but not working
  8. track who enters into the workbook and what time and when they leave the workbook
  9. Sumif, Vlookup combo help
  10. Condition code True False on Checkbox
  11. pulling from a word doc...
  12. re:help
  13. Printing Pivot Table Reports - is there a quick way to add page breaks?
  14. multi column search_multi column return
  15. 2 questions, Hide print preview buttons and accessing hidden sheets
  16. Edit selection
  17. using "&" to add text to a formula
  18. Referencing Multiple Rows
  19. Drop Down Box/List
  20. Select columns programmatically
  21. Creating find and replace dictionaries
  22. Pivot Tables and ODBC
  23. PivotTable
  24. Read only file
  25. Excel save from command-line
  26. Excel data export
  27. Rearranging Equation
  28. Sharing data between workbooks
  29. How to change digits in a string? Very large list
  30. how to enlarge a userform...
  31. How to: freeze a cell while dragging other formulas down.
  32. Using info in one cell to multiply into another
  33. Passing Variables Externally
  34. Remove "All" in pivot drop down
  35. Can't Open Spreadsheet by Double Clicking
  36. Returning a value of an intersection
  37. Filtering down a list ?
  38. run a formula once w/VBA?
  39. organising data in a worksheet
  40. Mail Merge pop-up appears
  41. Selecting tab when opening worksheet
  42. MS query problem
  43. Re-naming Columns
  44. Dropdown
  45. Freeze column width in pivot table
  46. User form problems
  47. if statement see "Male" or "Female" returning "Y" otherwise leave blank
  48. How to calculate months from mixed data
  49. Time to pay credit card
  50. Paste hyperlink to a hyperlink in another sheet
  51. date formula
  52. Vlookup
  53. Breaking up a string
  54. Return string between two specific characters
  55. Identifying external links in a sheet
  56. formular
  57. Help needed on looking up specified date and summing totals
  58. Validation List from 2 or more referenced cells
  59. Query Automation
  60. VBA with Excel website
  61. time zone assistance
  62. help with really long code
  63. Pulling information from column 3
  64. Autofilling Multiple Sheets
  65. how to debug and get an output
  66. If statement in chart
  67. Help Removing This "Watermark"
  68. VLOOKUP is failing me
  69. Logging Changes
  70. Solve for Monthly Loan Payment Amount
  71. Help please
  72. auto sum for timesheet
  73. Paste Special
  74. simple calculation.
  75. Use criteria to calculate slope and intercept?
  76. Random Lists
  77. Need some help again.VBA probably
  78. String assuming date format
  79. Alt-D
  80. Need Help writing bond price conversion
  81. looping through data
  82. still waiting for ur kind reply
  83. Making a quiz in excel....
  84. Inserting a series into a chart
  85. Data Text to Columns
  86. Could someone help with this please?
  87. Sensitivity Reports
  88. Number Date Format Mix
  89. Return Date of Min and Max
  90. Maintain Private Information
  91. Combining sheets
  92. Removing Seconds?
  93. Sorting on case of 1st character
  94. Please help me
  95. Is it possible - Scatter Plot with Names attached to each point
  96. Need help finding a formula that I can use to reference different Columns
  97. "Data > Text to Columns" question
  98. File Save w/email prompt
  99. Search and display cell info
  100. COUNTA-formula with additional condition
  101. Consolidating Data
  102. Highlight matched data in different worksheets
  103. Bypassing Edits
  104. Merge multiple rows with <alt-Enter> intact
  105. Combining Items in a list
  106. Date Stamp
  107. Case Sensitive Data Validation
  108. Disable the save button
  109. get contents of cell from matching name
  110. Can Any One Help Plzzz
  111. Flickering screen
  112. Formula Help
  113. Add percentage of sum to the sum
  114. Combining with formatting intact
  115. Insert row - Formula must follow
  116. Auto Clear
  117. Formula Help
  118. Deleting part of a cell
  119. Sharing Violation
  120. vlookup max value?
  121. Where are external references in this file?
  122. Merry XMas
  123. formula to fill in blank cells
  124. Filter macro
  125. Why do you not work TD?
  126. A little Elementary help
  127. Vlookup(ing) a null field is returning a 0
  128. Copying excel formulas
  129. SUM if Date >= today!
  130. I'm All Locked Up
  131. Optimizing formula?
  132. Formatting a cell with multiple text entries
  133. My Fractions
  134. automatically update sheet from another user
  135. format issue
  136. Need help for fire department
  137. Display Options
  138. Display Positive Interger
  139. Goto command
  140. pivottable hidden info
  141. PDF to excel format
  142. need help
  143. VLOOKUP and ...
  144. Opening a file Read only via a shortcut
  145. Merging complex changes by 2 developers
  146. Hiding sheets
  147. How to remove or apply Apostrophe form the start of a number
  148. Very Challenging question......
  149. Detect change in cell with formula
  150. Random Number
  151. Name cell
  152. Data Transfer
  153. put the first name and surname in the right order
  154. Lists Comparison
  155. Transpose data
  156. plz help
  157. Data map (three dependent validation lists)
  158. Limiting Input into cells
  159. bill of materials
  160. counting input errors
  161. How can I automatically convert many desktop shortcuts to hyperlinks in excel
  162. Excel Exam Question
  163. Data validation drop-down list - format
  164. turn calculation of max runup to UDF in VB
  165. Problem with .Find()
  166. Massive Mess!
  167. cell has junk in front of my data!???!
  168. Good resources for learning about Solver & macros?
  169. Match Rows
  170. Login username from Excel macro
  171. %my document%\PackMaterials\
  172. VBA Variables
  173. Buttons, buttons, buttons...........
  174. Real time table generation
  175. SUMPRODUCT((ISNUMBER(SEARCH() function
  176. excel expert, bill gates required
  177. Is this possible?
  178. Finding shortages and how they are divided by suppliers No2
  179. Find the last row.
  180. Please help! Object variable Error - New VBA user!
  181. Help in V-Lookup
  182. Linking workbooks
  183. change font size of drop down list
  184. Triggering an event from a cell
  185. sorting database
  186. macro not seeing vlookup
  187. Change the default paste method??
  188. Corrupted file
  189. mm/dd/YYYY to just YYYY? Formula?
  190. Looking up values and returning items into a calendar format.
  191. Offset command
  192. Search Function
  193. Deselecting problem
  194. Whole sheet conditional formatting
  195. Searching for and counting blank cells
  196. Data validation based on other criteria.
  197. Help with a lookup calculation
  198. Forecasting student participation
  199. Dynamic Range problem
  200. Excel email
  201. Time Calculations please...
  202. Today's week number
  203. My view vs. Print Preview
  204. displaying the text from a URL on the cell
  205. Is there a formula that will do this
  206. adding a prefix to cells
  207. switching autofilter on or off with macro
  208. large document / options
  209. Run Macro when click on tab
  210. looped "if statement"
  211. shortages divided by suppliers
  212. Sorting formulas
  213. conditional sum wizard
  214. Help with scripting & formulas
  215. More date format problems
  216. Putting Managers underneath areas
  217. Pivot Table
  218. Strange
  219. Automating IE using VBA
  220. Looking up
  221. Simple If Function
  222. 90° rotation of cells in Word
  223. stdev IF...
  224. insert blank row
  225. multiple VLOOKUPs MIN and MAX
  226. How to track which user changed a certain cell.
  227. print field results in groups
  228. Look for "text"...!!!
  229. How do i chop up a spreadsheet
  230. Validation question
  231. coded if statement
  232. Finding average while excluding zeroes in a vintage model updating monthly
  233. Phantom? or Zombie? Email hyperlinks keep coming back after removing them.
  234. getting the size of a new worksheet
  235. A simple way to produce a cell tool tip?
  236. Auto-incrementing worksheet names within formulas
  237. Show userform while script is running
  238. Recording Multiple Function Results
  239. two questions about refrencing data
  240. How do I insert and move a column to a spreadsheet
  241. Excel time formating driving me insane
  242. Default Text
  243. Trying to return month for pivot table
  244. Pass sub variable to function
  245. Autofill Problems-Need parts of formula to fill different when pulling from 2nd sheet
  246. Reference Error
  247. Naming ranges and using them in formulas
  248. This file is not a recognizable format
  249. Using Sheets from User Forms
  250. understanding excel