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. VBA Macro questions
  2. Fixed Colon Placement for Entering Time
  3. sorting numbers with 3 & 4 digits
  4. Shared workbook
  5. Replicating Text in another Worksheet
  6. sorting
  7. Using excel in extended desktop (2 screens)
  8. Subtotal and Protected Worksheets
  9. Insert Column error
  10. how to have different column widths for the same column
  11. List Validation
  12. Vlookup multiple values for same ID
  13. Error message while trying to collapse grouped rows
  14. advanced functions graphing
  15. Averages
  16. Sorting data out
  17. Advisory "window" that appears when opening a spreadsheet
  18. Excel - SQL editing
  19. how to flip data
  20. Rounding Upward
  21. Average date
  22. Sorting Data
  23. Sorting Data
  24. Sorting by multiple criteria
  25. reference to another sheet, but i have a problem...
  26. total for the month
  27. Oracle's Group by Clause in Excel
  28. Printing worksheets
  29. Linking two sheets and cells
  30. Barcode Address Labels
  31. "Rotating" An Excel Spreadsheet
  32. Conditional format repeating numbers
  33. Copy Formula results and paste only results
  34. Possible to use 'countif' for multiple criteria?
  35. Formula or VBA code to reformat data
  36. Populate one sheet from a RAWDATA sheet
  37. Please Can Anybody Help Me In Doing This???
  38. Calculating replacement days
  39. Formula to add up the number of 'T's input in cells (T's used as a code for training)
  40. Selecting a Random value from a list
  41. Copying a sheet to a new "formatted" sheet
  42. Vlookup between two ranges
  43. Auto-fill results from List selection
  44. formatting text
  45. keep a running total in one column and automatically have it update
  46. Automate Zipping Excel Workbooks
  47. 160 page spreadsheet with Summary Page
  48. Macro- Select Last Cell w/ Data When Finished
  49. Looking up existing data ranges
  50. Explain Vlookup
  51. Have Custom cell format in all workbooks
  52. force '07 colors on older versions
  53. Copying Filtered Data
  54. Opening Excel File
  55. Corrupt File (Maybe)
  56. Ordering data easily
  57. =Cell("filename")
  58. Recommend a Access website
  59. Standardizing Data Format Formula
  60. Pop ups? Expand descriptions?
  61. Deleting duplication
  62. Formatting pivot table drills?
  63. worksheet tabs not visible
  64. Concatenate
  65. If formula
  66. Selecting only cells that require data entry
  67. Shorter formula
  68. Conditional formatting : Zeroes and blanks
  69. Struggling with sumproduct
  70. Counting How Many Cells =, <, > a particular range/number
  71. Joining multiple cells into one line.
  72. How do I extract & sum conditional data
  73. Combining info in multiple cells for more than one item?
  74. fill colour icons missing
  75. How to keep Thick border when filtering
  76. HLookup
  77. Average ignore #DIV/0! error
  78. Match Summary/Ladder
  79. Changing size of excel sheet
  80. Summing Time
  81. two files, trying to filter together
  82. Cross Sheet Function
  83. remove contacts in email addresses file from the Outlook Export
  84. Vlookup and list
  85. Page Numbers
  86. Worksheet optimization tips
  87. Inserting Pictures
  88. Creating Drop Down List
  89. Insert Hyperlink
  90. Recommend a VBA book
  91. Excel 2003 converting with 2007 but have script
  92. How to convert a bunch of 2003 into 2007
  93. Run Frequency through Dcount()
  94. Sum conditionally?
  95. Adding text to multiple cells (prefix?)
  96. Text to Column..Column to Text, CONCATENATE ???
  97. Excel help will not allow active-x to run???
  98. Access to Excel Exporting
  99. Do you know a good MS Word forum like this one?
  100. General mail failure when trying to send excel spreadsheet by email
  101. Range Name in Formula?
  102. Limiting spreadsheet use, where a person can use it but can't email it to anyone
  103. Stocks / Dividend reinvestment calc's in excel??
  104. emailing from Excel
  105. Imported data update rate < 1 minute?
  106. VLookup...Wrong Formula?
  107. count use of a value in several files?
  108. Removing * from an imported cell
  109. CPU usage question for excel 2007 users.
  110. Mysterious Excel Problem! Cells changing from formulas to values!
  111. V-LookUp Formulas
  112. Making a cell reference itself
  113. Excel 2007 Menu's
  114. How to pull out numbers from a text string...advanced "text to columns" question
  115. looking to paste information into different lines via a macro
  116. Option buttons and grouping!
  117. inking every other value
  118. Mystery red line?
  119. Can't amend drop-down menu (forms)
  120. Formula for Time and Motion study
  121. Please recommend a good Excel book!
  122. How to copy format, derived from conditional format?
  123. Print Header
  124. Easyfilter for Excel 2007
  125. figuring interest and showing the rate
  126. keeping hyperlinks
  127. Function Toolbar MIA
  128. Allowing certain things in a cell
  129. Excel and mail merge - need help
  130. Excel DSN Connection to itself
  131. Vlookup
  132. diagonal cursor movement
  133. Data won't update in cell
  134. How copy exactly another cell with 1 second of delay?
  135. Sorting question
  136. Incrementing values
  137. Moving panes
  138. Advanced filter question
  139. Function inside Concatenate Funcion ?
  140. select an option from H2 and cells (J3:J8) will automaticly update with Col A info
  141. Tracking a Project in Excel
  142. convert a excel file to HTML
  143. Output Format
  144. Using formulas in pivot table
  145. Automatically copy cell formulas
  146. Seperating Data in a cell to multiple cells
  147. a formula to show column info upside down
  148. Exporting e-mail addresses to Outlook Express
  149. Problems with links
  150. create my own bingo game
  151. Text formatting: from single cell to numerous cells
  152. Excel 2007 - missing character in hyperlink
  153. Macro Recorder button
  154. automating data import, printing
  155. Change A Link Dependant On Cell Value
  156. Generate Receipts based on List
  157. Excel rounding problem
  158. Guide interface
  159. estimating workbook
  160. How to Hide a column from one of the users accessing a shared WorkBook
  161. compare 2 worksheets with countif?
  162. Create shortcut to carry data over to another program
  163. Period Ending Calculation (eg Half Year)
  164. Wrapping text in integrated cells.
  165. Import BO 6 report to Excel
  166. histogram possibilities
  167. Lookup Function?
  168. sum only red cell in a row
  169. Automated work records
  170. Redistributing cells
  171. SUMPRODUCT...SUMIF...Pivot Table????
  172. Pivot table calculated field question
  173. excel will not open documents
  174. Linking Numerous Spreadsheets to one Master Sheet.......
  175. Tracking
  176. Sorting Data within cell low to high?
  177. Wildcard
  178. Special paste short cut key?
  179. Find vlookup result in list
  180. Referencing a sheet that doesn't exist - yet
  181. Data Lists
  182. Repeat a charatcter to fill a cell
  183. Send cursor to first blank row in sheet
  184. Excel Calculation Time
  185. How to convert units within a cell
  186. Validation lists - permanently show the arrow
  187. Font in validation menu
  188. How to export content of one word page to a single excel cell
  189. save a single sheet from a workbook as a separate file?
  190. Having array in the IF worksheet function.
  191. Vlookup?
  192. Using Excel to gather jpeg files
  193. Sorting Data
  194. Security Report Issues
  195. Save csv to xls, then hit funny error
  196. Conditionaly Format the Whole Row in relation to 1 Cells Information
  197. Filtering a spreadsheet via a search box
  198. Problems with the NAME box
  199. problems with MATCH worksheet function
  200. Customising Excel - the font of COMMENTS
  201. Text from Date formatted column
  202. Mail Merge
  203. Open ended Data Validation List
  204. To save a worksheet macro
  205. If/then Statement + timestamp
  206. conditional formatting
  207. Offset Cell C3 by 3 rows
  208. Excel Lock Up
  209. getting text from a cell and removing duplicates
  210. how to remove :1 :2 from my worksheet
  211. having problems with CONCATENATE
  212. Countif
  213. Excel to HTML
  214. scaling issue when printing excel document to pdf
  215. values that match a certain string
  216. Sumif
  217. Comparing values in cells between three worksheets
  218. question regarding IF worksheet function
  219. Vlookup Problem
  220. Number sequencer button
  221. Excel slowness
  222. File Save problem
  223. copy right col data to left col
  224. Create new worksheet when team name breaks
  225. "CONTAINS" formula?
  226. Excel to word to "Error! Not a valid link."
  227. How do I delete multiple double entries?
  228. repeat columns
  229. Presenting large Excel spreadseet on Internet
  230. Automatically Changing Numbers to Date
  231. Disable Temp File Creation
  232. If Statement?
  233. Pasting Formula from one sheet to another...
  234. Format is not valid
  235. entering formula
  236. Distance Forumlas how to?
  237. Index function problem
  238. Pivot Chart Data
  239. Excel Live Sheet Duplication / Copy
  240. linking arrays of data between worksheets
  241. MS Query Issues - Insufficient Connection Info. Driver's SQLSetConnectAttr failed
  242. Updating cell references when copying and pasting down rows
  243. Checkmark in cell
  244. Total lost
  245. Date Stamps For Excel 2007
  246. Getting Duplicate Row values into Columns
  247. Sorting and losting the position!
  248. Text to column issue
  249. Hiding selected rows
  250. Vertical to Horizontal