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

  1. ODBC-settings stored in xls-file
  2. Bonus calculation using IF statement
  3. count the worksheet used per cell
  4. Lookup + SumIFS
  5. Excel Mobile VBA
  6. Using IsBlank In Formula
  7. Shortcut to Edit within Cell at Beginning of Cell
  8. Trying to replace part of a formula, why am I getting an error?
  9. #VALUE! returned on some PC's and not others, same version of excel???
  10. shortcuts.
  11. search function
  12. Need help with Formatting
  13. Getting data from another excel based on ...
  14. Strange icon in the cell
  15. Filtering out unwanted duplicate records
  16. Need this for work, can someone help plz
  17. Copy worksheet to another workbook
  18. Inserting a blank row in between rows
  19. Methodology for creating investment cost estimation sheet?
  20. Page Numbering in Page Titles
  21. Compare 2 columns then give count
  22. Converting a PDF to EXCEL
  23. disable duplicate name error
  24. Changing Seconds to minutes
  25. need a formula that speeds up my current complex process!
  26. max value of a cell nested if statements
  27. Database backend to excel front end
  28. Default Font size in comment boxes ?
  29. Budget Formula
  30. Working with two ranges
  31. image/picture appear if a cell meets a certain condition?
  32. Yellow square similar to a comment
  33. prints 8 pages, only 4 have content?
  34. Range=Range as condition in Sumproduct
  35. Formatting csv file
  36. Difference in Date and Times
  37. Sorting of Worksheet Tabs
  38. Filterering causes a spontaneous hide on rows
  39. Insert new raw at the end without udpating the ranges in forumla??
  40. Transferring cells onto another workbook
  41. Roll-down bar?
  42. Tabulate Information
  43. How to auto copy from file to file with out of order data?
  44. Named Range
  45. Cell number formatting changing when I don't want it to
  46. Paste Picture Link option in Excel
  47. Grouped Row Properties ?
  48. File path including a worksheet value
  49. Accounting format using Parenthesis for negative numbers
  50. Convert Formula result in Time Format
  51. copying and pasting from multiple reports without creating duplicates
  52. Formula Links
  53. Excel to Powerpoint
  54. Applying If statement to wide range of cells
  55. CheckBox Font Size
  56. Barcode Check Digit Calaculation
  57. ODBC Problem
  58. Query Access Database in Excel
  59. Ignoring cells with "-" when applying conditional formatting?
  60. Date Formating
  61. league table
  62. histogram creation & intervals
  63. clear cache to reduce sheet recalc time
  64. Combining data in duplicate rows, Excel 2007
  65. Prevent excel from Opening with a new workbook
  66. Excel opens without blank worksheet
  67. Missing Status Bar
  68. Find Duplications
  69. Multiple colours in one cell
  70. Why am I getting "file corrupted" messages?...
  71. Inserting Data form a Spreadsheet Into a Mail Merge
  72. keyboard shortcuts
  73. copy and paste without overwriting cells containing values
  74. multi sheet cell referencing while skipping rows
  75. Interest Payments
  76. combo / list box's
  77. Making all text strings the same length
  78. Gather information from a Mastersheet to individual worksheets - pending selection
  79. Masks
  80. Changing date entries from dd/mm/yyyy to mm/dd/yyyy
  81. Column must be integer
  82. Excel extremly slow when formatting cells
  83. PDF to Excel
  84. Web query / RSS - browsing in Excel?
  85. How to Pick Value of adjacent cell when Search is true
  86. vlookup on specific multiple worksheets
  87. Searching for 50 combinations of something out of hundreds.
  88. Row height question
  89. Gathering and listing data from another sheet
  90. Hidden Formatting?
  91. using Vlookupallsheets function, but only looking up VALUE
  92. copying cells with conditional format colors, pasting in new worksheet keeping colors
  93. Best scenario for writing notes in row or cells.
  94. Strange formula: =IDX1
  95. How to auto highlight higher value cell in same row when enter?
  96. Referencing a cell in another sheet
  97. Problems with Integrating Multiple Spreadsheets?
  98. Formula incrementing #'s when amounts exist on same row.
  99. What does '--' do in formulas?
  100. how to reference cells in one worksheet to another
  101. Autoupdate Excel when change made in datasource
  102. Excel files mixing together
  103. Grouping Question
  104. Finding duplicate or missing entries in a list
  105. extract numbers out of strings.
  106. Matrix question
  107. and() and arrays
  108. SUMPRODUCT counts 1 (Jan) even when cell is blank
  109. Sorting Data w/in Multiple sections
  110. How to Approach this project?
  111. This is going on my list of greatest tips ever
  112. Monitoring Changes in Elevation
  113. fixed cell size
  114. Column Total Contingent Upon Another Column
  115. Problem with timesheet
  116. Insert a picture from a UserForm
  117. How to learn a computer language especially VBA
  118. Hyperlink within the same worksheet
  119. conditional formatting conundrum
  120. Shortcut to pastespecial option?
  121. MP3 Files
  122. Horizontal scroll bar issue
  123. Worksheet Name Max Length
  124. Expanding rows
  125. Swap Columns?
  126. How to prevent comments from moving when rows grouped?
  127. Parse values either side of a delimeter.
  128. Saving from a program into .XLS with Cyrilic Carachters
  129. Calculations using Time and Date
  130. Day of the Week script
  131. Formula to use percent if exists in a cell.
  132. Importing info from MS Excel to MS Word
  133. Verify if Microsoft Calendar control is installed
  134. Rank changes after sort
  135. Displaying formulas instead of values
  136. conditional formating: spell check
  137. Pivot table - filtering question
  138. Match/List
  139. Cell References, Filling Down Problem
  140. No borders on print
  141. Hide Sheets
  142. Dynamic Range
  143. Conversion to number
  144. Linking Outlook Emails to Excel
  145. displaying a date associated with a value in another column
  146. Password For Link To External Data
  147. Link to .SWF with user authentication
  148. Text saved with ^ and ' sign ??
  149. Revenue allocation using combined/Nested IF statements
  150. Forecast the Completion Date and Time
  151. lable duplicate entries
  152. Excel displaying help file when I create a circular reference
  153. Remove Activation of cell
  154. Excel Protect Sheet Problem
  155. Error when using date formula
  156. How to stop auto formating of cell to date format
  157. Excel File Linking
  158. Conditional Formatting with more than 3 rules
  159. Sum
  160. Excel crash while enabling macro
  161. If statement
  162. Create a "Week" Column - automatic?
  163. Using a list to generate different data for each choice
  164. Conditional formatting date cells based on entry in adjacent cell
  165. Conditional Formatting
  166. Converting information on multiple rows into one row
  167. Removing Spaces between text and/or numbers
  168. Formula to insert data from another spreadsheet based on a search?
  169. If Statement
  170. Can't change the viewable size of worksheet when protecting workbook
  171. Time
  172. rows to columns
  173. Creating formulae to work out US withholding tax?
  174. Excel worksheet link search and fill formulas?
  175. printing spreadsheet is different size
  176. Excel problem
  177. Loan Amortisation
  178. Lab Book Template
  179. Count the number of highlighted cells
  180. Bonus calculations using Nested IF's
  181. if function - dates
  182. inserting numbers based on sorting a list
  183. Check Boxes
  184. Counting problem
  185. If Formulas
  186. Lookup text, return average of values
  187. problem using sorting within pivottables?
  188. Conditional formatting - is cell a date?
  189. Copying Columns causes File Size to Explode
  190. Pivot table cope with inserted columns
  191. "Windows in Taskbar" feature does not work
  192. Auto Filter issue
  193. Creating Time Formula
  194. identify and print the ones on the list
  195. Library Data
  196. Copying a whole worksheet that updates
  197. Min/Max Using Criteria from another Column
  198. Style? Format? Dealing with currency
  199. count running total
  200. Search, retrieve & input
  201. Need Help Creating a Conditional Formula
  202. Listing values while ignoring blanks
  203. Recognising the first non-zero value over 13 columns
  204. Combine column- two lists, with unique identifier
  205. Can a Macro be run from inside an IF statement?
  206. Graphic Attached to Cursor
  207. Linking a flow chart box to a text box on another sheet
  208. Merging Columns into One Column
  209. flowchart question
  210. hyperlink/picture editing
  211. Activate Add-Ins for All Users
  212. A basic question about formulas
  213. formula help
  214. formula with 3 conditions ?
  215. Selecting multiple cells
  216. Changing time hh:mm:ss field
  217. Help needed on excel. Is it possible?
  218. Formula with Power function
  219. Combining Text From Multiple Cells
  220. excel conversion/reference table
  221. Help with stock list
  222. auto-adding specific suffix to user value?
  223. Return the earliest day of a month
  224. 5 Digit Combination/Permutation??
  225. dynamic Form List Boxes
  226. hierarchy filters in pivot table
  227. Restaurent list
  228. Resolved - to link formula between sheet
  229. Excel startup problem?
  230. Opening hyperlinks
  231. taking the Zero out before a number
  232. A Little Help About Filter ?
  233. How to change Data order
  234. Linking/embedding word doc
  235. Time Formating
  236. Totals across multiple worksheets
  237. duplicate cells with different values
  238. Updating Links within a single Workbook
  239. New here, need some help with PivotTable/PivotCharts
  240. Combining 2 excel files
  241. dynamic Form List Boxes
  242. Continue Searching a table with Vlookup despite finding one match
  243. Protecting data for certain users only?
  244. randbetween() problems
  245. Conditional Formating
  246. Calendar Functionality
  247. Help me please
  248. Randomly add List Elements to Chart
  249. Resort a Pivot Table Filter
  250. Labor cost formulas