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. Page Setup / Borders (re-post)
  2. macro help
  3. macro help
  4. macro help
  5. Change the Range refering to a Name
  6. Get value from Cell (after it is created by CountIF)
  7. Get value from Cell (after it is created by CountIF)
  8. Get value from CountIF
  9. Random select entries
  10. invoice amounts in 2 columns?
  11. Macro to cut/paste/delete
  12. vlookup for a range of data
  13. Line Wrap in Axis Tick Labels
  14. excell help
  15. how do i recapture unsaved excel data
  16. Dealing with automatic / manual page breaks
  17. HOW DO I IDENTIFY DATA THAT IS DUPLICATED IN TWO SEPERATE WORKSHEE
  18. Best Practice
  19. Pritning a selection of pages
  20. scrolling problem
  21. page printing
  22. formula date and time calculation
  23. Look up table
  24. Excel 97 Access Violation!
  25. Formula to sum two cell values
  26. Convertion of Excel sheet file to .txt file format
  27. How do I show Grid Lines on Worksheet in Excel 2007
  28. Putting Data in One Sheet
  29. Label's caption is not assinged immediatly..
  30. Naming Columns & rows
  31. macro of macros
  32. macro of macros
  33. macro of macros
  34. macro of macros
  35. Function to summarize based on 2 conditions?
  36. How do stop Excel changing column widths when doing pivots?
  37. Default Cell border colour?
  38. Automatically filling date of today (without it changing tomorrow)
  39. automatic time plans
  40. Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching?
  41. UK Date Format
  42. How can Excel make a cell empty without making it na()?
  43. 256 possible outcomes
  44. Saving worksheets using a Macro
  45. Text that includes data from a designated cell?
  46. validation list
  47. HELP on conditional formatting
  48. update
  49. Due Dates / Overdue items
  50. Removing file [Group] designation
  51. Need Comments list from Worksheet
  52. Keyboard question
  53. Count(if(A3:A200)>="100000" if (B3:B200="Y") and (C3:C200=Z)))
  54. printing a document print to fit whilst utilizing the whole page
  55. Lookup function gives wrong values occasionally
  56. protection in excel 2003
  57. Enter data in next available row
  58. How do I keep the selection box in the work area
  59. using wildcard characters for filenames in externally linked files
  60. convert numbers to time
  61. how do I merge data from separate spreadsheets
  62. worksheet tab text
  63. tab down instead of across
  64. Validation of results
  65. link dynamic data to cell?
  66. Save conflicts
  67. find a character and replace with a command in Excel
  68. HELP on "left","right","find","len","substitute" functions
  69. 3-D column graph
  70. Can I create a display box to see results no matter where I am in
  71. multiple values in one cell
  72. icons for embedded spreadsheets
  73. constructing array using non-adjacent columns
  74. Excel Repeating Formula
  75. Show centered text along merged colum cells
  76. how do I identify and highlight duplicate results in a work sheet?
  77. setting standard comment size for all rows in a worksheet.
  78. can autofill be used on merged cells?
  79. link to discussion groups
  80. How do I set up and use Month day, year format with other appl?
  81. How do I use " V Lookup" to transfer data to a new workbook ?
  82. Using vlookup when referencing text
  83. Worksheet says locked for editing by a user who is not in workshe.
  84. Find in a Grid
  85. Formula linking........Help!!!!!!!!!!!!!!!
  86. Turn off automatic change of mailname from salutation
  87. Excel
  88. multiple worksheets
  89. What Formula Should I Use?
  90. Grand total based on conditions within an array
  91. fomula needed to find the "new" time, for example if
  92. using dates and time in formulas
  93. Not sure what type of Formula to use...
  94. matching and deleting
  95. Error Message for Pivot Table
  96. shading used cells only
  97. Macro that deletes every third row....+
  98. Adding a 2nd row of sheet tabs to Excel 2003
  99. GetOpenFilename not returning a usable variable
  100. Troubleshooting my IF formula
  101. Dropdown list in PivotTable has deleted items. How to omit?
  102. How to convert time into seconds.
  103. Create a matrix from data in three column
  104. How to find the top 5% observations
  105. HELP...on my IF formula
  106. Standardize all cells at once
  107. Applying Formulas to Visible Cells Only
  108. A question for Match and Lookup
  109. Filtering
  110. how do I get a current time using =TODAY() instead of 12:00 AM
  111. Rounding numbers
  112. Using conditional formatting to "blank" cells
  113. Protecting Sheet and still allowing for sorting, filtering and formatting
  114. Array Formula w/ COLUMN & MATCH FUNCTIONS
  115. Insert | Name | Label
  116. How did you modify the Excel tournament template for fewer player
  117. Auto Filter and Quartile/Percentile Functions
  118. Set Limit for Line Graph
  119. how do i fill down a series of linked cells
  120. RE: A simple date calculation question.
  121. How do I stop excel from changing my ratios into time format?
  122. Y Axis Source Data
  123. Pivot table sorting, should be easy I think
  124. subtract
  125. subscript out of range error in excell
  126. Help with hyperlinks in pulldown list. Anyone know how?
  127. Question on IF's
  128. Tricky If statement involving dates and text - I'm stumped!!!
  129. paste to several worksheets
  130. Positioning all pictures
  131. Chart in a Shape
  132. Floating cell containing a "Running Total".
  133. checkbox and worksheet
  134. Recurring Titles
  135. Drop down list from filtered data
  136. Still need help with hyperlinks in pulldown list. Anyone know how
  137. can you automatically save files to two different locations?
  138. Macro sorting by 4 columns
  139. COUNTIF
  140. time question
  141. time question
  142. How do I set up a sheet showing tasks, progress, outcome, etc?
  143. A simple date calculation question.
  144. Excel 2003 - Getting links to stay live from Excel to PDF
  145. Can I recover a file I accidently wrote over via Save-As?
  146. Excel File Size Reduction Tool
  147. Vlookup
  148. Excel 2007 Beta-Named Ranges
  149. Delete duplicate values
  150. Cell Formatting w/following Macro
  151. Need2 batch print all the workbooks in 25 worksheets in one step
  152. Change the length of the page bar
  153. Conditions with IF statement
  154. random pick names from the list
  155. conditional formatting?
  156. copying table with cond.formating using value and resulting color
  157. How to get the pictures in my excel document to appear on web vers
  158. Formula to sum up data using "if" function??
  159. Does Excel have a linear interpolation function?
  160. Delete value but not formula
  161. Freeze panes
  162. Personal.xls sometimes does not open
  163. EXCEL PROTECTION 2000
  164. Bringing data in one sheet
  165. find a value at an intersection?
  166. Protecting a sheet and still allow some features
  167. how do you type a backwards letter in excel
  168. how do you type a backwards letter in excel
  169. Excel Logical Formula
  170. Columns & Rows ...
  171. Could not load an object because it is not available on this machine
  172. Graph with a mind of its own
  173. Worksheet Settings
  174. auto complete in list
  175. short cut to reach a sheet
  176. Can't keep my pre-selected layout???
  177. how you change font colour in header/footer?
  178. Validation Help
  179. Date Cell/ Format woes!
  180. 3 lates in any 35 day period.
  181. IF ISERROR
  182. can't read simplified chinese in excel
  183. Matching more than one cell
  184. how can I select a range of cells based on a value of a cell?
  185. Copy result from sheet1 to sheet2
  186. Can't use Find function in formula
  187. Please help me on IF function
  188. formula to match a range(sort) so it matches an external column
  189. Missing Autofilter option !!
  190. Excel 2003 Hiding #DIV/0 in Data/Subtotal/Avg result
  191. Copying data to multiple worksheets by Macro
  192. sound alert from excel
  193. Sorting Data in a Pivot Table
  194. Executing macro in one book from another.
  195. Can't get into Excel. An error won't let it open. Help
  196. exponential numbers in cells
  197. MATCH & COLUMN Functions
  198. Mutiple Excel Windows.
  199. file font colors
  200. How do I link data from 11 workbooks to 1
  201. Importing modules from a folder
  202. I would like to give a key an other task, is it possible? THANKS
  203. get URL from HyperlinkCell
  204. Need to total how many came from a particular group.
  205. Where is the location for backup files
  206. only want formula to show up if a1 is not blank
  207. how to make the rectangular cursor box in blinking mode?
  208. Unexpected error occured. - MS Excel
  209. Finding source of linkied Database??
  210. Interpolating an x, y point from known x's and y's
  211. Cells not summing up correctly
  212. how do i make a formula with varied discount percentages
  213. Excel 2007 Beta Cut and Paste
  214. Inputting data to one worksheet for it effect another
  215. auto sort
  216. How do I make 2 cells become one without changing column size
  217. how do i set a formulas with two conditions using countif
  218. Range? M1:Z1
  219. HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
  220. Average using lookup function
  221. combining text & number from different cells
  222. Open File within a macro
  223. enter text below table
  224. how do i select all the visible cells only when using auto filter
  225. find value in array on sep sheet & ret correspond val from col lef
  226. link a entire line in Excel to a spreadsheet I sort?
  227. Protect formula
  228. Percentage Increase/Decrease
  229. combined scatter plot and line data
  230. Disable Auto save on Right Click
  231. Make a negative response to if question equal zero
  232. slide vertical text? linking to 1rst row in the screen? open in the last edited row?
  233. Countif in non-consecutive cells
  234. 4, 5, and 6 digit numbers should be text
  235. Two Groups of Option Buttons on Worksheet
  236. Charting labels question
  237. In-Doc Hyperlink ANSWER maintain lines from Cut-Paste
  238. help with sumproduct
  239. Cell references stopped working
  240. countif not working
  241. Imported Text from two HTML tables looks same but is different
  242. Call Center Management: How to calculate 'cost per call'
  243. need to add a group of cells if greater than 30 and less than 60
  244. convert a document to one column
  245. reformat a cell from last name, first to first space last?
  246. Named Cell issue - dangers of cut and paste
  247. Formula help
  248. Hiding text in a chart
  249. Number custom formatting
  250. Custom fill series?