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. [SOLVED] clicking & dragging
  2. refine my calculations pls (Simplified question)
  3. Why do my checkboxes get smaller and smaller every time they are checked?
  4. counting and subtracting within a column
  5. Roll Off
  6. Complex formula exists but needs refinement (very long)
  7. Making cell value blank
  8. using conditional formatting but reference is different cell
  9. Validating data in 500 count increments
  10. Automatic Color in A Cell
  11. Text higher than the row height, don't want it trimmed
  12. Number format issue
  13. [SOLVED] Protect workbook from Ex-employees
  14. Pivot table percentage calculation
  15. Combo box and array formula
  16. SQL Server data and conditional formatting
  17. CSV file date format
  18. How do I handle table names that change?
  19. Check different cells if all contains same value
  20. Transfering data to new source
  21. locking cells once populated
  22. drop down list order
  23. Not sure what im trying to do
  24. Low Quantities alert
  25. Calculate shifts between 2 dates
  26. If formula issue
  27. Scroll Bars from the Beginning
  28. excel file operation
  29. opening csv from ftp-server sometimes causes error message
  30. Weird problem for using mht files
  31. How to Identify duplicate rows?
  32. How To Auto Complete Numbers?
  33. Convert to Text with leading zeros
  34. Maintaining fractional formatting when combining cells
  35. formula to calculate a group of numbers
  36. Restricted values
  37. Printing only filled cells
  38. Holdings checking
  39. GTIN Barcode Check Digit Help
  40. Suspend all macros
  41. text strings
  42. Displaying blank cells instead of null values...
  43. auto input on list of selection dates
  44. How do I figure out a pre-tax amount when I know the final total?
  45. Inconsistency in Undo command
  46. Strange Excel Behavior!
  47. Undo causes excel to change behavior
  48. auto increment worksheet while copying
  49. Index Match formula
  50. Signature Block in Header
  51. find and replace not working
  52. automatically add the payments into a summary worksheet
  53. Blinking / Flashing Object
  54. Add all values in next column/same row to “x” every time “x” occurs
  55. Dates
  56. Find the value of a cell that comes after a certain cell?
  57. Summing data from one date between two others.
  58. Count cells with assigned value
  59. Vlookup and Match function
  60. Returning different values when comparing 2 cells
  61. Add row when sheet is protected.
  62. Is there a way to make excel send people alerts
  63. ODBC-settings stored in xls-file
  64. Bonus calculation using IF statement
  65. count the worksheet used per cell
  66. Lookup + SumIFS
  67. Excel Mobile VBA
  68. Using IsBlank In Formula
  69. Shortcut to Edit within Cell at Beginning of Cell
  70. [SOLVED] Trying to replace part of a formula, why am I getting an error?
  71. #VALUE! returned on some PC's and not others, same version of excel???
  72. shortcuts.
  73. search function
  74. Need help with Formatting
  75. Getting data from another excel based on ...
  76. Strange icon in the cell
  77. Filtering out unwanted duplicate records
  78. Need this for work, can someone help plz
  79. Copy worksheet to another workbook
  80. Inserting a blank row in between rows
  81. Methodology for creating investment cost estimation sheet?
  82. Page Numbering in Page Titles
  83. Compare 2 columns then give count
  84. Converting a PDF to EXCEL
  85. disable duplicate name error
  86. Changing Seconds to minutes
  87. need a formula that speeds up my current complex process!
  88. max value of a cell nested if statements
  89. Database backend to excel front end
  90. Default Font size in comment boxes ?
  91. Budget Formula
  92. Working with two ranges
  93. image/picture appear if a cell meets a certain condition?
  94. Yellow square similar to a comment
  95. prints 8 pages, only 4 have content?
  96. Range=Range as condition in Sumproduct
  97. Formatting csv file
  98. Difference in Date and Times
  99. Sorting of Worksheet Tabs
  100. Filterering causes a spontaneous hide on rows
  101. Insert new raw at the end without udpating the ranges in forumla??
  102. Transferring cells onto another workbook
  103. Roll-down bar?
  104. Tabulate Information
  105. How to auto copy from file to file with out of order data?
  106. Named Range
  107. Cell number formatting changing when I don't want it to
  108. Paste Picture Link option in Excel
  109. Grouped Row Properties ?
  110. File path including a worksheet value
  111. Accounting format using Parenthesis for negative numbers
  112. Convert Formula result in Time Format
  113. copying and pasting from multiple reports without creating duplicates
  114. Formula Links
  115. Excel to Powerpoint
  116. Applying If statement to wide range of cells
  117. CheckBox Font Size
  118. Barcode Check Digit Calaculation
  119. ODBC Problem
  120. Query Access Database in Excel
  121. Ignoring cells with "-" when applying conditional formatting?
  122. Date Formating
  123. league table
  124. histogram creation & intervals
  125. clear cache to reduce sheet recalc time
  126. Combining data in duplicate rows, Excel 2007
  127. Prevent excel from Opening with a new workbook
  128. Excel opens without blank worksheet
  129. [SOLVED] Missing Status Bar
  130. Find Duplications
  131. Multiple colours in one cell
  132. Why am I getting "file corrupted" messages?...
  133. Inserting Data form a Spreadsheet Into a Mail Merge
  134. keyboard shortcuts
  135. copy and paste without overwriting cells containing values
  136. multi sheet cell referencing while skipping rows
  137. Interest Payments
  138. combo / list box's
  139. Making all text strings the same length
  140. Gather information from a Mastersheet to individual worksheets - pending selection
  141. Masks
  142. Changing date entries from dd/mm/yyyy to mm/dd/yyyy
  143. Column must be integer
  144. Excel extremly slow when formatting cells
  145. PDF to Excel
  146. Web query / RSS - browsing in Excel?
  147. How to Pick Value of adjacent cell when Search is true
  148. vlookup on specific multiple worksheets
  149. Searching for 50 combinations of something out of hundreds.
  150. Row height question
  151. Gathering and listing data from another sheet
  152. Hidden Formatting?
  153. using Vlookupallsheets function, but only looking up VALUE
  154. copying cells with conditional format colors, pasting in new worksheet keeping colors
  155. Best scenario for writing notes in row or cells.
  156. Strange formula: =IDX1
  157. How to auto highlight higher value cell in same row when enter?
  158. Referencing a cell in another sheet
  159. Problems with Integrating Multiple Spreadsheets?
  160. Formula incrementing #'s when amounts exist on same row.
  161. What does '--' do in formulas?
  162. how to reference cells in one worksheet to another
  163. Autoupdate Excel when change made in datasource
  164. Excel files mixing together
  165. Grouping Question
  166. Finding duplicate or missing entries in a list
  167. extract numbers out of strings.
  168. Matrix question
  169. and() and arrays
  170. SUMPRODUCT counts 1 (Jan) even when cell is blank
  171. Sorting Data w/in Multiple sections
  172. How to Approach this project?
  173. This is going on my list of greatest tips ever
  174. Monitoring Changes in Elevation
  175. fixed cell size
  176. Column Total Contingent Upon Another Column
  177. Problem with timesheet
  178. Insert a picture from a UserForm
  179. How to learn a computer language especially VBA
  180. Hyperlink within the same worksheet
  181. conditional formatting conundrum
  182. Shortcut to pastespecial option?
  183. MP3 Files
  184. Horizontal scroll bar issue
  185. Worksheet Name Max Length
  186. Expanding rows
  187. Swap Columns?
  188. How to prevent comments from moving when rows grouped?
  189. Parse values either side of a delimeter.
  190. Saving from a program into .XLS with Cyrilic Carachters
  191. Calculations using Time and Date
  192. Day of the Week script
  193. Formula to use percent if exists in a cell.
  194. Importing info from MS Excel to MS Word
  195. Verify if Microsoft Calendar control is installed
  196. Rank changes after sort
  197. Displaying formulas instead of values
  198. conditional formating: spell check
  199. Pivot table - filtering question
  200. Match/List
  201. Cell References, Filling Down Problem
  202. No borders on print
  203. Hide Sheets
  204. Dynamic Range
  205. Conversion to number
  206. Linking Outlook Emails to Excel
  207. displaying a date associated with a value in another column
  208. Password For Link To External Data
  209. Link to .SWF with user authentication
  210. Text saved with ^ and ' sign ??
  211. Revenue allocation using combined/Nested IF statements
  212. Forecast the Completion Date and Time
  213. lable duplicate entries
  214. Excel displaying help file when I create a circular reference
  215. Remove Activation of cell
  216. Excel Protect Sheet Problem
  217. Error when using date formula
  218. How to stop auto formating of cell to date format
  219. Excel File Linking
  220. Conditional Formatting with more than 3 rules
  221. Sum
  222. Excel crash while enabling macro
  223. If statement
  224. Create a "Week" Column - automatic?
  225. Using a list to generate different data for each choice
  226. Conditional formatting date cells based on entry in adjacent cell
  227. Conditional Formatting
  228. Converting information on multiple rows into one row
  229. Removing Spaces between text and/or numbers
  230. Formula to insert data from another spreadsheet based on a search?
  231. If Statement
  232. Can't change the viewable size of worksheet when protecting workbook
  233. Time
  234. rows to columns
  235. Creating formulae to work out US withholding tax?
  236. Excel worksheet link search and fill formulas?
  237. printing spreadsheet is different size
  238. Excel problem
  239. Loan Amortisation
  240. Lab Book Template
  241. Count the number of highlighted cells
  242. Bonus calculations using Nested IF's
  243. if function - dates
  244. inserting numbers based on sorting a list
  245. Check Boxes
  246. Counting problem
  247. If Formulas
  248. Lookup text, return average of values
  249. problem using sorting within pivottables?
  250. Conditional formatting - is cell a date?