PDA

View Full Version : Excel General


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

  1. Compile LIKE data from multiple worksheets into one worksheet
  2. Selecting & Highlighting one cell checks another cell
  3. conditional formating to another worksheet
  4. Separate large excel sheet into groups of 250.
  5. add 1 to a cell when a another cells reaches a certain value
  6. Return column header of first instance of a value in a row...
  7. Setting Initial Date
  8. Sumproduct formula
  9. Keep 1 portion of a previous cell but change another...
  10. 2 separate drop downs for data
  11. Function along with text in the same cell
  12. Importing Mulitple Text Files into their respective Cells
  13. Displaying top ten
  14. Have Excel automatically enter data
  15. alphabet lines
  16. sorting out data
  17. stop e-mail adress becoming hyperlink
  18. time duration chart
  19. Print border around printed area
  20. count unique cells
  21. #REF! error when deleting row in Checkbook Register Application
  22. order lines in decresecenting classifitcation and sum the 5 biggest
  23. Countif for a workbook?
  24. drag formula
  25. Rows and Columns
  26. LOOKUP Functions
  27. Exam assistance - Printing
  28. auto input weeks?
  29. Functions no longer auto updating
  30. Date format
  31. Relative linking to another document from a spreadsheet
  32. take cells from excel and then format them in a word like document
  33. two cells to be joined but each cell in next line
  34. Filtering a lot of data
  35. VBA code (DATE)
  36. setting size of worksheet
  37. arrow keys alter content when exiting cell
  38. How do I adjust this view back to normal?
  39. Excel Special Paste Formula is decieving
  40. Using Multipage
  41. Automate a single form to be sent to 300 people
  42. Execute a formula Indirectly
  43. Have top rows not comply to column width format?
  44. hidden macro affects how other files open
  45. Comparing & Sorting
  46. vlookup
  47. Formula to work out UK Tax deductions?
  48. match cells of column A and B.
  49. similar formula copy
  50. sorting assistance
  51. Excel 2002 file start up problem
  52. Data groups on protected sheet
  53. date Format
  54. Macro to fill formula
  55. How can be made this spreadsheet more design appealing
  56. Validation List error
  57. Add specific rows if cell value = X ??
  58. Index formula
  59. Column data shows as formulae
  60. first letter of every word with a . afterwards
  61. Cell Format 0:00
  62. Column heading printing
  63. create a list of vendor payments
  64. Converting Military Time
  65. Freezing rows
  66. Decimal Display
  67. Calculating grand-totals using numerous sub-totals in seperate coloumns.
  68. Import and export a text document
  69. Refresh Pivot Table
  70. AUTOFILTER between sheets
  71. Fixing the value of a cell upon first data entry
  72. Pop up on exit
  73. Sharing Excel Sheet in Network
  74. Data Validation Refusing to Work
  75. Pull Down List
  76. Drop down boxes and Named ranges
  77. Printing with pages numbered from the bottom of the spreadsheet
  78. count rows with 3 criteria?
  79. Sort Rows With Linked Textboxes
  80. Filter same names
  81. Win-Loss Sheet
  82. If/else Function
  83. Currency Formatting
  84. Lookup with updating data?
  85. creating a form
  86. Value error when totaling (if(isna formulas
  87. how do I change hours and minutes to hours and tenths?
  88. running an executable in excel with cell reference
  89. Sumproduct function
  90. Trying to find inconsistencies between two sets of data (2 columns)
  91. "Format"? Problem with thousand separator
  92. cut and paste multiple columns into one?
  93. End a spreadsheet
  94. Is It Possible?
  95. find, replace with strikethrough
  96. Auto sorting & Filtering
  97. Create separate sheet for each PageBreak
  98. Formula required
  99. dates based upon every Saturday
  100. Hyperlink Changing Mapped Drive
  101. autosum is not working
  102. Default How to find duplicate entries?
  103. Custom Printing from spread sheet
  104. Create Dependent Lists
  105. count if
  106. Filter Problems
  107. Excel shows altered/repeated content in cell
  108. Using Autofilter to Sort Date Range?
  109. subtracting in excel
  110. Capturing a changing cell value
  111. Tools Menu Bar
  112. Problem Opening CSV in excel
  113. Permuation of 4 digits but not equal to input
  114. Do you have problems with Vista?
  115. Counting cells
  116. Compressing/Uncompressing Views moves Print Area
  117. Compare Ranges/Return Specific Value for Matching Cells
  118. Using text to columns for more than one column
  119. CTL - deletes row but moves to cell, need shortcut for more delete row only
  120. Count each time a word is used throughout chart
  121. Import A SQL Dump Into Excel
  122. How do I use Alt+176, Alt+178 & etc
  123. Excel Applications - advise required...
  124. Lookup Query
  125. Tab throught unlocked cells
  126. record sickness form a register
  127. Want Modification in MAX and COUNTIF formulas
  128. document recovery
  129. Function stops working?
  130. Data Validation and Indirect Function
  131. protect formula but allow data entry in other cells?
  132. Data Filtering: uniqueness one column only?
  133. continue a list on right side of each page...
  134. Question - extracting a number surrounded by text
  135. Conditional Formatting for formulas
  136. On B3 a formula is used, what it means, ??
  137. change a cell depending upon the content of another cell
  138. converting 20071231 to 12/31/2007
  139. Problem with .Visible and Screen View
  140. Autofill problem
  141. Simple Procedure
  142. if function
  143. specific information in columns
  144. finding largest gap within 9 rows
  145. formula
  146. Why does it print differently than my screen shows??
  147. link the spreadsheet to the database where it can auto-populate and refresh
  148. Calculate cell if number [not text]
  149. Wierd - last digit gets changed to zero
  150. Excel Sorting Problem
  151. How do I make Excel stay in Full-screen ?
  152. Formatting a schedule
  153. Date format
  154. Excel 2007 - Fill down for visible cells only (CTRL - D)
  155. Mirroring from other worksheets
  156. If Iserror
  157. Adding(Append) fix string before a particular cell
  158. Moving data from multiple cells to a new cell
  159. How can I hide Column and Row references
  160. Printing Text Boxs from 2007
  161. Problem with colour palette
  162. File Size??
  163. Compairing Data
  164. How make linebreaks without turning on Word-wrap?
  165. Excel auto changing format?
  166. Sorting problem
  167. Append multiple worksheets into single worksheet
  168. duplicate lines
  169. Excel auto changing format?
  170. Single Row Table-entry
  171. Making graphs,
  172. How to repeat column headings on sheet 2
  173. help.....
  174. Can I hide Row numbers and Column letters
  175. How To Update Single Cell, Not All
  176. Create drop list jump to reference cell
  177. Convert month to number
  178. can u name a collapsing + & - in a column?
  179. Log of Tangents
  180. lines of text in one box?
  181. When Print Large "2/" and "/4" appear over data
  182. Fractions with Denominator Greater than 999
  183. Excel 97 formula doesn't work in Excel 2007
  184. Collapsing Columns?
  185. very green
  186. Elapsed Time
  187. Sort defaults not saved
  188. Sort works but with mistakes.
  189. Unusual UDF Behaviour
  190. MSQuery into Excel 2007
  191. cleaning excel columns
  192. How to transmit data?
  193. Problem with minus function
  194. adding space in between rows
  195. Count B1:B12 If A1:A12=12
  196. Refering To A Cell In A Future Workbook
  197. Automatically Number cells
  198. copying pattern from one column to another
  199. How to remove the vertical scroll-bar?
  200. Carriage Return in cell
  201. Auto Numbering a Tag name
  202. Combo Box
  203. Ten rows in column A, Twentyone in column B?
  204. Partlist Generating Problems
  205. Drop Down list within a drop down list.
  206. Sumif, Offset, ComboBox
  207. Trouble with my assignment
  208. Conditional formatting based on time
  209. conditional value
  210. exclude certain letters
  211. Conditional copy
  212. Adjusting the width of a group of column at the same time
  213. Sending Excel with only values
  214. count odd rows
  215. calculating delay question
  216. Pasting Without Deleting Previous Data
  217. number <10 results in several #num #value
  218. can I refer to a file for a drop down menu?
  219. Excel Setting - importing files from Trendstar
  220. Multiple values
  221. count no of due days covered between 2 dates
  222. Entering Constant Text for X number of Cells
  223. Microsoft Excel 2007
  224. Excel 2003 - formula returns error when i copy a worksheet
  225. How to prevent copying of excel files?
  226. Graphing with a formula
  227. expression comparing past/current doners
  228. conditional formatting - dates
  229. If Formula
  230. Excel wont 'interpret' my concatenated string as a Label
  231. Hiding color-specific rows
  232. Count filtered items
  233. Excel 2007 Default number format
  234. custom buttons
  235. Average not calculating N/A calls
  236. Condensing Info question
  237. Formulas - If statements
  238. How do I remove extra "returns" from a range of cells?
  239. Use data from another excelfile
  240. Copying formulae down.
  241. Referencing a filename in a cell
  242. Removing Duplicate Values Only
  243. create an IF statement on date (given range of dates-does it fall on this date?)
  244. LOOKUP error???
  245. data entry reallignment.
  246. Creating and Vieweing scenario using box or combo list
  247. pop up messages
  248. displaying formulas
  249. Percentage Formula Needed
  250. clearing data in a cloumn