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. Cell forumula, for changing pipeline cell linked to another file...
  2. Text in one cell depending on data a number of other cells
  3. Date info not in correct order
  4. auto date entry
  5. To Many Cell Formats
  6. Split Cell Format
  7. How to disable worksheet links???
  8. Newbie In Trouble
  9. Duplicate data
  10. Automatic updates to my billing spreadsheets
  11. Updating spreadsheet
  12. masking..i think thats wot its called
  13. Lookup Labyrinth
  14. Excel won't open fully
  15. Cash Budget Question in relation to Excel
  16. To add a IF empty give a message
  17. Version Control?
  18. Additional Columns Needed
  19. Unable to open multiple workbooks
  20. multiple if statements
  21. Compare columns and deleting multiple rows
  22. Auto-Calc Problems
  23. Find names not in defined range
  24. Date Formula
  25. Making a hyperlink show a specific section of the worksheet
  26. date format in Excel sheet!!
  27. Forgotten Password to open workbook
  28. Lost file due to Save As
  29. Locking Forulas to look at target cells
  30. Showing names not on a list yet
  31. Consolidating column data and removing a list of data from a list
  32. Multiply a certain percentage in Excel
  33. Sharing Excel
  34. Combo boxes
  35. Collecting Data Within a Range
  36. Pivot tables not refreshing in shared workbooks
  37. Can you divide up worksheets into subsections?
  38. Plotting #N/A
  39. Problem with formula
  40. My data sheet in empty but data are there
  41. Keeping formula based cell blank
  42. 'Enable Macros' message with no macros
  43. Hyperlink font format
  44. remove repeated lines
  45. Populating a Master List
  46. Need Help Formatting Results
  47. Time Cells Combining
  48. Paste into filtered worksheet?
  49. IF AND statement
  50. File size grows to unrealistic proportions
  51. Transpose values ???
  52. automatically add days to a date
  53. very strange behaviour of data tables (BUG perhaps???)
  54. Issue with comments moving ( changing cell location ) on their own.
  55. Parsing out a word after a character (#)
  56. Automatic Column Selection
  57. IF, THEN and Checkboxes..
  58. adding with getpivotdata
  59. holiday/work rota
  60. Delete everything after specified char
  61. Can't navigate with "arrows"
  62. Incrementing Formulas and Multiple Rows
  63. Folder options
  64. How to have the average without empty zone
  65. Calculate days between dates but...
  66. Sum of (If match in one column then take value in another column same row) - Stumped!
  67. counting data
  68. Adding 0. in front of numbers
  69. Keeping the same .txt format?
  70. Count Or Sumproduct Problem With Years
  71. update A .xls to B .csv conversion...
  72. Always "Shrink to Fit"
  73. Business Functions for Excel
  74. Copying a column of data into a row
  75. Leading Zeros In Zip Codes
  76. classify days in rule
  77. Finding the max date in a subgroup of a long list
  78. Displaying only the month of a date...
  79. Hot to unlock file that indicates incorrectly it is in use
  80. Sorting question
  81. Vlookup within a Hyperlink
  82. If and statement
  83. Excel acting strange
  84. Cell merging?
  85. excel 2003 selecting only one check box
  86. Excel spell check issue or?
  87. IF Formula is not Dynamic
  88. Recordable Cells
  89. How to work with combobox
  90. Excel Sudoku Programming
  91. Auto Save
  92. Using sum function
  93. Converting .xls files to a list divided by commas
  94. Horizontal Count
  95. Listbox or Combobox dividers
  96. Mass Deleteing Inputs
  97. Compare two sheets
  98. Advance File Search Excel 2007
  99. Calculate maturity date on loan
  100. How to arange and count various numbers in previous column
  101. Trying to order cell contents
  102. getpivotdata bug?
  103. Creating a Customer List
  104. subtract dates in Excel, but one is not in date format.
  105. Quotation mark (") conversion
  106. NA for cells with text in!!!
  107. multi lookup
  108. help running/cumulative total
  109. Fill cell with random cell?
  110. calculating time...
  111. ####### Showing up in the desired cell after completing an expression
  112. Auto populate spreadsheet
  113. Countif formula
  114. Automatic entry in a cell
  115. Advanced Filter: Having some trouble
  116. Duplicate
  117. Problem with Paste Special - Formulas
  118. How to import randomized Access data?
  119. if statement
  120. producing a list from data from another worksheet
  121. The Wrap Cell Function
  122. Question about values in cells and how to use those to make graphs
  123. How to activate/de-activate a cell based on the selection of a check box
  124. Linking Cells on a Seperate worksheet
  125. Autofilter Question
  126. selecting non-blank cells
  127. Deleting blank cells
  128. Data Validation
  129. Simple but frustrating problem with chart
  130. Storing values in specific cells (Excel 2003)
  131. dynamic list
  132. space as a separator
  133. Transferring Data/Auto Sort
  134. Help with dll file
  135. Sum up two diff values
  136. copy references into Word without cells
  137. Am I being rip off?
  138. summing
  139. PDF or Word to Excel
  140. pop-up window to do calculations
  141. bringing items over from excel spreadsheet
  142. R/L arrows are paging up & down rather than moving cell to cell
  143. Addition of Columns
  144. Countif
  145. Formula Question
  146. protecting cell-backgrounds
  147. N/A in xsl
  148. Compare and sort 2 lists.
  149. 'time sheet'
  150. Copying protected worksheet
  151. Lookups and sums
  152. Copying data into another column but without blanks
  153. How do Ifind outliers using the descriptive statistics?
  154. Unique ID's
  155. Changing the width of ONE cell?
  156. Restoring interface font to default
  157. Pivot table show all
  158. Sorting question
  159. printing an Excel table in Word
  160. number field won't except zero
  161. Too much data in a single cell. How to search/output specific data from each cell?
  162. Excel problem (not spreadsheet problem)
  163. Countif
  164. Duplicate Problem
  165. Too Much Data per cell, how to sort and find info per cell? =function?
  166. Function COUNTERROR
  167. Password Protecting Only one Worksheet
  168. Copy Hyperlink to Another Spreadsheet
  169. Filling formulas in added rows
  170. using norminv for a stat function
  171. searching within a range
  172. merge two cells of data to one cell
  173. Hiding rows
  174. Grouping and Protecting
  175. Summing the values once from a list
  176. Can you install two Excel versions?
  177. Protecting Comments
  178. Convert Date format
  179. Extract file names from folder`
  180. dynamic named range
  181. data entry
  182. how to chenge to hollydays!
  183. Make cells equal 1
  184. Random Placement whilst fitting constraints
  185. Are and Cells in Range Errors
  186. Formulas cease to work on a different computer
  187. Annoying warning message
  188. Formula for Roster
  189. Formatting telephone numbers as text
  190. Stop text overflow into next cells?
  191. display cell data in relation to previous cell.
  192. Australian Wage calculator with weekly tax payable.
  193. Changing a roster on a weekly basis
  194. making a tick box column
  195. Subtracting to a blank cell
  196. Time Calculation
  197. weighted Sorts
  198. Replicating one cell, including format
  199. Picture Resize/Placement Problems
  200. Locked cells after pasting
  201. keeping previous data from linked cells
  202. modify formula whiel copying to below cell
  203. Add defined value to cells
  204. Unwanted date format
  205. How to avoid the value "0" in a cell...
  206. reversing digits
  207. calculating different out comes
  208. Cell Formula
  209. Cond Formatting 2
  210. Controlling mult. instances of Excel on startup
  211. Image as water mark
  212. Superimposed histogram A on histogram B
  213. lookup question
  214. Size of Excel with PDF embed inside ?
  215. drop list
  216. =now()
  217. Extract part of a string
  218. Validation etc.
  219. HIGH of the variable
  220. Sort button not available
  221. validation list/ worksheet protection
  222. Link to another cell
  223. Excel won't shut down
  224. Value lookup and replace value with a name
  225. Refering Text box content in a formula
  226. Role Based Security in Excel
  227. Using Excel for Multiple Inputs
  228. Excel a Process called CKS282F.TMP is running in the Background
  229. Matching list to each category
  230. Show last text in cell
  231. Extract files from a folder using path+file list in Excel
  232. Auto Populate Rows and Column
  233. 2 or more If functions
  234. divide by zero error
  235. Grab data from another workbook
  236. Trace dependent does not work, trace precedent does
  237. calculate months
  238. problem with scientific notation
  239. How do you stop excel removing leading zeros?
  240. Comparing Two Spreadsheets?
  241. DataType
  242. Fails to calculate pages to print
  243. Pivot Tables
  244. Cond Formatting
  245. Lock formula entirely
  246. Automatically clicking on URL formula cells
  247. how to merge excel workbook
  248. Qustion On what to use...... and how to use it.....
  249. Monthly dates formula
  250. Conditionnal format question on 2007