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. Please View - Need Help VLOOKUP
  2. Formula for cells
  3. Protecting Workbooks & Worksheets
  4. Pivot Table Drop Down
  5. For Excel pros
  6. Worksheet Reference
  7. Find first empty cell
  8. INDIRECT(ADDRESS(.....) / recalculate issue
  9. Quickly Update Exact Values
  10. *****Conditional Formatting PLEASE HELP*****
  11. Substracting a fixed number of hours to a time
  12. Sorting data into different format....
  13. Cell colours (Excel 2000)
  14. sum an unknown column with a known column
  15. Validating by list for lookup
  16. Displaying Ratios
  17. Lookup/Search list
  18. Searching Excel Sheets
  19. =IF/AND/VLOOKUP Query
  20. unable to copy the data from Excelsheet byVBA Macro
  21. Macro To Copy To Last Cell In A Row
  22. Using Excel as Contact Management DB
  23. Random Sort
  24. Value of Cell increases with Date
  25. Random Winner Draw Formula Help
  26. Printing multiple charts
  27. Run Macros when work book is protected and sheets are protected and hidden
  28. % of Increase - Decrease - Formula
  29. What is ISERROR
  30. What is the purpose of IF
  31. Please Help
  32. Printing Troubles
  33. files opening automatically at boot up
  34. Meaning of formula
  35. trying to eliminate cut/paste for this scenario
  36. How to Filter this?
  37. adding #s from different sheets in same doc?
  38. Multi-variable Solver Issue
  39. Need help figuring out a formula...
  40. Updating multiple workbooks / Template
  41. help for counting
  42. rearranging ?
  43. Singling out a value
  44. Range selection
  45. vlookup or any other function?
  46. Sumif
  47. Short Cut Keys - Anyway to restor or change plz
  48. turning a minus into a plus
  49. Auditing functions "greying out"
  50. Coverting the time zone
  51. Colour Worksheet Tabs in Excel 2000
  52. Exporting cells to text file
  53. URGENT: formula sheet?
  54. Attached a Macro to Button
  55. But there are no macros!
  56. Sort Indicator
  57. VBA Lookup problem...
  58. Count Problem
  59. Date search
  60. copying data to relevent cells
  61. Excel warning message
  62. Odd Date Problem (US vs UK Formats)
  63. Values for Width & Heigth of Bar Graphs
  64. Automatically Update An Inserted Object
  65. Linking worksheet information
  66. sales forecast and arrears
  67. Help with =if(or
  68. Password Protected
  69. Excel VBA - Range variable
  70. 24+ time recording
  71. Read only problem
  72. number of days between 2 dates
  73. Repeat Data Help
  74. Array formula?
  75. faster way to get to result - formula/macro
  76. Fill the next available cell w/Data from 2 WB's
  77. Help w/Row Delete
  78. What does $ mean
  79. How do you enter a Carriage Return in a cell?
  80. pivot table output
  81. How to determine the value from formula
  82. Break Downs Numbers (code or formula)
  83. formula to delete all but the last 3 characters
  84. How do I find my posts?
  85. hide formulas and display values
  86. If
  87. This file is not in a recognizable format
  88. Specifying Cells by using Expressions/Variables
  89. Shading cells depending on formula result
  90. Dropdown doesn't work from 2000 to 2003
  91. Creating one list from another
  92. Help with syntax of if/and statement
  93. error
  94. using the "PROPER" function
  95. Dates showing as serial
  96. Lookup last cell
  97. Print Macro
  98. newbie learning excel
  99. Daily Updating an Excel from another whose name Changes daily
  100. prepending text and other manipulation
  101. Print two pages to a sheet
  102. filter by last row with data in it
  103. Conditional format of a lookup result
  104. End of financial year from Today() formula
  105. Error Messages
  106. Protect Workbook
  107. Reading and counting cells with certain values
  108. Index
  109. Seperate numerous cells into a common cell.
  110. Produce trends from data at different elevations
  111. Identifying Decimal within String
  112. Custom Sort
  113. Yet another formula problem
  114. Automatically/Immediately Update Workbook
  115. printing and page break question
  116. Splitting a Postcode
  117. converting hours to a form that can be multiplied
  118. Automatic Labelling of User Forms
  119. Date and Month Links
  120. How To?
  121. Duplicates
  122. Immutable Cells
  123. Looking for Techniques to deal with Rounding Errors
  124. Linking Data from a number cell to data cells on another sheet
  125. Query to check if something is LIKE, CONTAINS or STARTS WITH
  126. Freeze pane
  127. Can Excel display an animation upon opening?
  128. help showing hours and minutes
  129. Changing Qualitative Data to Quantitative Data
  130. Automatic sorting
  131. capitalisation of cells
  132. Nested IF Statements Linking Problem
  133. Date format, VBA, and TXT/DAT
  134. Macro To Add New Worksheet
  135. Column progressing by change in one reference cell
  136. Help for Excel Beginner
  137. Help to Wrap Text in a Merged Cell Excel 97
  138. Copying a formula down...
  139. Football!!!!
  140. Charting with secondary x axis
  141. HTML and Excel
  142. Excel exponential notation problem
  143. Cell (raw) auto height for wrapped text in 4 merged cell.
  144. Leading Zero (kind Of)
  145. Need help with "if" and "or" formula
  146. SUMIF - real simple problem... But does NOT work :-(
  147. find and replace multiple values
  148. Formula in format cells-->category-->custom? or alternative?
  149. Editing Cell contents
  150. Date difference
  151. If highest figure is in one cell, display info from another
  152. macro that filter not by the column number but by the cell name
  153. How to change color of a row?
  154. Column Sorting
  155. SUMPRODUCT and text in cell
  156. Lock Sheets On A Spreadsheet After A Certain Date
  157. Populating Data
  158. formating text and background colour
  159. macro to delete last 5 rows
  160. Help Plz with data and getting rid of '
  161. Corrupt "IF" Formula
  162. Looking for "delete empty lines" function
  163. VLOOKUP, "reading" text within a cell...?
  164. Auto overtime pay. There must be something better than an IF formula
  165. outcome is conditional to::
  166. Conditional Format using remote cells
  167. Pivot Table Auto Updation
  168. How to change cell reference in a HLookup when copying formula vertically
  169. Holiday Chart
  170. HTML Formatting in Excel
  171. comment boxes changing size
  172. How to get rid of extra ThisWorkbook
  173. import data.xls to an existing excel file
  174. Convert Day, Month, Year, Hour into One Value
  175. Macro help
  176. border problem - please help
  177. varible print range
  178. Text data concatenation in Pivot?
  179. How to?
  180. Formatting Dates from yymdd to mddyyyy
  181. Cell References in a Formula
  182. Sum Problem
  183. Problem Automatically Importing Excel Graphs into Powerpoint.
  184. Spellckeck protected worksheet
  185. Delete Duplicate Rows
  186. Shortening formulae
  187. Conditional Formatting, pls help
  188. Excel crashes when code runs, Please help.
  189. Many Ols Regressions on Many Columns of Data
  190. Custom Cell Formating with a "-" in the middle
  191. To localize greatest value in long rows
  192. Displaying and using numbers in hexadecimal
  193. Countif
  194. formula question
  195. Incrementing by more than one row
  196. Macro to Un-hide Rows
  197. permanently expand menus
  198. Need to automate this manual spreadsheet -- pls help
  199. Bolding part of text in a cell when...
  200. Summary
  201. formula to just show numbers?
  202. Button Linking to different sheets
  203. Excel Align equal values in adjoining Columns
  204. extract relevent data information in other cells
  205. Validation by Total Amount
  206. auto save
  207. Copy And Paste To New Workbook
  208. Data Validation by day of week
  209. Time Formula?
  210. Very bizarre behavior
  211. Return in Code
  212. need help with conditional formatting
  213. Running a macro
  214. Data updates on a sheet but the graph does not.
  215. combining 2 cells
  216. Office 2000
  217. Average Product Cost
  218. Just a couple questions....
  219. How to start a graph from 1 - not zero?
  220. Trimming cells
  221. tax templates
  222. Protecting pivot table
  223. data filter
  224. How to come up with a total by using different names.
  225. New User: how do you do this
  226. rent vs. buy spreadsheets
  227. A wacky solver constraint
  228. Vba 101
  229. how to know of more than a result in a row
  230. Help looking up multiple values
  231. Listing data from another workbook
  232. Nested If Statements
  233. Drop Down Lists in Excel 2003
  234. How to Divide Sequential Dates in Month by Number of Cells Chosen
  235. Prolem with If and V lookup
  236. find the last cell with a value greater than 0
  237. Sorting in Address column
  238. duplicate formule with value change
  239. binary conversion
  240. Share a textbox on a userform in a shared workbook
  241. Unable to scroll to the right/left
  242. Complicated date formula in a office planner!
  243. Counting blank fields in Excel.
  244. Randomly relisted a group of names onto another Book
  245. Temporary Archives Listing
  246. Temporary Archives Listing
  247. Temporary Archives Listing
  248. Value Statements in Excel
  249. range to move up one row
  250. csv file had 6 columns, now data is in 1 column separated by comma