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. exclding all except in vlookup
  2. Finding matching text/numbers on 2 sheets
  3. Merging Spreadsheets caused total loss of original data
  4. Data Filters
  5. #value
  6. Checkbox - Date
  7. Creating a basic workshop schedule
  8. Make Rows into columns
  9. Copy the comments
  10. Workbook/tab linking
  11. Using IF and wildcard to work out 2 different calculations
  12. Pivot Table formatting of month
  13. How can I spawn new identical worksheets in a workbook?
  14. saving CSV file (with delimitator)
  15. Hideing and unhiding a sheet based on user selection
  16. Box that keeps popping up
  17. If and thens??
  18. If zero, pull nothing, if there is a number there pull the row #?
  19. Pulling detail to second sheet w/o Zeros?
  20. Headers based an cell reference
  21. Ifcontains
  22. Split one tab into three
  23. replacing a comma with a return (or alt-return)
  24. Original Source of Pivot Table Data
  25. Lookup query
  26. Excel Lists - auto find....
  27. Excel file - 19Mb!!!
  28. Numbers that are not treated as numbers
  29. how do i rework the sequence of data
  30. Hyperllink Formula - Invalid Reference
  31. File Permission
  32. Date Formula
  33. Calculate age for last day of each month??
  34. Pivot Tables & Shared Workbook
  35. Some cells not printing
  36. incrementing number, saving to worksheet then trying to get a new blank
  37. Selected Cell Counter
  38. What is "--" used for?
  39. seperate duplicated entries into multiple worksheets/files
  40. Saving worksheet as TAB delim.
  41. mailing labels with table data
  42. How to predict/forecast sales ?
  43. Printing from IE7 to Exel instead of printer
  44. VLOOKUP problem with N/A#
  45. Excel Memory usuage
  46. reprot.csv file from sql plus report not formatted
  47. Finding last value in array?
  48. Creating A Running Inventory
  49. Calculate WOH (Work on hand)
  50. Adding a username to an excel spreadsheet
  51. Date and format problem!
  52. Web Query Doesn't Support Basic Authentication
  53. regional settings
  54. Creating custome toolbar in excel
  55. Sales Tax
  56. Opening Excel files from Windows Explorer
  57. repeating formulas
  58. timesheet
  59. Excel 2007 ODBC Glitches
  60. macro needs assigned whenever i use another computer
  61. Common Entries From Two Different Columns
  62. Sales Tax Issue
  63. changing between sets of data
  64. interpolate a good curve fitting value from a set of data
  65. Multiple choice displaying the results of 2 cells into 2 different cells
  66. Can't Active Hyperlinks with Enter Key in Excel 2003
  67. any type of "contains" formula?
  68. Mailing List organizing by STATE
  69. Tough problem I am having
  70. link columns in different worksheets but removing blank cells
  71. Sum, Sumif, Sum(if) functions
  72. Wrapping of a range of data on one worksheet...
  73. Export Word to Excel
  74. Print preview changes on different computers
  75. lock custom toolbars
  76. Protected Sheet (Group/Ungroup)
  77. Linking multiple worksheets
  78. Macro to recognize data
  79. named ranges of columns showing in formulas
  80. Dependent Averages
  81. Suppressing Auto Macros
  82. Opening Excel in Internet Explorer
  83. Copy with filters with a certain range to paste in another with a different range
  84. Pulling duplicate names of 2 spreadsheets and putting them into one
  85. Find, copare between 2 sheets and enter data from another cell
  86. link update error
  87. Displaying only positive numbers
  88. Printing 10 lines at a time
  89. Merging worksheets
  90. Help required with number formatting 'on-the-fly'
  91. Calculacting turn around time
  92. formula problem
  93. Generate number of days between two dates
  94. Having issues sorting a column with dates and text
  95. IF formula
  96. Adding numbers to output dates
  97. Highlight duplicate entries from 2 columns
  98. Modifying cell referals
  99. Something better than vlookup or hlookup
  100. Date format
  101. Check if excel file is open
  102. Calculating the Discount from Price when you know the GP%
  103. Formula with a range of GM%
  104. calculating content specific cells
  105. Count Problem
  106. Changing entry and formats on referenced cells.
  107. adding a button - help!
  108. Figuring out Availability based upon work/task schedule
  109. Hyperlink - linking a cell within a worksheet to another cell within same worksheet
  110. Label(from control toolbox) backcolor is always set to black ruining all labels
  111. Mr. "Iamthe Best" needs your help !!! How to delete a set of rows
  112. how do I move text in a cell to a text box in Power Point
  113. Timesheet without break times
  114. Pivot Table Query
  115. text data in pivot tables
  116. Spreadsheet Command Errors
  117. Calculating a List
  118. Applying the same formula to multiple cells
  119. Search for numbers in a cell that also contains text
  120. formula question
  121. periodic XIRR calc incorporating current value
  122. Timestamp help (gets error when sheet is protected)
  123. Enter/Tab not working in unlocked Cells
  124. referencing issue
  125. Query is truncating data
  126. change name format
  127. Autofill
  128. If quantity is input then info moves into other worksheet
  129. SUM box question
  130. Call Web Services from Excel 2007
  131. Validation Input Message affix to cell?
  132. Averaging loads of data
  133. Split cell content based on a column break fixed width
  134. Problem with series counting empty cells
  135. vlookup on a dynamic # of rows
  136. Tab Separation
  137. Excel automatically turning cells to text when modifying formulas! Why?
  138. Count words
  139. Fields show in one column problem
  140. Question about conditioned list
  141. filtering out dups in address col. keeping the other data to the left and right of it
  142. IF Formula Question
  143. Need some guidance
  144. Apples, Bananas, Oranges -- Can Excel Spit Out the Highest?
  145. Error Trap
  146. Averages Formula
  147. Converting time to a date and time
  148. Help with managing data. Complicated one!
  149. pivot table
  150. Getting totals from 19 different spreadsheets?
  151. Excel is extremely slow now
  152. converting string of this type :#####D-## to a regular number
  153. Inserting picture filenames in an excel list
  154. shortcut for bottom of list
  155. Conditional Formatting Formula To Highlight Flagged Entry
  156. I Don't Want = to be recognized as a formula
  157. Annoying conversion message 2007
  158. Converting Excel?
  159. Formula Based on Color
  160. EXT engaging when using an external 10-key device
  161. Change the color of cells based on values
  162. How do you select a moving target as in changes in a pivot table?
  163. How to display negative dollar amounts
  164. text format retention on a Vlookup
  165. Pivot table reformatting into word
  166. balance sheet
  167. User input message box lookup table
  168. Excel or Profile Problem?
  169. How would you use text in a cell to form a link to a tab?
  170. Adding Column Data using =SUMIF function
  171. Barely noticeable background shading on alternate rows for improved readability
  172. How would I go about?
  173. Reference List from another sheet
  174. Change font colour in drop down box
  175. Hiding negative time #####
  176. Drop Down
  177. Data Filters Query.
  178. Manual entry with 24hr drop-down menu
  179. Column Width
  180. Duplicate If Range Entries
  181. Using Index/Match with IF
  182. Bring PDF Files Into Excel
  183. Forward and Reverse Merge
  184. Tick box or dropdown to insert text?
  185. Error Message #NAME?
  186. Cell referneces & Sums
  187. Autocomplete only working on some of the words in the column?
  188. Using Macro Button With a Template
  189. Identify, not eliminate, duplicate records
  190. Cube Analysis - MySQL Connection
  191. Excel Highlighting Problem-(grouping and highlights of all cells)
  192. Scrolling Oddity
  193. fuel calculator spreadsheet
  194. VBA - Worksheet_Change, Run macro, MsgBox Output
  195. Vlookup Questions
  196. Spreadsheet Printing
  197. Generating alternate display of table data
  198. Post Dating Color
  199. Template for Printing Excel to Index Cards
  200. For/Next loop when comparing cells within different worksheets
  201. Excel converting to put on to the Web - How do you do it?
  202. Formula - Two ("text") column array formula
  203. Conditional Format a cell based on a range of numbers
  204. Concatenate-Vlookup returning #NA
  205. Cell Selection Changes
  206. Return multiple values with multiple conditions
  207. PDF to Excel?
  208. changing text color based on date
  209. copying only cells with value into new sheet
  210. how to creat a page by page numbering sequence
  211. Column/cells to single cell comma separated data?
  212. Entering data in one cell, and getting it's location in another.
  213. Excel Watermark/Wallpaper
  214. Count the number of "#num!"
  215. Entering text but not being able to delete it
  216. count entries based on colour
  217. Why does Excel 2003 open an additional blank workbook?
  218. filter by rows, instead of columns?
  219. Changing the source data in a pivot table... how?
  220. Round to previous quarter end
  221. adding items and totalling their results
  222. merge data into a calendar
  223. how to have a sliding formula
  224. from horizontal to vertical
  225. referencing across workbooks, auto-update
  226. copying a table from a website
  227. Adding a formula to a cell will a formula
  228. Problem saving file
  229. Assign value to another cell?
  230. hyperlinks in data validation
  231. Buttons and Rows
  232. Accessibility and cell colors
  233. Excel Hyperlink gives error cannot find internet server or proxy server
  234. Decimal Points for Existing Data
  235. Searching/Replacing the Number 0
  236. Calculate a range?
  237. lat/long to decimal function
  238. Compressing Excel File
  239. Turn off autosave in excel
  240. Excel won't display correct numerical data entered
  241. can't work out an If statement
  242. sorting
  243. Excel Page Cut Off
  244. How to detect a formula in a cell
  245. How to save Macros
  246. Variable results from the one cell
  247. Decision Making in Excel
  248. Delete rows on conditional basis
  249. how to put £ sign
  250. subtotal, sum if