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. [SOLVED] Counter for (active) sheets
  2. color counting
  3. Cell look-up
  4. Need Running Totals in columns with possible corrupted data".
  5. Deals with spaces
  6. How to imput cell data/text by clicking in cell
  7. Design problem
  8. formula to match
  9. icon sets
  10. [SOLVED] Combining cell values?
  11. [SOLVED] Longer text entry turns into ####..
  12. DCOUNT or countif Formula
  13. sorting a sheet with two header rows
  14. Problem with external csv file updating
  15. [SOLVED] increasing numbers in each new cell
  16. Create a clickable "counter" to increase number in increments of 1?
  17. [SOLVED] calculate the quantity of each size of an item
  18. Multiple Copy and Paste with Adding
  19. Default Date Format
  20. Including a "+" for Percentage Increases
  21. How do you pull data in lot form?
  22. [SOLVED] First Initial Last Name
  23. Problem with Array formula
  24. Apply Formula to a Whole Column
  25. Inventory Style Questions. <100 when >100 and Pulling from 2 Books
  26. Incrementing Rows in Excel
  27. Adding Names and showing on all sheets
  28. XLS vs. XLSX
  29. [SOLVED] Calculate differently based on value
  30. [SOLVED] Excel cannot complete this task with available resources.....
  31. Trailing minus
  32. AutoRecover Failing in Excel 2003
  33. [SOLVED] Possible match vlookup query
  34. Array Formulas
  35. [SOLVED] On click, copy
  36. Auto Correcting Formula
  37. Adding additional rows & auto-applying formulas
  38. Finding "spend" in mulitiple columns
  39. How to create Drop-down list
  40. want to create List
  41. Value of random cell
  42. Transferring data from one column to another based upon a variable.
  43. Calculate hours for concurrent tasks
  44. How can I input a formuale with a condition?
  45. Query multiple columns for strings and grab value from different column
  46. Vlookup
  47. Sheet Name in Cell
  48. Can Excel determine if a folder exists on the server?
  49. print a booklet of 8 sheets with the final page different for each one
  50. [SOLVED] Change Dates to text
  51. Pivot Table Filter Refresh Issue
  52. Using SUMPRODUCT on several sheets
  53. [SOLVED] Incrementing a cell reference
  54. Turning a column of numbers into %
  55. [SOLVED] Add percentage to numbers
  56. [SOLVED] First Name to Last Name
  57. How to convert euros in pounds
  58. [SOLVED] Greyed out pages
  59. [SOLVED] Average Data In A Column
  60. Timesheet for Excel 2007
  61. [SOLVED] capping amount in formula?
  62. [SOLVED] Keep columns on top
  63. Append data to a cell in 2007
  64. [SOLVED] Sum across Sheet Tabs
  65. [SOLVED] Add Cells with Color only?
  66. Rearranging data
  67. Linking Specific Spreadsheets to Word Document
  68. Making drop down menus from imported data
  69. Listing Multiple Combinations
  70. Printer Pref changes when 2007 loaded
  71. [SOLVED] IF does NOT equal formula ???
  72. [SOLVED] Radio button alert
  73. replacing formula with result?
  74. Where to go for info in regards to which formula to use
  75. Internet Explorer opening Excel files
  76. [SOLVED] Connecting two sheets
  77. connect 2 columns
  78. Aging report
  79. Hyperlinks in lists
  80. Merging Cells below each other
  81. button background
  82. [Solved] Advanced Excel formula question
  83. Listbox Problem
  84. [SOLVED] Autofit all columns
  85. [SOLVED] Nested IF formula - problem
  86. aligning text ... i.e. removing blank cells
  87. [SOLVED] IF formula - Skip rows that dont meet criteria
  88. SUMIF Date / Average Help
  89. [SOLVED] Conditional linking between multiple sheets
  90. can a Cell be made active?
  91. Graph plot
  92. Using TODAY() in IF function
  93. How do I import a pdf?
  94. Append date of last edit to cell
  95. date range
  96. data validation on other sheets
  97. [SOLVED] If/then formula
  98. [SOLVED] Incrementing the date
  99. [SOLVED] Tab name to be header for print page
  100. [SOLVED] Auto Generate Passwords
  101. integrate excel.
  102. Simple Copy Paste Question
  103. [SOLVED] Drop down not recognising
  104. [SOLVED] Combing 2 cells into 1 but using a fraction..
  105. [SOLVED] Calculating Difference Pivot Row
  106. Mergefield character limit
  107. Auto save HTLMs from list in Excel
  108. #NAME Error when entering formula
  109. Cheeky Charlie
  110. Formula questions
  111. Nonlinear equations
  112. [SOLVED] Changing Colour of the Border of a cell
  113. suggested function?
  114. conditional formating
  115. Cell splitting
  116. [SOLVED] Floating First Column in a spreadsheet
  117. Help with sorting a CSV Bill
  118. [SOLVED] COUNTIF, SUMIF or SUMPRODUCT ???
  119. Product key but no cd - how do i obtain new cd?
  120. Re Format Bad text
  121. [SOLVED] Sorting multiple worksheet tabs in alphabetical order
  122. filter list first by one column, then by unique values in another column
  123. [SOLVED] Copying a date through multiple sheets.
  124. [SOLVED] double inequation
  125. row contents into first cell
  126. Date ranges intersection
  127. Excel to MDB Creation with Photo Field
  128. Protected cells once saved
  129. Calculating a Rolling Date
  130. Repeat data sorting
  131. Combobox
  132. Removing duplicates for dependant Listboxes
  133. Arranging Data into different sheets
  134. Convert text to upper
  135. Failure to fully open
  136. Using reference sheet to import data.
  137. vlookup returns #N/A
  138. Lookup multiple instances and display in columns
  139. Product Display Schedule
  140. [SOLVED] Drop down lists to reuse
  141. [SOLVED] vlookup keeps returning #ref
  142. [SOLVED] I've lost my page view, only shows in print preview?
  143. Urgent Help Needed!
  144. [SOLVED] vlookup to stay blank if nothing selected
  145. [SOLVED] making sure cell has j prefix
  146. Removing first 2 characters in a column.
  147. Filtering by a set
  148. Where is the Web Form Wizard in XLSX format?
  149. Totalling values in cells adjacent to a list
  150. [SOLVED] Default to specific worksheet upon opening workbook?
  151. Copy Paste large columns
  152. [SOLVED] different password to unhide the hidden sheets.
  153. Retrieve data from two sheets and calculate
  154. PDF-like wordprocessor with straightforward data import to excel?
  155. Cell Formatting
  156. [SOLVED] what its called when you have drop down menus that correspond with other drop down me
  157. Automatic popluation of a table taking specific info from other sheets
  158. [SOLVED] max / min excluding zeros
  159. excel dashboard?
  160. [SOLVED] Calculate Days Between a string of Dates
  161. [SOLVED] text box function won't work
  162. [SOLVED] Counting the number of times a date appears in a list
  163. Converting text to number from an MLS (Multiple Listing Service) search
  164. Excel and AutoCad
  165. List of variables
  166. vlookup with numbers
  167. Seeking Information Formula for specific logic
  168. Qustions about "COUNTIF" and "SUMPRODUCT"
  169. Need Max and Min for each day in 2yr period
  170. [SOLVED] Show contents of vertical cells in horizontal cells
  171. [SOLVED] copy formula horizontally across rows
  172. Inventory sheet
  173. Display Values of Column/Range/Array/Other
  174. Hyperlink not auto updating
  175. [SOLVED] Leading Zeros
  176. [SOLVED] Seriation Graphs
  177. [SOLVED] Calc with cells
  178. Finding the Nearest Value in a What-If Scenario
  179. Macro Problem
  180. [SOLVED] finding trends in multiple rows
  181. Worksheet formulas
  182. [SOLVED] Word / Excel Help
  183. Karaoke book using Excel
  184. Tracking Changes
  185. counting letters and numbers
  186. Relative References Not Updating Properly
  187. [SOLVED] Copying Data Via A Macro
  188. disabling a cell
  189. Multiple Sort a group of cells on same worksheet
  190. row height problem
  191. [SOLVED] Returning the displayed text of a date cell
  192. Currency Conversions
  193. Shared workbook with mysterious checkbox, button resize & missing formula returns
  194. [SOLVED] Lock workbook name
  195. Select and Display latest date items only
  196. Running VB code in excel from web page
  197. Issue with links error
  198. Spreadsheet Security
  199. [SOLVED] Conditional Sum to match against drop down list
  200. Vlookup forumla not working
  201. Add column beyond Col IV
  202. how can i active macro tools
  203. Sending data from one cell to another
  204. editing axis values
  205. Altering cell content
  206. [SOLVED] Todays date minus 1 month
  207. [SOLVED] using lists to find information in large excel db
  208. Alternative To INDIRECT?
  209. MAX? IF? MAXIF? Help required...
  210. [SOLVED] Highlighting a row, on condition..
  211. Sorting question
  212. Make a formula so that 200901 - 5 = 200848
  213. Regress nonlinear equation
  214. Formula 4 ranking by frequency
  215. Data import
  216. Adding to total according to 'style'
  217. Multiple Dependent dropdown
  218. Searching for data across multiple worksheets and copying
  219. What is MIS
  220. Sum display the result of an IF formula
  221. Next Button to another worksheet
  222. how to create automatic copy and paste in one column ?
  223. [SOLVED] lookup?
  224. How to stop Excel deleting leading zeros
  225. Request Custom formating
  226. [SOLVED] If formula
  227. Display records from one worksheet on another
  228. Calculating The Largest Negative Number within a Range of Positive & Negative Numbers
  229. Ranking Vertically
  230. Q?: another IF situation problem
  231. adding word values from column
  232. Display just numbers in a column.
  233. problem with excel 2007 short cuts
  234. Vlookup for multiple occurances
  235. Cut of data leads to #reference! error and formatting lost.
  236. Concatenate Formula
  237. missing numbers list
  238. [SOLVED] Need a formula to distribute a value along a bell curve.
  239. Font size smaller in Excel than in Word
  240. Counting types of OR cases by month
  241. Sum every third cell
  242. Print Set-Up for Entire Workbook
  243. Copying subtotals only for graph.
  244. Move Date from Grid Format to List Format
  245. Print Set-Up for Entire Workbook
  246. Creating reference list
  247. How to change typing syntax options?
  248. total of cell range in 2 matrixes using 2 cells for reference
  249. converting a MS word document to Excel
  250. Dealing with Hidden Worksheets