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. averages question
  2. picture in header
  3. Serial database
  4. Macro to print the data from previous page
  5. Page break on condition
  6. Finding text and summing with offset
  7. Sorting ranges that include protected cells
  8. Military time subtraction
  9. Sorting by Conditional Formatting
  10. If statement
  11. Page Breaks and Page Numbers
  12. How to delete redundant info/data rows
  13. Transpose question
  14. Excel startup?
  15. Paste Special is not working properly.
  16. presenting array lists returned by VLOOKUP in one cell
  17. How to Mail through excel which collects data dynamically
  18. odd way to transpose?
  19. Excel pivot tables
  20. Startup error
  21. Database
  22. repeating headings when printing
  23. Regression Equation Confidence Interval
  24. Colour Change based on Text Value
  25. How can i find the macro
  26. assigning an image a value
  27. SUMIF with 2 values. One contins words and one numbers
  28. index function
  29. share workbook which have macros with co workers
  30. Corrupt Spreadsheet and Temporary files
  31. 2 Dimensions of a table
  32. Excel 2007 Problems.
  33. Sorted data in drop list (data validation)
  34. How to combine 2 worksheets? Find duplicates without deleting rows or values?
  35. can't find named range on different sheet
  36. vlookup with date and text
  37. Excel 2007 Table Styles
  38. Password Protection
  39. Price updates from one sheet to another
  40. horizontal filter macro
  41. Format a Column from a Download
  42. how to format an address
  43. Protection of sheet won't allow me to use common functions
  44. Using one cell to specify the length of a moving average
  45. Multiple LOOKUP and IF....
  46. Excel and MS Access EBooks
  47. Error using grouped rows
  48. increment
  49. converting a percent of the whole to 100%
  50. Error- xl prompting to installation CD in order to complete installing the add
  51. Combining different worksheets into one workbook
  52. perfect circle
  53. Change the colour of only one legend of a chart
  54. F1,F2, F3 etc... not active anymore
  55. filter horizontally
  56. What Happend to This ?
  57. Drop Down List ... Navigation to a Sheetname
  58. How to delette in excel stuff imported from internet.
  59. Print Sheets front to back
  60. Formatting a simple multipage Userform
  61. How to launch Excel at a specified time
  62. check boxes in a protected sheet
  63. Vlookup (Last Value)
  64. How to combine SUBTOTAL function with ABS
  65. Commission Database
  66. Timeline
  67. Merging CSV files
  68. Excess spacing in rows
  69. Excel workbook statistics
  70. Read any x / y values of smoothed plot: then output to a finer table.. possible?
  71. How To: Make "Export to Excel" always open excel in a separate Window
  72. Excel formula If statement
  73. Question on Sorting
  74. Protecting interactive worksheet
  75. turn off msgs
  76. password protect sheet
  77. Find & Replace
  78. IF Formula
  79. Merge worksheets
  80. Too many formats!
  81. Matrix/array completion
  82. Excel 03-Vista-delayed responses
  83. I Need some Help with a list
  84. Can't autofilter my spreadsheet!
  85. Pivot Table Date Format/Sort
  86. Inserting Multiple Rows
  87. How to calc how far a 50% event is off
  88. Edit Validation List
  89. Check box text size
  90. Excel format settings for users
  91. Formulas no longer working
  92. Assign macro to hyperlink
  93. Calculate Problem
  94. Recording changes in the file
  95. IF Statement query
  96. Splash Screen
  97. IF formula based on background cell colour
  98. Find The Tuesday (Finish The Formula!)
  99. Conditional Formatting
  100. Two column drop down box
  101. Keep reference to a cell when column is deleted
  102. Search Tab in excell
  103. Producing report from one line of spreadsheet
  104. Medians in Pivot Tables
  105. How to use Conditional Formatting with OR for a range between -10 and 10
  106. I save as on my file How to recupare it.
  107. Find/Replace in Excel
  108. Linking Data from Access Table
  109. Paste Special Function
  110. Cannot find updated file
  111. Imported .xls online has spaces?
  112. Edit>>GoTo>Special in Excel 2007 ?
  113. Help with a formula
  114. Cannot shift objects off sheet, adding a column
  115. It shouldn't be that hard - 3xbegins with filter
  116. grouping worksheets
  117. The next number should be easy
  118. text wrapping in combo boxes
  119. Stratified Table - Median
  120. linking to data in other worksheets
  121. Extracting Information
  122. Remote function calling
  123. Pivot table maintaining cell format
  124. Lookup a value in a table that is =<
  125. create user enterie form to add records to the spreadsheet
  126. False - want to leave blank
  127. Searching a comma delimited string in a cell
  128. Change font/color of value returned?
  129. Updating a cell depending on the time
  130. How to calculate %
  131. Excel not recognising data
  132. Average with a criteria?
  133. SQUAD 23 choose the best 11 players
  134. Using XL as a database
  135. 'Portable' workbook and dependent workbooks
  136. Saving MSN Stock Quotes
  137. Web Query : Yahoo finance
  138. reference errors linking to other workbooks
  139. rearrange data into a certain format
  140. cell number increment
  141. cross referencing
  142. Student Grades Distribution Chart
  143. Assistance with IT coursework
  144. Call excel macro to run from Outlook VBA
  145. schedule problem:manhours
  146. Deleting Certain Character
  147. Copying from one worksheet to another
  148. Formula Import data
  149. sorting legal numbering
  150. MATCH Blank?
  151. Inserting Rows with Formulas
  152. Auto Complete
  153. Thai Words (extract from oracle) in Excel
  154. Looking for the Right Function
  155. Paste Word Perfect table into Excel
  156. Word VBA Macro !
  157. compare 2 columns
  158. Dropdown list (Data>Validation)
  159. count by name, the number of xs per name
  160. Copying Charts together with the source table
  161. Sort
  162. How to find and return value
  163. Adding Prices on top of VLOOKUP formula
  164. Coverting Project to Excel and back again
  165. Showing one cell over another
  166. Reducing Linked File Path / Formula
  167. Adding more than one source to a cell
  168. Difference between dates as "x years, y months, z days"
  169. Columns to rows (swapping X & Y axis)
  170. listing all permutations of 4 letters
  171. extracting info.
  172. How to Select cells with a defined name ?
  173. Get external Data / hyperlink
  174. external reference to show formula
  175. Notification that maximum characters reached
  176. Character count in a cell
  177. Is there a way to sort By highlighted cell color?
  178. Excel sheet to Outlook body
  179. performance tracking and report help
  180. performance tracking and report help
  181. Sumproduct
  182. Can I make an IF statement that Highlights if True?
  183. Quotes within concatenation
  184. Cross reference
  185. drawing a graph on excel
  186. Row Reference Using a Random Number
  187. Rounding Sums
  188. Creating pivot tables using a CSV file as input
  189. Very last non blank row
  190. extract Unique Records from multipe columns
  191. Continuing a Sequence
  192. Salary Costs
  193. Automatically Generate Lines
  194. Microsoft Access Table Connection Issues
  195. Formula (or macro?) to show all number combinations
  196. how do I apply connectors?
  197. entering a telephone number
  198. Date and time calculations
  199. excel adds quotation marks
  200. Convert ANSI file to excel csv or xls?
  201. Nested COUNTIF
  202. "if" style question based on certain dates...
  203. trying to make a list
  204. How to know the difference between the 1st and last of a serie
  205. count the number of staff members and the number of clients
  206. pull out certian information from each row/column
  207. Excel to Business Objects and vice versa
  208. Bring the minimum value with it's color?
  209. Animation in excel
  210. Differentiating recurring values in tables
  211. Nested Function Limit 7
  212. Payroll SpreadSheet
  213. Viewing data from a particular state ..
  214. Importing LandXML (or regular XML) into Excel
  215. schedule in excel with text and numbers
  216. Underline same length as the total on the next line
  217. I have forgotten the password
  218. scatter graph
  219. Cell colour format
  220. Semi-Protection Want Hidability AND Protection
  221. Cell formatting number as "00"
  222. Using part of a number in another cell
  223. Inverse cell selection numbers?
  224. Escalation formula
  225. How do i paste in a horizontal manner?
  226. Data Error
  227. Word Wrapping??
  228. First day of each month?
  229. Answer not to exceed a certain number
  230. Save Protected worksheet
  231. Counting in columns
  232. Pivot - Display all values.
  233. Using Vlookup to lookup array, return array
  234. Stop Excel Automatically Converting Dates?
  235. Auto fit won't expand ~
  236. How to sort one sheet using data from another
  237. Match and count between a column, within a list and specific cells
  238. Split screen showing different pages of same workbook
  239. Formula and path problem
  240. Scroll Bar not working when shifting between Excels - Infuriating
  241. annual operating budget? add-ins/template/source for?
  242. MS Query Update
  243. Worksheet Protection
  244. complicated row searching/counting
  245. Calculate median
  246. Shared Workbook
  247. Question about Headers
  248. Size of spreadsheet
  249. Copy Cells to Different Workbook
  250. Different FONT and SIZE in a cell