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. Same name but different data
  2. Char length
  3. Multiple groups in Excel 2002
  4. VlookUps Function Help.
  5. Chart dates auto scaling when auto scale option is turned off
  6. [SOLVED] Changing the Answer formula calculates
  7. cannot expand named range
  8. [SOLVED] countif(Range, multiple referenced values?)
  9. Look Up Value And Return All Related Values From Other Cells
  10. Combining if formulas in one cell
  11. Run Macro on Protected Sheet
  12. [SOLVED] Multi Cell Cursor will not sum
  13. [SOLVED] I need help with formula to calculate sick days
  14. [SOLVED] How to create formula that links to another sheet based on user input
  15. [SOLVED] How to format this way?
  16. Day ## of ## counting
  17. Advance Transpose or Vlookup
  18. [SOLVED] Creating summation formula based on user input.
  19. Copying a drawing from Excel to Word without loosing formatting in textboxes?
  20. How to count text?
  21. Changing variables for calculating a result
  22. Date and time based on shift in cell
  23. Function INDIRECT and SORT
  24. Count date range
  25. Can i run a Macro on dynamic data??
  26. Force numbers to ending value
  27. [SOLVED] Deleting after 9 numbers
  28. New data validation list appear when one is activated
  29. Automating a report?
  30. AUTOFILTER with protect sheet
  31. XL charting problem
  32. [SOLVED] format date cell with week number
  33. Variable Labels on a chart
  34. Data Validation thru Double Input into Field
  35. Creating cross checks for formulas
  36. Sumif
  37. Match function value parameter
  38. Corrupted spreadsheets
  39. [SOLVED] Conditional formatting from another cell
  40. Working with Dates and making calculations
  41. Unknown characters in Excel
  42. [SOLVED] sumif functions
  43. pivot table-missing pivot table field list
  44. [SOLVED] Hlookup + vlookup Togethor
  45. [SOLVED] type data subsequintly
  46. grouping problem
  47. VLOOKUP problem
  48. Comment Distinction from Month to Month
  49. Autofill default to 'copy cells'?
  50. How to print a column as a list of headings (for a karaoke book)
  51. Variable OR in an array or similar formula
  52. Trouble Using Pivot Table off a DNR
  53. [SOLVED] Sum of a column depending on data in another cell
  54. [SOLVED] Listing cells on another worksheet depending on cell value
  55. [SOLVED] convert lat/longs
  56. Shared Top and Bottom Border - Bottom not printing
  57. Autopopulating cells based on values of a range?
  58. Security - Protecting a paticular sheet only.
  59. Excel 2007, is this possible?
  60. Lookup values, match, then take MAX from results
  61. Footer: multi-line how-to
  62. sorting data
  63. Picture Help
  64. How to organize this data?
  65. Vlookup?
  66. IF & Sum if combined
  67. [SOLVED] Show sum of only numbers seen via Autofilter
  68. Segmenting Date cell with conditions
  69. Multiple cells in new row
  70. External Data Not Automatically Refreshing Correctly
  71. Relative vs. Absolute Worksheet
  72. Average Subtotals
  73. [SOLVED] margin calcs help
  74. Excel 2007 Hangs on opening Spreadsheet
  75. Calculation with numbers that use measurement units
  76. [SOLVED] Insert numbers before data in multiple rows
  77. [SOLVED] Graph Help
  78. [SOLVED] SUMIF question
  79. copying without the blank rows
  80. create a Conditional String
  81. Question on highlighting cells...
  82. [SOLVED] Drop-Down list help
  83. Need help: linkning and "if"
  84. SUMIF question
  85. [SOLVED] Cell Border ?
  86. Maintaining Multiple Charts From One Worksheet.
  87. Excel copying data from 1 sheet to another
  88. [SOLVED] "If" statement
  89. [SOLVED] Sumproduct to count from 2 conditions...
  90. workbook to workbook search
  91. automatically generate filename by referencing to a specific cell?
  92. Need some help interpreting macro code
  93. Consolidate data from multiple worksheets
  94. [SOLVED] Calculating cost based on several factors
  95. Counting
  96. [SOLVED] Column to Row
  97. [SOLVED] Convert from a specific date format
  98. [SOLVED] loop trough a userform listbox
  99. [SOLVED] linking data
  100. Problem in Scheduling Sheet
  101. [SOLVED] Array formula with variable condition
  102. [SOLVED] Decimal Time to Standard Time
  103. [SOLVED] TREND between two points
  104. Doing a calculation in a pivot table
  105. [SOLVED] Formula- if Between add
  106. [SOLVED] sumif(range,"<30",sum range) not summing values that equal 0
  107. [SOLVED] Generate Calendar with Specific Dates Marked
  108. Changing filename colors in folders
  109. How to sort out through this list ?
  110. [SOLVED] Too much data for Excel?
  111. Help With Conditional Formatting ICON Sets
  112. countif function not counting :(
  113. Matching multiple results to a single variable
  114. Average of a column excluding certain rows
  115. Hyperlink to other sheets depending on cells.
  116. How do I organize my data in this way
  117. Shared Violation
  118. [SOLVED] Creating a hyperlink to search a column for a value?
  119. [SOLVED] additional tabs
  120. UserForm- Textbox
  121. Change format of dates
  122. [SOLVED] Totalling VLOOKUP Data with #N/A's
  123. Protected Worksheet - Forgotten Password
  124. [SOLVED] Average of last 4 cells that match current cell
  125. Contents of a column/table
  126. VLOOKUP Multiple Occurences of Same Reference?
  127. Use lookup to return values separated by comms
  128. [SOLVED] 3 Conditions - SUMIF or SUMPRODUCT or...?
  129. [SOLVED] Conditional Data Validation
  130. Unprotect sheet in Shared workbook ?
  131. Shared Network Workbook is Slow open, Saving, and Closing.
  132. [SOLVED] Generating a unmatched list
  133. Account number
  134. Drop down menu for multiple cells! AHH!
  135. vlookup
  136. Problems updating links on protected sheets
  137. [SOLVED] Cell formatting by formula or macro?
  138. [SOLVED] Using (right) function to find letter not number
  139. Counting Number Of passes & fails by date + product
  140. Complicated Ques. - Cross referencing data in sheets
  141. [SOLVED] message box error
  142. [SOLVED] Populate a drop down list
  143. [SOLVED] #DlV/0!
  144. Large data....slow excel performance..!!
  145. Text processing in excel
  146. [SOLVED] Adding text in same cel as formula??
  147. [SOLVED] data selection
  148. [SOLVED] Conditional copy to list
  149. [SOLVED] Charts - Line Chart, How to Show data Ranges?
  150. Vlookup and If Statments
  151. [SOLVED] Display Negative Times
  152. Appropriate template/worksheet needed for keeping track of turnover
  153. When I select cell I want it to pop up an checkbox list
  154. Pivot table for .CSV file exceeding 700,000 lines
  155. [SOLVED] Select defined cells and "stack"
  156. Parsing Text ( Last Name, First Name )
  157. [SOLVED] conditional formatting
  158. [SOLVED] string in a right function
  159. [SOLVED] Add two spreadsheet rows and repeat
  160. Cannot copy cells because they are too complex
  161. Converting a number to a date
  162. important Excel blog
  163. [SOLVED] Updating Excel Files...Old Template to New Template???
  164. Updates and Macros
  165. Cell Tagging
  166. [SOLVED] DSUM Adjacent Criteria
  167. Changing Linked Images into Embedded Images
  168. Extracting Bad Data
  169. Saving TinyGraphs (sparkines) to .png
  170. Adding Date and Time to Yield Date
  171. [SOLVED] drop down list and search by first few letters?
  172. Formula for Excel
  173. Users gain full control of Shared Excel Workbook upon saving
  174. include funtion in automatically generated macro
  175. Double Underscore
  176. [SOLVED] Automatic date question
  177. Pulling data to new spreadsheet based on multiple criteria
  178. [SOLVED] Trying to run a script...
  179. [SOLVED] Formulas appear by themselves?
  180. Extracting data in the same cells across multiple sheets to a summary sheet
  181. generate statement with cell values
  182. Can't view all rows
  183. Countif not giving correct number
  184. populating xcell with numbered list
  185. Summing two columns with conditions?
  186. Array of worksheets
  187. Superscripted footnote following a formula generated number
  188. [SOLVED] COUNTIF formula question
  189. [SOLVED] SUMIF with Subtotals
  190. [SOLVED] Formula Reference Row To Column, Scroll Ways!
  191. Autofit and expanding cells
  192. Help using INDIRECT with formula string
  193. Applying a Formula to an Extremely Large Column
  194. how to solve this problem?
  195. copy from excel to notepad
  196. updating function
  197. Excel 2003 file does not work right in Excel 2007
  198. [SOLVED] Dividing data in a cell if conditions met in another cell
  199. Sum values in a cell containing an index formula
  200. password protect text box control form?
  201. [SOLVED] return a blank response
  202. Website timeout
  203. [SOLVED] pictures in excel
  204. [SOLVED] Alternative to CTRL-SHIFT-ENTER Array Formula (follows previous post)
  205. [SOLVED] formula if cell=y or n
  206. Ranking linked data
  207. Conditional formating help
  208. Control over drag and drop from an Excel cell
  209. Locking in column width
  210. [SOLVED] Excel 2003: rounding down and capping
  211. excel formula with 3 or more upper and lower limits
  212. [SOLVED] simulate drag or autofill
  213. [SOLVED] Named range help
  214. [SOLVED] Pivot Table Disable grouping
  215. Time If
  216. Easily adding multiple addresses into invoices
  217. Sorting Output with Formulas in It
  218. Daily Timesheet data collection
  219. [SOLVED] Date filteration
  220. Convert Text Values to Specific Numeric Values
  221. sum function with a break point
  222. how to activate greyed out ribbon items?
  223. [SOLVED] SUMing two IF Values
  224. [SOLVED] Picture Won't Delete
  225. Deleting Cell Entries from Workbook
  226. First and last column numbers with non-zero cells in a range
  227. How to sort a MAC Address? (WWN)
  228. Create a numeric value from text?
  229. unhide worksheets
  230. How do I search multiple separate phrases at once?
  231. Question regarding column number
  232. Conditional Drop Down list
  233. [SOLVED] how to do a progressive add with an IF clause that is interrupted.
  234. Conditional formatting
  235. Error while moving mouse
  236. #Name in Index formula
  237. No More New Fonts May Be Applied to this Workbook
  238. INDIRECT and named ranges
  239. [SOLVED] Show a certain cell depending on data from a drop down menu.
  240. My formula will not extend without double clicking
  241. Changing cell colours
  242. Print page 1 landscape and page 2 portrait
  243. Translate a word into a phrase.
  244. Handling Recurring Numbers In Excel
  245. vlookup question
  246. Find the Sum
  247. [SOLVED] Automatically create monthly totals from daily data
  248. [SOLVED] Help with INDIRECT & MID functions
  249. [SOLVED] Sorting and counting large amounts of data
  250. [SOLVED] Array formula or similar needed - Again!