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. Copying Columns causes File Size to Explode
  2. Pivot table cope with inserted columns
  3. "Windows in Taskbar" feature does not work
  4. Auto Filter issue
  5. Creating Time Formula
  6. identify and print the ones on the list
  7. Library Data
  8. Copying a whole worksheet that updates
  9. Min/Max Using Criteria from another Column
  10. Style? Format? Dealing with currency
  11. count running total
  12. Search, retrieve & input
  13. Need Help Creating a Conditional Formula
  14. Listing values while ignoring blanks
  15. Recognising the first non-zero value over 13 columns
  16. Combine column- two lists, with unique identifier
  17. Can a Macro be run from inside an IF statement?
  18. Graphic Attached to Cursor
  19. Linking a flow chart box to a text box on another sheet
  20. Merging Columns into One Column
  21. flowchart question
  22. hyperlink/picture editing
  23. Activate Add-Ins for All Users
  24. A basic question about formulas
  25. formula help
  26. formula with 3 conditions ?
  27. Selecting multiple cells
  28. Changing time hh:mm:ss field
  29. Help needed on excel. Is it possible?
  30. Formula with Power function
  31. Combining Text From Multiple Cells
  32. excel conversion/reference table
  33. Help with stock list
  34. auto-adding specific suffix to user value?
  35. Return the earliest day of a month
  36. 5 Digit Combination/Permutation??
  37. dynamic Form List Boxes
  38. hierarchy filters in pivot table
  39. Restaurent list
  40. Resolved - to link formula between sheet
  41. Excel startup problem?
  42. Opening hyperlinks
  43. taking the Zero out before a number
  44. A Little Help About Filter ?
  45. How to change Data order
  46. Linking/embedding word doc
  47. Time Formating
  48. Totals across multiple worksheets
  49. duplicate cells with different values
  50. Updating Links within a single Workbook
  51. New here, need some help with PivotTable/PivotCharts
  52. Combining 2 excel files
  53. dynamic Form List Boxes
  54. Continue Searching a table with Vlookup despite finding one match
  55. Protecting data for certain users only?
  56. randbetween() problems
  57. Conditional Formating
  58. Calendar Functionality
  59. Help me please
  60. Randomly add List Elements to Chart
  61. Resort a Pivot Table Filter
  62. Labor cost formulas
  63. Update values in Linked workbooks
  64. Copyright Question
  65. Exchange Rate Linkage
  66. Opening 2 Spreadsheets
  67. Multiple lines in single cell
  68. copying/pasting cells not working
  69. Duplicates in column A/qty's in multiple rows
  70. Inserting a block of cells using an if statement
  71. IF a certain value then countif?
  72. countif formula
  73. Subtotal unique values in autofiltered field
  74. Form with corresponding Days to Month drop-down list
  75. Very urgent "Validation" issue
  76. Fill Down Series Question
  77. Cannot insert Columns
  78. (blank) in pivot table
  79. Sort; Filter; Match or WHAT???
  80. Information visible from one cell to another
  81. copying and pasting a range of dates won't work
  82. Adding comments to protected worksheet
  83. Copying fomula (from another spreadsheet) down
  84. Open excel files in new windows
  85. Excel to the Web
  86. Reduce Cell Formats
  87. Replacing #N/A with a blank cell
  88. Pivot tables always require refreshing!!!
  89. Workbook saving repeated duplicate copies.
  90. Connecting a name with a number
  91. Formating combo-box (from forms toolbar)
  92. Avoiding #VALUE errors on blank cells
  93. problem with viewing linked text data
  94. Drop down validation for 2 columns
  95. XAR file type
  96. Problem With Dates
  97. Losing Worksheet Protection
  98. Display External Links
  99. Excel AutoFilter
  100. Weeks in a month formula
  101. Sorting Changes Cell References
  102. How to recognize decimal number ?
  103. Option Button Grouping
  104. Sorting Hyperlinks
  105. Hyperlink to cell
  106. Cell Background color change
  107. Even the simplest of macro's
  108. Conerting Inches to centimeters
  109. Marking Time/Date Conflicts
  110. Extract and summarize from 100 worksheets into one
  111. VLook Up Help
  112. calculate average from another sheet
  113. Conditional Formatting problem with change from Excel 2000 to 2003
  114. conditional form box
  115. How to create file in Excel with data in rows
  116. Pivot Table fromatting help
  117. Excel Reports
  118. Logo Hyperlink wont delete
  119. Recovery Corrupt xls with password
  120. If Statements
  121. Data Validation
  122. Merge into Publisher
  123. Blocked Email Link
  124. Copying a few lines and inserting without overwriting existing ones
  125. Breaking up and listing product information, is it possible?
  126. Timeline
  127. to get data from website using excel
  128. Workdays Sun-Thu
  129. Search function
  130. Division by Zero
  131. columns into rows
  132. FIND to open atomatically for work book only
  133. Difficult Excel exercise
  134. Count numbers of times within hours
  135. Nested Vlookup Function
  136. Switch /e not working
  137. Saving two non-consecutive columns
  138. Copying and exporting two non-consecutive columns
  139. Marking changed value cells
  140. function or Macro to show names who have purchased over the phone
  141. Conditional Scientific Form
  142. Excel->Data->Validation Foruma Query
  143. Can excel pick up the number change on a webpage?
  144. formula that would pick out the number values within a cell
  145. Rolling Time Periods
  146. "Count IF" statement
  147. Too many fonts
  148. Find next day (number) of week
  149. numbering colums in excel as a data base
  150. Select Multiple Criteria via Data Validation
  151. "cannot access" error when opening excel doc over network
  152. Exporting to CSV
  153. Listing info by using template...
  154. search for text within text
  155. fill question
  156. Counting hours worked in a range.
  157. Convert single colum/multiple rows to multiple colums.
  158. Rows/Column Headings
  159. Custom Display in Pivot
  160. How To combine 2 columns in Pivot
  161. make a string to a hyperlink?
  162. Adding costs in a specific year
  163. Purchase Orders
  164. Add Up a value if criteria in 2 cells are met
  165. How complex that Excel's if() and logical expression can be?
  166. Associate Data Entry with Other Data
  167. Work out waiting times.
  168. Automatic status on next colum
  169. Issue with CSV file.
  170. inventory tracking
  171. Comparing Data on two spreadsheets?
  172. Analyze "breakdown" a sum of money
  173. problem with inaccurate result with AVERAGE
  174. Help with creating function...
  175. Conditional IF Statement for #N/A error
  176. Workbook formatting
  177. Timesheet query
  178. Excel Drop Down Menu Work
  179. formula lookup
  180. Text to Date change
  181. linking previously calculated data - #value! error
  182. Footers on multiple pages
  183. Turn off outline or grouping
  184. converting number to text
  185. Results in cell dependant on another cell
  186. Using MEDIAN with AUTOFILTER?
  187. Consolidation of all the worksheets???
  188. Multiplying by a string that can vary in length.
  189. Variation to pulldown lists and populating data
  190. pulldown lists - how to populate data
  191. Sorting Hortizontally?
  192. Searching within VLookup Results
  193. include account code in pivot table
  194. Pivot Table Character/Text length
  195. Linking two excel files
  196. Using sumproduct to find average
  197. fixing a mistake on excel sheet- #REF!
  198. 0 Appears for Linking Blank Cells
  199. Repeat Key Field - Fill in the Blanks
  200. from list show datas not in selected range
  201. Change macro name assigned to a button
  202. Sorting Tabs
  203. How do I eliminate an Excel warning message?
  204. Comparing Lists
  205. If/Then using multiple worksheets
  206. Finding/Replacing Currency Values in Excel
  207. Transpose Row in one sheet to column in another
  208. How do you link in excel to an embedded word document in same excel work book?
  209. Drop Down Menus
  210. using indirect with vlookup
  211. Fill Data
  212. Sort cells by first 4 alphabets and Sum
  213. Pivot field formatting
  214. Data import from one Excel to another does not honor column headers
  215. prepend a zero to all cell contents in a column
  216. how to get rid of the autofill box that pops up
  217. Cannot select Scroll Bar object when sheet is protected
  218. Excel 2003 SP3 - Inserting Rows at every other rows
  219. Excel 2003 SP3 - Replace LineFeed character
  220. SUMIF External Refs being sestryed in Excel 07
  221. Searching, Finding And Extract Data Based On Set Parameters
  222. Aligning Check Boxes
  223. message question
  224. Static Cell References in Formula Despite Sorting and Cut/Pasting Range
  225. insert picture
  226. Unique Largest Number
  227. Shared files and conditional formatting
  228. Conditional Formatting
  229. Referencing a Date from a heading
  230. Date in conditional formatting
  231. alt+tab not working in Excel (works otherwise)
  232. Automate a filter in a macro
  233. Need to insert blank rows
  234. Automatically filling in Cells on the basis of a Dropdown List
  235. biexponential fit of data
  236. setting font bold when values are the same
  237. search for something automatically
  238. Default Cell
  239. Conditional Sum
  240. Counting Unique Occurences in excel?
  241. Last Cell Reference
  242. Spread Sheet Formulas and Drop Down
  243. Jumping forwards and backwards with Hyperlinks ?
  244. "remove Hyperlink" missing from Mouse Rt Click Button
  245. Joining Text at a specified point!
  246. MS Excel - multiple worksheets, same data question?
  247. Date Format question
  248. Database Query to update the spreadsheet
  249. Vlookup without error message #N/A
  250. IF= formula date issue