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. Access cell's content via Concatenate
  2. Saving website Cache in excel spreadsheet
  3. sort by character
  4. Deleting Formula
  5. custom data validation formula
  6. Retrieve External Data via SQL Statement
  7. inserting
  8. jumping cells
  9. Payback Calculation
  10. Email when chagnes are made to a shared Worksheet
  11. V-look up fuction
  12. Then / Else
  13. Compare 2 Columns
  14. cell value in header
  15. Gantt chart using relative dates?
  16. Print to PDF then email
  17. Turn addresses into hyperlink
  18. Encrypt excel file with winzip, but now unable to extract or view
  19. wrap text auto cell adjust
  20. Excel project report
  21. Sorting list of numbers
  22. Clear cell
  23. Paste special: links
  24. Instanciating .xlt with VBA?
  25. Macros
  26. Excel locks up, then saves, then unlocks
  27. Is there a more automatic way to use exponentials?
  28. complicated formula moving/copying
  29. Searching For Duplicates in the Same Column
  30. Format question
  31. task complete macro
  32. Separating alphanumeric data
  33. From Excel to Access
  34. Sorting data then adding one row to the next
  35. User Form button
  36. How do you toggle between tabs?
  37. Updating
  38. Question on saves....
  39. Linking a Text Box to a cell
  40. conditional results
  41. auto fills
  42. How can I Isolate headers? Thank you.
  43. difference between dates in no. of days
  44. Tiny text in Combo Box
  45. Please Help!!!
  46. PLEASE HELP.. If and Statement
  47. Cannot Reset Color Palette
  48. Required Cell Values
  49. way to sum numbers down the list accroding to a value in a cell
  50. Excel Mail Merge
  51. formula to use on a timesheet
  52. auto-tab in data entry possible?
  53. unlock a password locked workbook!!!
  54. Selecting only Active cells within a macro
  55. vlookup searching
  56. Anchor Reference in a Formula
  57. Forcing quotation marks around strings
  58. Formulas don't work anymore (SP2)
  59. Dynamic column length in macro
  60. Data Validation and using colour
  61. Date - Time Format, How to Extract Month
  62. Reading from the same worksheet?
  63. Unable to Open book
  64. Pivot table autofill
  65. Ascending sort of surname is both firstname & surname are in same cell
  66. Excel for Apple Mac Keyboard Shortcut
  67. Linked formula
  68. Conversion from xls to textfile
  69. Selecting Graphs with Drop down lists
  70. Conditional Formatting
  71. 'Send To' function not available in File Menu
  72. ranking using more than one field
  73. way to hide the column, row and data field in a pivot table
  74. OLE Error
  75. Simple excel question
  76. Drop down menu question
  77. bizzare bug when saving
  78. Drop Down menu & multiple linked cells
  79. Calendar ??
  80. Allow drop-down list not an option? Help
  81. formula to pick out text between semi colons
  82. Help with formula
  83. Sumproduct assistance
  84. Splitting workbooks
  85. 'Zoom Across' Macro
  86. rolling averages
  87. Autofill column custom list
  88. convert QIF file into Excel file
  89. Total Page
  90. Lookup function
  91. Copy a number from the internet into a spreadsheet
  92. How to make a cell invisiable without deleting the formula.
  93. How to convert this text into excel spreadsheet format
  94. count formula
  95. Problem opening Excel files
  96. Vllookup(Text
  97. How to add comma to each entry
  98. Linking Spreadsheets
  99. I delete all Macros from file, Excel still gives me a Macro warning when opening...
  100. Subtotal on Absolute Values
  101. Formulas in comments?
  102. Format question
  103. Averaging a column of calculated fields in pivot table
  104. Odd pricing
  105. Not using VBA, sum cells based if value exists
  106. How to select a list item by using a macro
  107. Turn off Excel's automatically copying number formatting of target cell
  108. using drop down lists to show data
  109. Filtering a list to only select the first record of each section
  110. Lost selection calculus
  111. C# as excel's macro language
  112. Pivot talbe how to sort data in increasing order
  113. Exponential Regression
  114. Pivot talbe, how to make it to auto update
  115. Auto Refresh Pivot Tables
  116. Populating one spreadsheet from data in other spreadsheets in same workbook
  117. validate date value
  118. Filling a large cell with text
  119. Chart
  120. showing resulting data on a another sheet
  121. Pivot Table Query
  122. links to other spreadsheets
  123. Excel in Access 2003
  124. Control character for line feed?
  125. Printing Long Narrow Excel Worksheets
  126. convert number into a date
  127. Mod, Int, row, and indirect
  128. Two cells have the same content, but why they are not same?
  129. Excel automatically divides by 100??
  130. comparing values and returning different column
  131. Dates pre 1900
  132. Assigning point values to rank
  133. Compare two lists of data
  134. Issue with dragging formulas to other cells
  135. Excel acting weird
  136. Problem sorting Date
  137. Unioning values from 5 different externa database query results
  138. Using hyperlinks in Excel...
  139. Count Months Between Dates
  140. pROTECT OR lOCK CELLS SO THAT THEY CANNOT BE EDITED
  141. Search Values
  142. Popup Box\Window
  143. CELL(info_type,reference) function
  144. Equation in Chart
  145. Pivot Table limiting data
  146. Some cumulative assistance...
  147. Muliplication + addition
  148. Pivottable Problem
  149. Windows Vista and Excel
  150. How to use X and Y data on bar graph?
  151. Can I bookmark a thread?
  152. Trending based on past data
  153. Extract unique names (names could be little different)
  154. Copy worksheet to an existing workbook not working
  155. VLOOKUP - Strange results
  156. formatting percentages
  157. Using Excel To Fill In The Blanks
  158. attachments
  159. counting based on conditional format
  160. NonWorking Conditional Formatting
  161. Hash Marks
  162. Numbered Columns?
  163. Excel saves as [Group]
  164. Excel file merged to WP Data file goes corrupt
  165. Conditional Formating
  166. splitting a number
  167. Form always on top
  168. Encrypt
  169. Pasting Excel Graph into Powerpoint
  170. Stop Excel from dropping the lead zero
  171. Drop Down menu & linked cells
  172. User Form malfunction
  173. simple balance sheet
  174. User Form - Audit
  175. Saving as tab delimited file
  176. importing data dependent of validation list
  177. Lotus note Vs Excel ?
  178. How do I return a blank IF.....
  179. adding numeric portion of alphanumeric cell
  180. Index & Match
  181. Extracing results to database
  182. Sum + Index
  183. Importing text file to excel database
  184. Putting a list of data into columns.
  185. Solver
  186. How to transfer Excel settings to new PC?
  187. ISERROR question
  188. Automatic sort all dare are mixed up how to prevent this.
  189. Fastest Loop Code?
  190. Shared Workbook (Workbook Open Code)
  191. Converting Numbers to Time
  192. How to insert a specific cell range in this vba script selection?
  193. How to change reference directory on hyperlink.
  194. Can't convert exe file to xls...!!
  195. Command Button
  196. Calculation (CTRL+ALT+F9) Not Working
  197. Need Help
  198. need help with my database please!
  199. corrupt file ÿÿÿÿÿ.....
  200. Pictures
  201. sum formula
  202. comparing 2 reports
  203. Excel sheet page breaks are different when loaded in other computers
  204. Solving Problem
  205. Trouble Formatting Dates
  206. Straight Line Depreciation Calculation
  207. Working backwards with functions
  208. count number of time a text string appears
  209. Sum Every 3 rows
  210. VLOOKUP problem
  211. spreadsheet is hidden....
  212. Dynamic PHP name and value pairs URL creation
  213. Opening html files in Excel
  214. Adding #of days to a date
  215. How to count cells with particular color fill?
  216. auto filter
  217. Dropdown List - Change Display
  218. percentages between cell
  219. Floating Balance Possibility?
  220. Countdown timer
  221. checking cell contents and displaying a message
  222. SQL query to Excel Cell
  223. export Excel vector image
  224. payback period formula
  225. Auto Adding a Numeric Value Based on a Drop-Down List Choice
  226. Embed Cell Text in the middle of a URL address
  227. Limit to number of named ranges?
  228. Pivot Table Help
  229. RANK - Non unique values, contiguous rank required
  230. Routine in VB programming
  231. Linking Sheet with other sheets
  232. Pivottables - Calculating proportions of categories
  233. Group by clause in XL
  234. Adjustable scales
  235. DATEDIF anomaly?
  236. Remove timestamp
  237. Get Sql Statment for Imported data
  238. Scrolling text
  239. Search a Row to Get Column Letter
  240. solver
  241. Find the last occurrence of a character in a string
  242. create a link
  243. Hide function/command
  244. Regression Coefficients Estimated Incorrectly When Centered Predictors Used
  245. Lookup a word from an array
  246. how to set default font for footers
  247. Image From Formula
  248. Spreasheet is vulnerable to operator error
  249. Compare
  250. Run Macro