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. More on 1234,56 - another problem
  2. Splitting Columns
  3. Spread sheet programming / calculation help
  4. Goal Seek
  5. Change 12345 into 123,45
  6. Data Manipulation
  7. Can Import Data SQL reference spreadsheet cell?
  8. Project Help!!
  9. eliminate cell selection
  10. Reference Other Work Sheets for Conditional Formatting
  11. Auto cell value in header
  12. External data ranges: Keeping information aligned
  13. How can I autofilter from a different row and not always 1
  14. Macro to make my "Field Copies"
  15. formula that can calculate 3 weeks from a date given
  16. Extra lines added to non .xls files when opened in Excel
  17. Excel Numeric formating
  18. Removing Characters to right of
  19. Duplicate issue
  20. Linking and Printing
  21. sum if duplicate names
  22. AutoFilter Problem
  23. Multiple functions in one cell? An alternate techinque perhaps?
  24. too many characters
  25. Mac Excel users
  26. deleting duplicate rows based on 2 criteria
  27. Using a color to show a sorted list
  28. Multiple Background Colours in a Single Cell
  29. Reviewing Toolbar - past results fail
  30. Sort rows separately
  31. VBA Question
  32. Excel lists & Autofilters
  33. Worksheet Restrictions
  34. Unable to change views in the open file dialog box in Excel 2003
  35. import multiple text file to one excell workbook
  36. Rounding
  37. Excel - Track Changes
  38. How to delete rows that include blank/null cells
  39. Average at intervals
  40. how to stop pivotTable?
  41. VB codes for delete command button (new)
  42. Project Calendar
  43. Zipping a workbook with Mac.
  44. Drop Down List bound by second column
  45. Hiding unused rows
  46. Mortgage Formula
  47. Separating data
  48. Rounding an entire worksheet?
  49. Conditional Formatting Colors
  50. New "Collect" addin for Excel
  51. keep background colour in pivot tables
  52. Changing Cell Colours
  53. Can I edit excel 2003 templates?
  54. Lack of memory and SharePoint
  55. HLOOKUP question
  56. VLookup question
  57. Making a "trigger"
  58. Date problem
  59. Linking Spreadsheets
  60. Pasting into password protected sheets.
  61. Inches to Feet conversion
  62. Merging 2 columns into 1
  63. Protecting a sheet with radio/option buttons
  64. Closest value to Cells
  65. sorting of long Excellist with varios content.
  66. Locking cells using a macro
  67. Graph source data series value issue
  68. 2 Excel Sprdshts 1-word mail merge, 1 for data
  69. Buttons to push...?
  70. Cricket Spreadsheet
  71. Maintain pivot when refresh
  72. Changing column numbers to negative
  73. vlookup:how to get several results ?
  74. Conditional calculating – “Special SUMIF”
  75. If, Max, Then...
  76. data validation
  77. Sum Problem
  78. conditional formatting
  79. counting days excluding saturdays and sundays
  80. Conditional Formatting in Cells where there are also formulas present.
  81. Repeating Information in a Cell
  82. Function in a cell to search for a text
  83. Transform If Code to Formula
  84. Mail merge, group rows
  85. formulas/values
  86. Macro help - I think
  87. formatting codes.
  88. Open file in Excel X
  89. Vlookup formulas
  90. Linking cells with formatting
  91. Shared Workbook problem
  92. how do you multiple select and delete rows that the data you select are in
  93. in vba, how do u
  94. Time Calculation problem
  95. Create Worksheet from Worksheet
  96. How to permanently delete rows, so that they don't show either
  97. Multiple Criteria INDEX MATCH MAX
  98. Adding Excel Information Into a Word Document
  99. Data missing
  100. Excel to WordPerfect
  101. Make Labels on Charts Uniform Size
  102. Formula Question
  103. LARGE formula then next largest
  104. Conditional Formatting?
  105. Color
  106. Extracting strings of text from Columns of data(text)
  107. holding time values
  108. Compare the content of 1 cell with two other cells
  109. Speed Up Updating
  110. Stopping email addresses becoming hyper-links
  111. Calculated fields in textboxes/charts
  112. Index & Match error
  113. vba & dates
  114. Sumif question
  115. Blocking cells
  116. Dropdown According to Value in a cell
  117. Index Sheet
  118. change Capital to small letter
  119. how to insert column from Sheet2 to Sheet1
  120. count the days between two dates
  121. Refresh workbook from command prompt
  122. Paste Special command
  123. Formula disappears
  124. Time between times
  125. Filling in MOST cells, in a Row?
  126. If Statment range
  127. Splitting A number into four differnet cells
  128. Conditional Format Question
  129. How can I count Hyperlinks?
  130. problems with textalign
  131. If Function
  132. count only bold entries
  133. Copy cell contents to Button Label?
  134. Using vlookup for two table arrays
  135. Reformatting addresses
  136. Using online XML data in an EXCEL sheet.
  137. Using text to describe a number
  138. Format cell question
  139. If forumula Question
  140. Autofiltering with merged cells
  141. Listing Team Member
  142. How To Use My Excel Calculator Online?
  143. IF Question
  144. Countif
  145. Cannot Group Dates in Pivot Tables
  146. macro to copy row selected by user
  147. Word to merge Specific Excel Cells
  148. Weird Excel Problems when using Data Analysis Tool
  149. Adding time beyond 24 hrs.
  150. 2 stacked column graphs?
  151. Using If/Then in VBA with "OR"
  152. Averaging low 4 of last 6 numeric cells
  153. formula logic (sumproduct,countif)
  154. Setting pivot chart dropdown to last item in list
  155. function to differenciate durations
  156. Extracting / Tidying data... Automatically!
  157. create drop down list within a box?
  158. not enough rows
  159. count set ups
  160. Vlookup
  161. Returning an incremented value in one column
  162. Access help-Formulas in report
  163. How to take lowest value from 3 cells and...
  164. Date and Time Fill
  165. Calculations & Classification help
  166. VLookup Sum Result Help.
  167. How to get sorted datas with the formula
  168. Cost Calculator
  169. Saving xls as txt file with " " symbols
  170. link a .jpg file
  171. IF Formula
  172. Row height adjusts on sort
  173. Hlookup
  174. percentage of the total for each variable
  175. Linking workbooks within =countif formula
  176. Charting a time period
  177. Excel Query
  178. Inserting linked images into Excel 2003 worksheet
  179. keyboard select question
  180. Speed up Excel Calculation
  181. Count occurance of string in range
  182. MAX Value of Column Subset
  183. Incrementing invoice number
  184. Text To Columns
  185. Auto update pivot tables
  186. Excel to Frontpage
  187. Extra tabs in Tab delimited text file from Excel worksheet
  188. Drop Down box
  189. expense chart
  190. Expense chart
  191. Locking cells...
  192. Text Problem
  193. Vlookup function
  194. Lookup_array NAME in a MATCH function
  195. using defined range in a formula?
  196. How do I output a text box to a cell?
  197. Search for numbers in date
  198. Excel Spreadsheet for Car Park Roster
  199. Dropping digits
  200. Network Drive Path
  201. ComboBox Linage
  202. Linking a Number Code to a Name
  203. Transferring data from one excel spreadsheet to another
  204. Swap x and y axis?
  205. copying data in steps
  206. Date conversion
  207. Quick method of replicating check boxes and relevant cell link
  208. cell selection dependant on another cell value
  209. Count Occurance in Column
  210. Show a YES in one cell if another finds a match in another column in another tab
  211. how can I separate one color from another?
  212. Subtracting cells
  213. Thumbnails in Excel
  214. Deleting information macro
  215. Autofilter reports using Macros
  216. Formatting a formula
  217. Last 4 filled in rows formula?
  218. MOd function of a pre 1900 date
  219. If statement?
  220. Preventing the display of divide by zero errors.
  221. Dates
  222. statistical tests on data...in excel or spss?!
  223. Searching for Multiple Values
  224. drop-down missing
  225. SORTING - 'top' row problem, really frustrating!!
  226. fill color and font color no longer work!
  227. Transfer cell data
  228. Don't know how to use Lookup/Match/Index or a combination for this result
  229. Autofilter Top 10 Ignoring Other Filter Options
  230. Can't select or remove Control/Forms Button
  231. Sorting and Matching question
  232. Sorting
  233. Corrupt??? (long)
  234. Calculate Fiscal Year From A Date
  235. Searching in excel
  236. Lining up points
  237. import data from Word labels
  238. Combine numbers from sheets in one sheet witouth merging
  239. Drop Down Menu's
  240. Listing Duplicates
  241. Formula Question
  242. Finding first hyphen from the left
  243. Add color to field "if"
  244. Need help managing a list of data........
  245. Double lookup / match
  246. Blank Cells But Not Null Values
  247. automatic field entry
  248. Applying Formatting to Pivot Table
  249. if formula with range of cells
  250. Display text in cell in large format