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. Identify frequency on time
  2. Multiple Currencies in Spreadsheet or Workbook
  3. iSeries Access for Windows
  4. Extracting http:// address from text hyperlinks
  5. Resolved >>> Iserror & Search
  6. Applying auto filters multiple times on one sheet ...
  7. Please welcome our new Moderators (info only)
  8. Avoiding exponential formating
  9. Increase/Decrease in 2 Numbers
  10. Formula that mimics Ctrl+F
  11. "Business Hours" Time Calculation
  12. Resolved >>> Finding Lowest Cost/Vendor
  13. Resolved >>> Div# to show blank
  14. Read/Write Values
  15. # tag not working from I.E loading Excel sheet
  16. <Resolved> Select range
  17. Filling in Information for y values
  18. Resolved >>> Counting cells that are different
  19. Error - copy method of range class failed
  20. IF formula
  21. Resolved >>> Switching between multiple spreadsheets
  22. Track changes
  23. Resolved >>> Reverse Lookup (Index & Match)
  24. Listing Missing Data (sort of)
  25. Resolved >> Macro to edit multiple rows of text
  26. Resolved >>> Conditional format with 2 criteria
  27. Resolved >>> Protect Sheet Dialog Box Default
  28. excel shortcut (increase/decrease decimals)
  29. Excel Lock-up Issue
  30. Create a list for each cell in a row/Column
  31. conditional formatting question
  32. cell referencing
  33. Can not view tables in Dreamweaver
  34. Keeping fixed cell reference in table
  35. Cell Format - Format this 1149704001 as 11497 04 001
  36. Retain links when moving a web query sheet to a another book
  37. extracting multiple values
  38. Increment a selection
  39. Difference of time
  40. vlookup formula
  41. if formula?
  42. Text wrap and allow cell height to increase with wrap
  43. Data manipulation from one worksheet to another
  44. IF function
  45. Is a Double Vlookup possible?
  46. if statement based on time of day
  47. if statement
  48. Conditional Lookup Formulas- Assistance
  49. Conditional formatting
  50. listing the same cell from different sheets on one sheet
  51. Editable locked cells
  52. Automatically updating stocks
  53. picture as excel spreadsheet background
  54. Excel Preview Zoom
  55. IF Function
  56. EzPaste-xl2ppt, a powerful Excel add-in
  57. Counting the number of differing values across a group of cells
  58. Pivot tables - Calculation on data items
  59. Linking spreadsheets
  60. linking excel pivot tables to access 2000
  61. Solver problem
  62. keep an individual running total on a large number of different items
  63. PivotTable Formatting
  64. "Selection is too large" when opening a file
  65. Create report from another worksheet
  66. Locked worksheet
  67. adding variable arrays
  68. Where is the Confirm Open After Download Registry Setting
  69. Lookup with comparing values ?
  70. Reducing a mass Dump of Data
  71. calculation question
  72. Auto update a cell
  73. Paste Special Doesnt work
  74. Pivot and changing the source value
  75. data showing as #N/A when using vlookup
  76. code generation problem
  77. Make a range or list unvisible?
  78. Changing Cell References after copying sheets
  79. Pick from List
  80. Find failure in large cells
  81. Empty space
  82. Custom formatting question
  83. Large file size when adding pictures.
  84. Flip the spreadsheet
  85. Counting Cells in a Column
  86. Read Line or Arrow ( shapes ) from excel
  87. problems with using name of area and name of spreadsheet in formula
  88. Strange Behavior when I link to a File
  89. Lookup and Write between sheets (Regrade Exam Try 2)
  90. Linking a word template to excel- opening as a new document
  91. If statment
  92. Merge data in multiple documents
  93. Auto-fill
  94. Importing PDF
  95. Data LiNK
  96. Shared doc not able to save
  97. Working Out Multiple Percentages in One Cell
  98. conditional formatting all cells
  99. Conditional Format Duplicates
  100. SumIF function
  101. Dates in Excel97
  102. Find the total amount of characters USED
  103. Zeros in cells
  104. How to remove or replace ***** from a cell
  105. how to read arrow in excel
  106. Column to row in formula
  107. Rounding
  108. Links between Excel/Word. Computer memory problem
  109. Excel 2003 Linking to drop down List
  110. Look-up Then SUM Range
  111. Conditional Formatting
  112. filenames in formulas
  113. Using information from Excel to fill multiple fields in Word
  114. Avoiding Circular Referencing...
  115. export excel to xml
  116. Sorting Salesperson Info
  117. counting characters within a cell
  118. Text and Date in same cell
  119. Automated filename capture
  120. Font question
  121. Exporting from Excel to CSV
  122. subtracting numbers
  123. Copy specific table from word to Excel
  124. Looking to Automate Multiple Replacement Operations in Excel
  125. Circular References
  126. Cut and Paste Hidden Rows
  127. Seperate 2 sets of No's in a column into two columns
  128. Formula to count down to a specific date
  129. How to clean the clipboard short key?
  130. Strange Character
  131. Problem sizing and formatting cells with xl 2003
  132. Creating a backup of Excel Workbooks
  133. Excel 2007 - Formatting Oddity
  134. sum product and #n/a error
  135. IF formula that also multiplies
  136. Excel auto format changing 1-1 into date
  137. Page Break problem
  138. sum up of several percentage numbers in pivot
  139. Font question
  140. Numeric base conversion
  141. mouse shortcuts
  142. How to paste entire worksheet without links?
  143. Tab Key
  144. Display missing names
  145. automatically set to manuel calculation by closing a file
  146. Large information on clipboard message
  147. Changing Default Mail Client
  148. Combining two spreadsheets to check for changes from month to month
  149. Look up
  150. Lookup
  151. Copying Formats & Validations - fails
  152. Find and Replace
  153. Creating a tree
  154. an alert on my file
  155. Off-topic: Word help forum???
  156. UK Tax spreadsheet
  157. Can a cell have a vertical scroll bar?
  158. Web Query does not update after it has been moved
  159. Windows Excel Search
  160. Largest value to be displayed
  161. Automatic search of values and display
  162. Presence/absence chart
  163. Getting the text from a random cell / row
  164. calculating total payment - Time duration x Hourly Rate
  165. Preparing data to insert into SQL table
  166. Printing Consecuitve Numbers In a Cell
  167. Count Unique with IF
  168. Converting from one table to another
  169. Improve formula - Find a way around Nestled IF statement
  170. Entering Formula without Equal Sign?
  171. Protecting and Sharing a Workbook
  172. lock puzzle numbers
  173. How to increase comment spacing?
  174. Re Excel cell Storage capacity
  175. Text to Columns with EACH character in sepearte column?
  176. No prompt to save
  177. Search column for Dates and Colour Fill
  178. Protect a cell.
  179. Book1 has Macros (Macro 4.0)
  180. Saving to CD
  181. Convert to Simplify Chinese
  182. Opening Txt Files in Excel
  183. Laptop recommendation to run Excel
  184. E-Mail attachments won't save
  185. Dynamic calculations for cost when filtering
  186. Linking other spreadsheets in excel
  187. Array Formulas and Named Ranges
  188. Truncation of fields in a column
  189. Cell Selection Problem
  190. How to ercover the Deleted sheet of an Excel file
  191. How to search a tab name.
  192. 15% discount formula
  193. Vlookup returning #N/A
  194. Project Management Spend Plans
  195. Delete a formula and keep value
  196. Calculating Amounts by Month
  197. If Statement and email
  198. Condtions to prevent a formula being deleted
  199. Name a module
  200. Find medians for thousands of datasets
  201. Swapping cells (maintain formulas) in seperate files
  202. can't unhide category row in pivottable on mac Excel
  203. Referencing Formula
  204. find max and min values and show them in different color
  205. figuring difference in months
  206. Problem editing cell content
  207. how to remove the grey text "Page 1, Page 2" from the background
  208. Gettin Excel to detect blank cells.
  209. Excel cannot access files on a network.
  210. Circular Reference Help File
  211. "IF" statement
  212. display value based on current month
  213. Lookups Tables
  214. Creating a formula
  215. Return Data Depending on value of two other columns in Row
  216. Conditional Formatting Formula
  217. Error message
  218. If query & Look up
  219. Copy to CD
  220. Flexitime / Work time calculator
  221. Using Excel to Add up milestone payments
  222. indent check to generate id's
  223. I don't want it to display # when there is no result
  224. Hiding Columns Error
  225. Problem regarding query "where" field when importing
  226. graph question
  227. Totals from different cells
  228. Reset defaul pivot table names
  229. Designating a cell in a formula by using a formula
  230. Weekend dates calculation
  231. blocking cells and controls
  232. Moving Excel spreadsheets to different computer.
  233. Mark up formula
  234. Refresh Pivot Table Data – Not Working Correctly
  235. Networkdays
  236. Copying & Pasting Problem
  237. Converting Intra-day quotes to End-of-day quotes
  238. Checkbox summary
  239. Formula for subtracting earlier time from later time in the 24 hour clock
  240. Excel help has disappeared
  241. How to generate a blank from no data with IF
  242. Custom Dropdown Macro
  243. Populate schedule using if statement?
  244. Variable Chart Title
  245. Indirect - Building Addresses
  246. Advanced Sorting
  247. Display "Red" if some cells are empty
  248. IF function - lengthy formulas
  249. Calculating IP Addresses in Excel
  250. 2 questions! Related to combobox and time function.