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. apostroph
  2. Hiding a formula within a cell.
  3. VB Code
  4. Excel Graph Issue
  5. Scoring - maybe an array is needed?
  6. Autofilter Oddness
  7. Custom format & Alignment
  8. Sales - expenses formula
  9. Copying Problem
  10. Sort column w/ Right Click
  11. using the now formula
  12. Showing & Hiding Rows
  13. Naming a worksheet
  14. Count Unique Values in a Database
  15. Formula for Automatic Day Calculation against any date
  16. Time log - how to not include nonbillable hours?
  17. (Easy-to-solve?) Printing Mytery
  18. splitting content of cells
  19. Adding data to existing lines.
  20. mail merging
  21. Simple Calculations
  22. Sorting
  23. Reconcile data between two sheets
  24. Program/ Milestone Plans in Excel
  25. simple filter request
  26. Copy hyperlinks
  27. Drop Down Query
  28. Help with linking and filling formula
  29. Embed a file in a Cell
  30. Copying and editing cells
  31. Combine 2 tables together
  32. Error with HYPERLINK & Can I de-dupe?
  33. What is wrong with my Formula?
  34. Help with a simple formula please
  35. Replacing VLOOKUP with DGET
  36. Comparing rows of data - A bit trickier than normal!!
  37. Imported Picture Pastes randomly.
  38. Converting formulas into numbers
  39. Combining separate Date and Time Fields
  40. Multiple Hyperlink
  41. IF Function Help
  42. Counting/Adding
  43. How to snip info from cell?
  44. Calculating local time from GMT
  45. Linking two workbooks
  46. Vba Project Protections Can Not Save
  47. Pricing Sheet - If xx quantity, use this price
  48. Comment from a cell content
  49. Simple Sumif question.
  50. How To Prevent The Disaster?
  51. Macro find
  52. Pivot Table Labels
  53. Formula delete warning
  54. multiple hyperlinks
  55. Column Matching and Colouring (VLookUp variation?)
  56. Convert to integer?
  57. Macro - Autofilter Change. [minor problem]
  58. surveys on use of Excel
  59. Clickable links & How to de-dupe?
  60. export in CSV with ; as cell separator
  61. Using multiple instances of solver
  62. use double quotes in formula
  63. protecting worksheets/workbooks
  64. how to strip alpha values from a cell
  65. express time as a fraction
  66. Vlookup errors
  67. Add one part of a formula to another
  68. Lookup to return an array
  69. Confused on lookup formulas. Any Help?
  70. SUM array with multiple columns
  71. If formula with a vlookup.
  72. Excel opens random files @ startup
  73. Pivot tables: need to use 'running total' and '% of row' simulaneously
  74. Is this possible in Excel?
  75. Lookup based on several criteria
  76. error, 336
  77. ASCII Code Question
  78. Excel: combo box input range
  79. Significance of Correlation
  80. No relative reference icon
  81. Comment does not display when Validation is..
  82. Reverse Lookup help
  83. current time
  84. Rows to repeat at top?
  85. Calling every other cell
  86. Squared symbol (small two)
  87. Data Validation
  88. Formulas and Filters
  89. Formatting & Blank Row removal
  90. Drawing in ExCel
  91. Increase/decrease indent button
  92. Screen Resolution Question
  93. Locating cells with same information
  94. counting # of weekdays in a rang of dates
  95. Limit to Comments Excel will Accept
  96. Formatting conundrum
  97. blank when cell of origin is blank
  98. Indicate dupes in adjacent column
  99. Newbie needs help....
  100. Help with Min function
  101. HELP ME!!!!!! Excel month summing Question
  102. Sumproduct??
  103. Alt+Enter
  104. Hyperlink to formula origin
  105. making a workbook
  106. Temporarily disable display in formula bar
  107. extraction problem - help please
  108. IF functions
  109. Highlighting Precedents
  110. backing up spread sheets with links
  111. Problem usinf Sort Function
  112. Function
  113. Data list ?
  114. Drop-down list or similar
  115. advanced filtering dilemma
  116. Inputting various dates
  117. How Do I Sort Cell Blocks in Ascending Order?
  118. Enter pages to make a book
  119. Iteration for sheet names
  120. Using FIND on forumla entered
  121. Compliing Data from multiple worksheets onto one worksheet
  122. Open Workbook in IE
  123. All my functions turned into text. What did I do
  124. Help: How to stop macro security warning
  125. Extracting Multiple Examples
  126. Filtering Rows
  127. moving cell data in a systematic rotation
  128. rotation of fields
  129. Excel won't subtract
  130. Converting Number to Date
  131. Coping chart in each worksheet and updating source data
  132. What does {} accomplish?
  133. onClick functionality?
  134. Image in worksheet / Send to back
  135. Weekdays
  136. Validation list & filter
  137. Problem with IF formulae!!!
  138. Coloumn Countdown
  139. Name limit range
  140. If formula - gives error on negative number
  141. Help - Averaging multiple rows
  142. excel on different windows editions
  143. Excel crashes when I load help
  144. autocorrecting Data
  145. Group & Outline: Error Message "Cannot shift objects off sheets".
  146. two-variable table
  147. Moving decimal points
  148. Reference - please help
  149. How do go to each worksheet and run a macro?
  150. Ignore blank Cells
  151. Changes not taking affect
  152. Merging worksheets?
  153. Additional formatting: font-, cell- and gridcolour
  154. List of Categories
  155. Help: Manipulating cells without formulas
  156. Formula that sum numeric and text
  157. Border around page in Excel
  158. retrieve information
  159. Dynamic Cell Formulas-HELP!!
  160. Analyzing Baseball Stats
  161. My code crash excell randomly
  162. Track Changes - Audit Trail
  163. Easy way to take data from multiple columns
  164. Help!
  165. Sumproduct anyone
  166. Matching Values or Text
  167. Protected Sheets/ Cell
  168. football stats
  169. Years before 1900
  170. portrait vs. landscape
  171. Filter Data from multiple worksheets
  172. Can't move selected cell with arrow keys
  173. roundup
  174. SUMPRODUCT help
  175. Email send
  176. Insert date on multiple pages
  177. Help on hiding rows on spread sheet
  178. Counting hours
  179. Rectifying odd date order
  180. Macro help
  181. Sumproduct and value error
  182. hard one
  183. Insert Row Formula Strangeness
  184. Filter & Count Issue
  185. i need to solve this please!
  186. Counting problem
  187. Removing space in cell
  188. Formula doesn't copy down properly...
  189. How do i use the content of a cell in my formula?!
  190. Deleting Duplicate Cells
  191. need a macro to fin last cell in row then select and enter value
  192. Seeking Expert Advice on Set Up for Publishing Excel on Web
  193. Hyperlinks from Excel to CD file
  194. Two IF statements2
  195. How do I get this macro to paste only values??
  196. Conditional Formatting
  197. Importing Micro. Word Files
  198. Formula works halfway?
  199. Date. Display colour when +1, 2 & 3 years
  200. If negative output zero
  201. Reviewing toolbar won't go away
  202. Finding rank of students 2
  203. Excel function
  204. Search
  205. Finding rank of students
  206. Hiding Rows With A Cell Containing "0"
  207. Code wont Run
  208. VB Coding. Who's got the Knowledge?
  209. Can't Insert Columns
  210. Selecting rows based on formating of a cell.
  211. Drop-Down Menu
  212. sumif help
  213. Help with sales report
  214. Simple question.
  215. Plz Help, Excel N00b
  216. On Error Goto problems
  217. Formula for odd or even numbers
  218. Data - Validate - Input Message
  219. Automated filter?
  220. moving data into multiple cells
  221. Start up file & New Workbook Task Pane
  222. Screen Tips
  223. Increase row of cell reference to another worksheet by 20
  224. Excel keeps putting quotes in my delimited txts
  225. Moving All Cells Into One Column
  226. Hiding numbers that are part of a formula
  227. Copy and paste macro onto single sheet
  228. Default Options Changing
  229. 3rd root!
  230. text in cells
  231. Filter multiple columns
  232. Checking for hyphens in strings
  233. multiple x values for graphs
  234. blank pages
  235. Vertical Data to Horizontal Data
  236. Some Advice Please....My head hurts
  237. How to return a value instead of #N/A
  238. Updating Excel Links using Macro HELP!
  239. Linking Cell formula question
  240. listing counted entries
  241. remove the dash
  242. COUNTING Duplicate and Unique Entries
  243. matching contents of three cells to reference
  244. Why doesn't this work??
  245. pasting links between work books
  246. startup
  247. Changing author title in comments boxes
  248. Help with Excel Form
  249. Help with pulling data from a table
  250. How to tell if a cell is % formatted