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. Find and replace
  2. Giving some conditions priority in CHOOSE-formula
  3. All numbers multiple of 0.1
  4. Excel will not show Documents opened from a link until I minimze window
  5. save copy
  6. Text wrapping not working in whole cell
  7. Subtracting datetime cells
  8. Summing Up a column defined as AlphaNumeris
  9. Validating a cell
  10. Manual calculation not working
  11. Copying data horizontal to vertical
  12. "Unable to read file"
  13. Quick cell formatting (avoiding F2)
  14. always change a cells text context into CAPS
  15. Formatting based on conditions in other cells
  16. Copying Exact formulas
  17. Holiday planner/tracker
  18. create a drop down list without using a table
  19. Link to spreadsheet based on cell content
  20. Index function with if statements
  21. Opening MS Excel 2007 file with xml in it but an xls file extension
  22. IF workdays
  23. Easy conditional formatting question
  24. Searching for Cells containing #DIV/0!
  25. Maybe a conditional format
  26. Fill a 'Block' of Formula
  27. Tabs List in a Workbook
  28. How To Utilize Scrollbar For Navigation
  29. Losing notes following MS Query Refresh
  30. Look up, match then copy from 6 colmns
  31. insert row macro problem
  32. IF function in order to preference
  33. Microsoft bug in Excel 2007
  34. Question re data entry.
  35. SUMPRODUCT and ISERROR returning odd results
  36. Tracking Dates
  37. Inserting multiple values within a single cell.
  38. Excel returns 0 instead of no value
  39. Do not update non-active sheets
  40. Remove recent list in excel
  41. Ignore Spaces in "Blank" Cells
  42. Lookup/Match/Index...
  43. Selecting records associated with LARGEst values
  44. during save macro disappears
  45. Password Protected Spreadsheets
  46. How to identify non-matches
  47. Strange Yellow Text in Excel Menus
  48. Stop Text Number formatting as Scientific
  49. formula for prior month & year of a month end date.
  50. macro that stops a user if they try to drag down
  51. Conditional Formatting for errors
  52. Missing Formula Bar
  53. add ONLY negative networkdays
  54. Copy the value of the cell immediately above
  55. Networkdays
  56. insert rows and copy formats into those rows
  57. Triple if, and, or 'or' fuction??
  58. Changes & Issues
  59. VLookup
  60. Calculating Contract Value
  61. graphic under cells
  62. Macro error that pops up all the time
  63. scan for numerical sequence?
  64. how to get multiple values (avg is what I need) from multiple rows
  65. problem entering 16 digit data. The last digit always appear to be zero
  66. exporting hyperlink URLs to word mail merge
  67. Covert column data to row headings
  68. Characters
  69. Solution/best practice for vlookup stability
  70. Sum and Multiple - (1+A1)*(1+A2)*...
  71. Pivot tables
  72. cross posting
  73. Problem Using AutoFilter
  74. Conditional formatting
  75. Don't Calculate If Reference Cell Is Blank
  76. Duplicates In A List
  77. SUM every 5th row
  78. Duplicate file on open
  79. Time calculations
  80. Pivot Tables
  81. Total by location
  82. Formula returns a minus figure until the second date box is filled
  83. Search Multiple Words in a Column
  84. fetch range from mult workbooks into one workbook
  85. Typing accents in XL 2003
  86. check cells for missing data
  87. combine date Plus text
  88. Send rows that contain certain word to top?
  89. Scroll image across screen
  90. Cut, Copy & Paste
  91. Password / Macro
  92. Want a Macro button that slides the spreadsheet
  93. Countif criteria with columns and rows
  94. Excel 2007 - Worksheet behaviour
  95. Import one Excel file into another using Excel 2007
  96. Conditional Formatting
  97. combo box to open files
  98. Merging Different Workbooks (not shared)
  99. Solved >>> Countif formula
  100. Conditional Formatting
  101. Hyperlink with partial name
  102. Color not the same when others open my excel file
  103. maximum characters in cell
  104. Formula to return day based on month end date & day number of month
  105. Push the tab where does it move you?
  106. Hyperlink to a file regardless of file type
  107. Can I use the Outlook Addressbook in Excel?
  108. quotation marks are not pasted
  109. Transferring info from another sheet
  110. Print Challenge
  111. equal to or less than
  112. Year to Date sum in one cell depending on the Month
  113. Group and Ungroup Macro
  114. populating a table with the sum of a formula
  115. CountA Formula
  116. Conditional formatting again.
  117. Merged Cells
  118. Automatically numbering shaded boxes
  119. Validation?
  120. Conditional Formatting
  121. Matching cells
  122. Making money with Excel?
  123. sum function does not work intermitently
  124. Square of a number
  125. text to numbers via a macro
  126. Showing different results dependant on drop down box?
  127. Combining Cells with Zeroes
  128. Drop down menu calculator.
  129. delete certain characters from a cell
  130. date field problem
  131. Separating Items
  132. Extracting a cell's formula
  133. Keep cell blank if formula = false or empty
  134. Cell format (decimals)
  135. Lookup question
  136. data from a calendar to spread sheet
  137. Quick way of getting rid of the file references on copied sheets?
  138. Relative Named Ranges in Excel
  139. Sumif question
  140. Images in Excel
  141. Adding data to an external database using a spreadsheet
  142. redline comparison of spreadsheets
  143. one Pivot Table for many sheets
  144. Combo box
  145. Extracting First Name from cell
  146. Rows Shown Wide On Print Preview
  147. Continuos importing without lossing previous data.
  148. Savings Assignment
  149. Print/show gridlines over filled cells
  150. Format Cell with phone numbers not displaying correctly.
  151. command button
  152. Getting info from one place to another
  153. Truncate Concatenate!
  154. Counting - based on part of a cells contents
  155. Formula Efficiency
  156. Open Explorer With A Button
  157. Histogram info
  158. Linking worksheets
  159. Pasting HTML formatted text as plain text in Excel
  160. Calculation + text??
  161. Receiving 0 when copying formula
  162. Excel Sorting
  163. Remove rows that have same words in different order?
  164. Seeing What Worksheets Are In A Doc?
  165. comand button named mail to to access the mail program
  166. Auto Populate?
  167. Print a certificate multiple times with different data
  168. Highlight Repeating #'s in a Column
  169. string concatenation
  170. link between word
  171. Formular Problem
  172. Totalling Columns in Pivot Table
  173. Sorting Rows
  174. Saving a Excel file
  175. Password Protecting
  176. Using a cell reference in a formula
  177. Merge Cells - How Do With Keyboard?
  178. #REF Error to another Workbook
  179. Vlookup with words?
  180. Latest Occurence
  181. Sum between 2 dates
  182. Convert number to date
  183. Percentage Discrepencies
  184. VLOOKUP with Pictures?
  185. Averages Based on Date
  186. Rounding
  187. combine functions
  188. Referencing Multiple Workbooks
  189. Drop Down List
  190. Using check boxes on protected worksheets
  191. Vlookup Multiple Rows
  192. Alter a pivot table cell driver by reference
  193. conditional formatting
  194. Cell Format Colour in Formula Result
  195. Using Ink
  196. vlookup with keywords?
  197. Scrolling in Protected Cells?
  198. MS Word - import a mass amount of pictures
  199. Freeze columns
  200. Email Header in Excel
  201. Suppress Leading Zero
  202. problem with fill color
  203. Set cells to not print?
  204. 2007 Non-professional edition
  205. transposing list from rows to columns
  206. Compare/Sum different Collums
  207. Matching & Duplicates
  208. Error Value
  209. format
  210. Sorting Data Table (league table)
  211. Circular Reference
  212. Unprotected worksheet won't let me Group rows/columns...
  213. Lock Aspect Ratio of objects on a workbook sheets
  214. formatting?
  215. Macro to insert Image into Word document
  216. Error Code 1004 when exporting from VB app to Excel 2007
  217. What is this (pic) & how do I add it to my Workbook?
  218. Create .csv file programmatically using C#
  219. combining columns
  220. What's all this buzz about hugeroi.com
  221. Copy address label from row to column
  222. IF AND - a senior moment
  223. Show 09 Not 9
  224. csv formatting problem
  225. Conditional Formating
  226. Conditional format and object
  227. Quick Query
  228. Filtering by many items
  229. Pivot Table Filter Frustration
  230. ISNUMBER Query
  231. Launch a URL from with a Macro
  232. Corporate Wishlist Template
  233. Trying to create pivot via VBA
  234. Keyboard shortcut - F4
  235. InputBox
  236. Printing a split screen
  237. Countdown Timers?
  238. Add up Duplicates
  239. Carrying formulas from one sheet to another
  240. Buttons to increase numbers
  241. Replacing Characters
  242. unique records from 2 long spreadsheets
  243. Dragging a macro like a formula
  244. Autosave - Excel 2000
  245. creating pop-up menu with fixed values
  246. Counting only cells with data
  247. wite protect issue
  248. Conditional Format
  249. Networkdays
  250. Open non-CSV file as a CSV file