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. Checkbox
  2. how to convert numbers to letters
  3. Formatting
  4. Summing/concatenating via macro
  5. excel 2007??? why should/did i upgrade?
  6. Cond. Formatting with formula problem.
  7. Show form Across Addins
  8. Merge data from 2 sheets into 1
  9. Can I generate receipts from excel?>
  10. Hyperlink question
  11. Excel trying to open a macro on startup
  12. Exporting text and images from IE to Excel
  13. Link shows formula and not the value
  14. Searching for Duplicates in Workbook
  15. From master sheet to other sheets Auto Change
  16. Theory question: What do you think Excel does best?
  17. 2 If Functions
  18. sumproduct using a filter
  19. opening a file with error file not loaded completely
  20. Strings
  21. American Warrants
  22. Import from PDF
  23. Comparing two worksheets
  24. moving data from one sheet to another
  25. slight tweek needed
  26. modify macro
  27. Time Stamp each time a there is a cell entry
  28. change last cell in column
  29. Macro range issue
  30. Auto updating sheets
  31. Generate random numbers with no repeats
  32. do a calculation if a date range matches
  33. Resizing cells independently
  34. Pop-up Disclaimer?
  35. Conditional Formatting?
  36. Find and Delete multiple rows
  37. Grade entry
  38. IF function adding a text string after a number in the same argument.
  39. Ask to update
  40. VLOOKUP across 2 ranges
  41. Which Lookup function to pick
  42. Rota
  43. Auto Calculate function
  44. Run macro using non blank range
  45. Change ".PivotItems("2").Visible" to a activecell.value
  46. Tying Two Documents Together
  47. How Can i Transpose This?
  48. Activeworkbook.unprotect is not working under Workbook_BeforeClose event.
  49. Macro to randomly pick data and insert, is there one?
  50. Lock down of Hyperlinks on shared document
  51. Merge data if Column = Same
  52. array formular
  53. User with AutoSum problems
  54. Conditional Formatting Question
  55. Conditional Format in a cell when 5 other cells are filled
  56. Inventory analysis by prod. code
  57. Is there anyway to copy a column from one pivot to another?
  58. Multiple column widths
  59. Skipping over entry fields on a worksheet
  60. Formula Inquiry
  61. Help Needed with IF Function
  62. Stumped
  63. Auto Format fill colour background on certain cells
  64. Workbook opens multiple copies
  65. Disabling Excel's Sort menu
  66. Data Validation DropDown
  67. counting numbers between a range
  68. Pick value from 2D Decision Table
  69. Date Format
  70. formula or replace function
  71. Excel NOT printing
  72. merge formula
  73. file name
  74. Addins - Links
  75. Excel Button
  76. Returning data from another sheet
  77. Odd Problem
  78. Highlight Unequal Adjacent Cells
  79. Activate File Using Varible Name
  80. Advanced validation lists with name range formulas
  81. My monthly budget Spreadshet dont add up correctly
  82. Reffering to Sheet names in a worksheet cells
  83. How to add 3% to a column of numbers in excel?
  84. next ascending number
  85. inserting new functions
  86. Self counting macros
  87. Defining format using if function
  88. data modelling within excel
  89. how to complete the & formula
  90. formula re subtotal :
  91. Cell Functions
  92. if function problem
  93. Multiple "what if" Question
  94. Opening Excel file
  95. Filtering & Average Formula Question
  96. Conditional Formatting - Picking Color from a table
  97. Auto sum gave total in RED
  98. Formula to Compare 2 columns and Manipulate the Resulting Data and Output
  99. data from sheet to sheet diff col's
  100. Po to Invoice matching
  101. Sumif
  102. Get rid of #DIV/0!
  103. Finding numbers which are in 2 columns, not just one
  104. Deleting the contents of a cell after the first 7 characters
  105. deleting row/cell
  106. Match value with another column / sheet
  107. ASAP Utilities - inserting file path
  108. =if(d7="","",right(d7,search("/",d7)))*1
  109. Stop scrolling
  110. Moving Average input range display
  111. Forumla Displays??
  112. excel link to word table
  113. Lookup with two criteria
  114. Date calculation based on several dates
  115. Sort by item #
  116. editing a formula to contain multiple info
  117. "save as" problem
  118. Sorting gone Wrong
  119. Formula error
  120. Coping Formulas - Changing the Cell Reference to fit with a known pattern !!!
  121. Conditional Formatting Greater than surrounding Cells
  122. Date Format and Formula Convention Question
  123. Include 0% in formula
  124. referencing last cell with data
  125. conditional format #value
  126. Printing Sheet name
  127. Something a little off with my IF formula
  128. Smallest Number in a List/Bigger than X
  129. double quotes to txt (tab as delimiter)
  130. How to alter size of error bar of individual data point on diagram?
  131. Can 'ALL' be eliminated from a pivot items
  132. Find and add data
  133. Speech to text macros
  134. Reducing a date to a single number
  135. Copy Varible Data
  136. Single Column output required
  137. Excel Lists
  138. Problem with DATEDIF formula
  139. Permanent search/find box in cell B4
  140. Generating graphs according to column value
  141. Repeat Rows @ Top Of Pages 1, 2 but NOT 3
  142. Conditional Format
  143. Unable to add time.
  144. rotisserie baseball rankings
  145. Nested Function
  146. split a long list of rows into thirds
  147. Data From One Worksheet to another
  148. Mail Merge & New Record
  149. Formula for Countdown
  150. Removing images in a range
  151. Object Insert from AutoCAD
  152. trouble using a vlookup return value
  153. clearing macro
  154. Hyperlinks Between Office Applications?
  155. Formulas?
  156. Fleet Services
  157. Display text until whitespace
  158. Find data in one workbook from many workbooks
  159. number to text
  160. Zero Values as Default
  161. Resize an image to match a cell
  162. merging name columns
  163. Accrual/Invoice Tracking
  164. footer copy & paste
  165. Help! Lookups, and general questions. Probably easy, but I'm confused
  166. saving image
  167. skipping images not found
  168. Conditional cell locking/protection
  169. Conditional Formatting changing numbers
  170. Feet and Inches
  171. counting word
  172. autogenerate a number
  173. Bringing things into focus!
  174. Incremental Hyperlink
  175. Not specifying a range
  176. Total number of date entries
  177. Lookup
  178. How to calculate rows for unique records?
  179. Production tracking
  180. Parent Column Cells
  181. Lookup a value in a range
  182. Locate data from another sheet
  183. Formula to identify the sheet name
  184. Simplified formula for adding cells between first and last worksheets
  185. Simple Question?
  186. Cleaning up formulas after deleting worksheets
  187. Close Message Box If No Response
  188. Cross Post >> How to maintain history of exam results
  189. average profit
  190. excelint.exe
  191. applying a formula to more than one cell or entire column
  192. Cell Labels
  193. Somebody help me please - any help much appreciated!
  194. Updating Cells against Validation Parameters
  195. VBA to clear cells if value in cell 1 is 0
  196. can this be made smaller?
  197. Copy Modules
  198. How To Calculate Variance B/W Actual and Forecast Data
  199. Embedding Excel into Word
  200. what is the difference between ="cell A10" and =+"cell A10"?
  201. big sorting issue
  202. Choose and option and information pulls up
  203. Legacy Add-In Functionality Lost
  204. Want a Match() that returns an array
  205. Macro Dialogue Box
  206. Macro to find a cell then select a column
  207. Lists Data Validation
  208. extracting part of imported data
  209. MIN of an accumulating array
  210. Dividing months into weeks.
  211. Union of 2 lists?
  212. Subtracting
  213. transfering between spreadsheets
  214. Sum
  215. Help
  216. show numberous rows of data
  217. Auto-add cell details?
  218. Pivot Table Linking
  219. recover sheet
  220. How to paste to multiple cells as a suffix?
  221. direct cell in one wksheet to another???
  222. combining multiple lists from different sheets
  223. Referencing Last Cell in Column
  224. how to make a horizontal benchmark on a vertical bar chart
  225. Conditional formatting and filters
  226. combining to cells
  227. counting if question
  228. Cell Being Evaluated Contains a Constant
  229. Data Validation Linking Lists Together
  230. Data report on a new page
  231. =IF functions and text color?
  232. Big Trouble
  233. Control+z no longer undoes...
  234. Countif with array problem
  235. Posting Of Date Wise Records To Respective Sheet
  236. Pivot Table Question
  237. auto fill
  238. Forumla dates
  239. employee planner, improving existing model
  240. Copying formulae switched off
  241. Incremental formulae
  242. Option Buttons
  243. Way too deep for me
  244. Solving equations
  245. SUM Formula
  246. Relocate true rows to new tab
  247. Break in Graph
  248. Default file location issue
  249. saving
  250. Datestamp 6 months from now problem.