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. Macros & Cell Protection
  2. keeping text on top
  3. Replication Macro?
  4. How to ask about this forum (not excel)?
  5. moving a row to next sheet
  6. Locked as cross posting to other forums >> 3D Formulae
  7. double values for LARGE
  8. Excel 2007 Pivot Table Size
  9. Vertical text
  10. Compare Rows column by Column in Large Excel File
  11. SpreadSheet Count
  12. Pivot table Clear Old Items
  13. Pivot table with data from two tables?
  14. Evaluating contents of a cell.
  15. Vlookup
  16. Find value 3 cells away from lookup array
  17. printing big cells cut by a page break
  18. Shuffling data
  19. Countif
  20. why has my post been removed???!!!!!!!
  21. Limit allowed values for cells
  22. Automatic Graph Update
  23. auto-populate characters with cell values
  24. Highlight Duplicate Entries on a Row
  25. Custom Formatting/Text & Number Cell
  26. A way to limit sharing of a file?
  27. searching for fixed width font?
  28. Saving
  29. conditional formatting
  30. Sheet styles
  31. formulas
  32. countif
  33. subtraction question
  34. Excel 97 cannot open Unicode csv file
  35. Working out Average of percentages ignoring 0.00%
  36. Time Calculations
  37. =sum inbetween 2 dates used in v lookup
  38. Printing to PDF cuts off bottom of worksheet
  39. Printing a workbook...
  40. If Then - Goto Statement
  41. Substracting dates and times
  42. bursting rows into workbooks
  43. how to resolve this after Substitute function?
  44. Adding Column dependent on Date Time
  45. Downloading images from a list
  46. way to force a save?
  47. Average for values in range above a given value
  48. Formulas won't adjust when dragged down
  49. INT function
  50. formula
  51. Settings
  52. Pictures Lookup
  53. Depreciation formula ?
  54. Format as function of results
  55. Subtracting two dates and times
  56. Show hidden rows in chart?
  57. Odd Behavior from Excel this morning, Network Wide
  58. Counting
  59. sumif column contains 6 or more entries
  60. Filter
  61. Search worksheet
  62. conditional formulas
  63. Create Excel Report Using PHP Code
  64. Combo Box function
  65. check box
  66. future value ?
  67. Comprehensive gathered from various worksheets?
  68. Rolling Header?
  69. Enter Date, If Weekend, Pop Up Box Appears
  70. decimal settings
  71. Sum
  72. Remove 0 as the result
  73. non matching values
  74. switching between two forms of measurement
  75. Formulas
  76. Passwords
  77. Add random character to a string
  78. possible to lock some cells?
  79. adding a range of cells
  80. Population of cells with color based on value of other cells, skipping cells, etc.
  81. pivot table. why does the formatting change on update
  82. Custom Formatting to round to millions
  83. Pasting Formulas / References Question
  84. Too many If's
  85. Formula, for filtered worksheet
  86. Protecting Cells and being able to use Spelling Function
  87. Format within cell
  88. remove (empty) in pivot table
  89. Link to UserForms Tutorial?
  90. floating text box when scroll
  91. Using IF
  92. interest formula ?
  93. Shift row in formula
  94. hyperlink
  95. Save number as text in txt format wo changing the format
  96. Inserting an image file in a cell as a result of an IF Function?
  97. Stacked AND side by side column graph...
  98. When Is A Space Not A Space?
  99. If statements and the like
  100. Client record check
  101. Excel not opening spreadsheets
  102. Secondary formula calculation
  103. formula required
  104. Launch a macro after a sheet name change ?
  105. Daily trades sheet..How to make dynamic.
  106. Email of a single sheet in a woorkbook.
  107. Form Serial Numbers
  108. sum of mutliple products
  109. Displaying URL Text
  110. Conditional Formating Comparing values
  111. moving cells containing formulas to new worksheet
  112. date formating
  113. extract all the products mentioned in a column
  114. Function Fill Issue
  115. subtracting total
  116. Connect excel cells to word
  117. linking worksheets to auto-insert rows
  118. decimal formatting
  119. Blank workbook at startup
  120. Conditional Format
  121. Nested if
  122. Add cell comments to a protected sheet
  123. Cannot use offset formula to access another workbook
  124. V Lookup nil return value
  125. formula
  126. Excel Sick Days / Half Days
  127. Eliminate : Macro Security Warning
  128. Search for words
  129. can Substitute formulas be combined?
  130. Time limit access to workbooks (Excel 2003)
  131. VLookup (possible to search two columns)?
  132. UK Map links
  133. get info from one spreadsheet to another
  134. how to show if you add a number twice in a column
  135. import external data
  136. TMP files
  137. separate names
  138. Get "error 1327 Invalid drive" when openning ms excel 2000
  139. How do I make my chart look like this?
  140. Getting rid of #n/a
  141. Formula
  142. Controlling the font of imported data
  143. How can I move the series label down below the data?
  144. Doubling data chart?
  145. Copy Sheets
  146. Excel Macro
  147. Referencing Named Cell Ranges
  148. simple copy paste macro required
  149. vlookup needed - or And if formula
  150. Left, Right, Mid, Find...
  151. Custom Icons...
  152. Sharing violation error with excel 2007 macro-enabled files
  153. Timing code executions?
  154. Worksheet Cell References...
  155. Excel 2007 Display
  156. Percent in age range question?
  157. Keeping Formatting from Excel to a CSV file
  158. Help - Data Form
  159. Increment row or column
  160. Help with formula that looks up numbers
  161. Multi page userform
  162. Help copying data from a spreadsheet to another
  163. How to shorten code
  164. Sorting numbers in a specific way?
  165. Reformat user input data
  166. Is it possible to do a lookup with recurring criteria?
  167. Max number of sheets in a workbook
  168. lookup with repeating data in column a
  169. YTD Averages
  170. Automatic Calculation
  171. sumif where one of two conditions is fullfilled
  172. Colour changes
  173. Search for a person and return all matches including all info on person.
  174. How do I add a leading zero to a date?
  175. Cell will not calculate (even after F9 is pressed)
  176. Vlookup part of an account number
  177. Locking a formula reference to a cell.
  178. Excel bug
  179. Can't see text typed in cell??
  180. Managing An Auction
  181. Formula result showing formula, not answer
  182. proper case
  183. Moving text to cells ....
  184. What will be the Return On Investment (ROI)?
  185. Result through FV Function is being different from Pure Math Calculation?
  186. Hyper link help
  187. Spreadsheet for fundraiser
  188. mutiple cells need $
  189. Excel 4.0 Macro Information
  190. Data Transfer
  191. Pivot table: repeat row data in all cells
  192. extract the highest number in a row to another cell
  193. Formula to insert check mark?
  194. I Need Help Speeding Up code
  195. Auto Find and Replace?
  196. checking for repeats
  197. Combine pivot tables?
  198. Find & Replace in locked worksheet
  199. Master Reset
  200. worksheet protection password
  201. Protect Project Causes Error
  202. A running total using one input cell
  203. hewo again
  204. COUNTIF for 2 columns, conditional-formatting an entire row - THANKS!
  205. counting number of sales per employee
  206. case sensitivity check for List values
  207. Taking totals based on criteria. Is this possible?
  208. Searching and Retrieving a Value from another excel sheet! Please help?
  209. Majuscule Fonts
  210. return value depending on data enter
  211. How to Display List in a single row
  212. How to eliminate special characters from text?
  213. Data Exported From One Excel File To Another
  214. Can't enter any data, please help.
  215. Graph perimeters
  216. Removing Space from Number Copied n2 XL from HTML
  217. PLEASE HELP! (Possibly simple answer to my question....)
  218. Freezing a Cell
  219. Add two digits to every entry in a column
  220. cell editing
  221. Macro deletion
  222. #NA, cleaning data!
  223. Exporting Spreadsheet to Word
  224. Conditional Formating based on different cell
  225. Merging duplicate records in a sheet
  226. New Database query
  227. hyperlinks in a list.
  228. Minimum Value in a Range if Greater Than "X"
  229. Linking font colour between cells
  230. Charting Actual vs. Plan
  231. macro to change colour code
  232. Stopping Automatic calculations Within a Macro
  233. Excel in Perl-Win32::OLE: problems with some functions and macros.
  234. Post in same row, not column
  235. Formula won't work in W2K
  236. Importing a Word document into Excel
  237. How to turn off the date automatically replacing typed text?
  238. Custom fill?
  239. unknown file name
  240. Empty first column in CSV file
  241. Count Cells only when fmla popluates a #
  242. Floating Toolbar
  243. counting time!
  244. How to find any number greater then (x) and replace with a letter?
  245. Avoid duplicates
  246. Filter, Extract or Search Cell Information
  247. Extract Date
  248. cumulative logging of cell entries
  249. Find position of all locations of given character in a string
  250. Changing the colour of autoshapes