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] Make numbers a percent of 100
  2. Excel as a Catalogue?
  3. Change Excel default number of decimal places
  4. [SOLVED]Wondering how to keep headers repeating from page to page.
  5. Trailing space with copy and paste
  6. Searching for most recently edited row within multiple sheets
  7. [SOLVED] Simple Conditional Formatting
  8. Recurring date
  9. Fill a cell gray and plot white?
  10. [SOLVED] Conditional Formatting - no data no colour
  11. Original Author of spreadsheet (Excel)
  12. Need Excel To Work Out Where to Transfer My Data To...
  13. Searching for a 4 digit number within multiple sheets
  14. [SOLVED] I have a list containing customer data.. can I insert a date automatically?
  15. Finding Out What Phase A Project Is In (Example Att) ?
  16. Pull part text from cell
  17. Search multiple columns and find corresponding value
  18. Convert Time to decimel
  19. need to share value accross months in excel
  20. [SOLVED] Calling Columns into different Worksheets
  21. [SOLVED] =match(1,--(abs(b2:$b$29-b1)>0.04),0)
  22. [SOLVED] In Sheet Row Numbering and TOC
  23. Grabbing data from a workbook containing multiple sheets
  24. [SOLVED] Match/Lookup/Result Formula
  25. Selecting a group in a moving range
  26. [SOLVED] create a drop down list from another worksheet
  27. compare min and max ranges
  28. [SOLVED] Check for values greater than zero in 2 cells
  29. [SOLVED] date / time problem
  30. [SOLVED] trying to get my sheets back to move from cell to cell with the arrow keys please
  31. Auto fill coloring of a cell with a specific letter
  32. Auto Refresh or Auto ReQuery
  33. Is there a command to stop a formula from running if there is no data in a cell?
  34. [SOLVED] Counting Weeks INVOLVED between 2 dates
  35. Count Uniques with 2 criterias
  36. I want to use a single report filter for multiple pivot tables, Possible?
  37. [SOLVED] SUM with multiple criteria in same field AND multiple fields
  38. Using full names in dropdown list
  39. [SOLVED] Inequalities question.
  40. Saving in a Micro-free workbook
  41. Data Summary
  42. [SOLVED] Shared file saving problem
  43. Adding conditional formating depending on user input.
  44. [SOLVED] Excel drop down list autohelp
  45. Run Macro from button on a different worksheet
  46. Cascading dropdown list with dynamic ranges
  47. Deleting blank rows on a Mac
  48. Joining two sheets together.
  49. Data converted to Scientific Notation
  50. Pivot Table Details
  51. [SOLVED] Help with CountBlank
  52. Pivot Tables Question
  53. Duplicates and Consolidation
  54. Prevent Excel from Changing Strings to Numbers
  55. Lookup Problem
  56. Splitting Rows Into Separate Files
  57. Creating ranges in Pivot Tables
  58. Lookup Multiple Values
  59. [SOLVED] Save Active Sheet to another Workbook
  60. Alerts
  61. Find a column and return values
  62. [SOLVED] trouble with calculating dates.
  63. Filter a specific word in a table
  64. [SOLVED] Using cell contents as dynamic value (sheet name)
  65. [SOLVED] The first following row with differnce of 40
  66. [SOLVED] How do I sum up numbers connected to repeating names?
  67. [SOLVED] How to formulate character in a column?
  68. [SOLVED] sumif for non-blank criteria
  69. [SOLVED] Conditional Formatting Question
  70. Can IF, AND, and OR forumulas be combined?
  71. [SOLVED] month day day of week
  72. Excel form problem, dates
  73. Automatically copy rows to a separate worksheet
  74. Sumif function won't recognize text
  75. [SOLVED] Excel (value) error question.
  76. [SOLVED] subtraction without borrow
  77. [SOLVED] Problem with paste special
  78. pick random cells ?
  79. Vlookup, return empty cell (not #N/A) when result not found
  80. filtering data
  81. [SOLVED] Searching for values greater than zero, listing 3 of those data in order
  82. Counting cells by colours rather than by content
  83. Manipulating the format of contents from sheet1 and formatting them diff on sheet2
  84. [SOLVED] Solving for variable for a formula equation = 0
  85. conditional formatting across worksheets
  86. matching a date with a month
  87. [SOLVED] Mirror image or flipping cells
  88. [SOLVED] Excel 'vlookup' not refreshing
  89. [SOLVED] Self updating Drop Down List
  90. [SOLVED] Column protection
  91. [SOLVED] Convert Deg Min Sec to Deg.dec
  92. Display An Image As A Result Of A "Vlookup"
  93. Nesting if and countif
  94. help with line chart
  95. Problem reporting results of simulation
  96. XLS file and dll version
  97. [external data] Two queries same access files...
  98. [SOLVED] Can excel autosplit two words from one cell into two cells
  99. Can you merge data from multiple columns into one dropdown list?
  100. Multiple inputs
  101. How to reference a cell in Excel with an embedded Word Doc
  102. How to delete contents in all cells that display A02
  103. Second largest value with Duplicates
  104. Losing format because of multiple IF statements
  105. [SOLVED] If, sumif, or other function?
  106. Background image
  107. [SOLVED] I would like to copy selected records from one sheet to another
  108. Nested If statements that dont stop reading when condition is met
  109. Connecting data?
  110. [SOLVED] Merge cell contents into a text block?
  111. [SOLVED] number formatting
  112. [SOLVED] Grouping Data in a Pivot Table
  113. [SOLVED] Allocating Employee names with unique reference number??
  114. [SOLVED] underlying formula in cell....
  115. [SOLVED] Vlookup
  116. Summing Values from If-Then Statments
  117. Updating database & Chart
  118. pull text string from cell containing random txt data?
  119. Countif Formula
  120. Excel Rows to start at 0
  121. Making spreadsheet available online w/ macros
  122. [SOLVED] Easy question re sorting
  123. Combo Box Display Property
  124. Use a selection from a list box to display a range.
  125. [SOLVED] Count IF question
  126. Data matching with data validation
  127. Hiding Columns - Can't shift objects off sheet
  128. Using Hlook up
  129. Consolidating multiple worksheets into one
  130. Multiple rows make a single order and Pivot table
  131. [SOLVED] List all values found within a range.
  132. Excel Transpose Question
  133. [SOLVED] need workbook with limited rows and columns
  134. VBA Courses
  135. Merge worksheets?
  136. Deleting Duplicate Entries Across 2 Columns
  137. Multiple Pivot Tables, Same Data Source
  138. Date formating probelm
  139. Data Validation
  140. Adding columns only with $ sign
  141. Comparing two mailing lists
  142. [SOLVED] All dates in excel changed now use hyphen, huh?
  143. Groups & inactive tools
  144. Average start time - using filter
  145. [SOLVED] Tip messaging
  146. Page Break Preview
  147. What pages are not seen
  148. [SOLVED] Convert Deg Min.dec to Deg.dec
  149. Circular Reference Problem - HELP
  150. Importing a HUGE txt file into Excel
  151. Proof of Calculation
  152. Extracting Information from a cell
  153. Display in worksheet - hide from print?
  154. interpolation
  155. [SOLVED] formula to add letters with numeric values
  156. [SOLVED] COUNTIF or SUMIF
  157. Transferring data from a price list to a bill of materials
  158. [SOLVED] How do you export text to a specific location in a text file?
  159. Click to identify the relevant cell
  160. [SOLVED] Formula for most, second most , least.
  161. Dependant List question
  162. Contains symbol
  163. COUNTIFS with a range of values for criteria
  164. [SOLVED] sumif & sumproduct
  165. Sorting issue
  166. Prevent overwriting cells
  167. [SOLVED] Using countif to total employess
  168. Lists?
  169. Macro wont run un current cell de-selected
  170. Coding links in a text string
  171. Retrieve User ID
  172. Surveyor on pipeline
  173. [SOLVED] Sum costs of same cell in all sheets of workbook ?
  174. another pivot table question
  175. [SOLVED] Active Cell
  176. GlobalTopic into Excel
  177. List of macro commands
  178. Refresh Data when Sheet is protected
  179. [SOLVED] COUNTIF & SUMIF formula question (excel/forum newbie)
  180. Very large excel file, 12 sheets, filters?
  181. Setting each box equal size.
  182. Problem with save xls into csv
  183. [SOLVED] VLOOKUP return #N/A
  184. Sorting pivot tables columns and more...
  185. [SOLVED] If / Then Formula possibility?
  186. Year expiration date
  187. Custom number format
  188. SUM help
  189. [SOLVED] Repetable formula
  190. [SOLVED] Consolidate values from multiple cells
  191. When TRIM() and CLEAN() fail.
  192. Changing the formatting of text
  193. Placing info in a seperate tab and highlighting names?
  194. Conditional format / text in another cell
  195. How to recover a file that has being accidentally deleted!
  196. Email account list reconciliation
  197. Copy input range and paste into Format Control
  198. Presenting Details to User in Drop Down
  199. Send to Mail Option not available
  200. Results based on subdata
  201. Full name match between files
  202. Excel pivot table row labels and report filters
  203. Listing a set of files from a database
  204. [SOLVED] Vlookup to find data from all worksheets
  205. Pasting to a merged range on a shared document.
  206. Merging Cells that contain custom formatting
  207. dynamic range for pivot table
  208. [SOLVED] VLookup for dynamic ranges
  209. Index Match Formula
  210. [SOLVED] Help with formula looking at Date ranges?
  211. Filter not refreshing
  212. Multiple Rows Of Worksheet Tabs
  213. [SOLVED] Referencing Cells Dependent On Sheet Name
  214. Excel Conditional Format Icons
  215. Listing Figures depending on dates
  216. Letter "R" appearing in formula
  217. creating a series of skipped dates
  218. Two different values using IF statement
  219. how to make the spreadsheet to have invisible cell
  220. Cannot share Excel sheet
  221. How to sum a range of numbers only if values pass "if statement"
  222. Dynamic range without using named ranges???
  223. How to use the IF Formula in Excel
  224. Pulldown list opens out of view
  225. [SOLVED] Find matches in columns
  226. best way to be sure Find thoroughly searches sheet
  227. VLOOKUP question
  228. send to mail recipient for review
  229. Defined Name edit box HARD to use
  230. Reference a cell name, not its contents
  231. Rank in Pivot Table
  232. Why am I getting "file corrupted" so often?...
  233. [SOLVED] how do I isolate text?
  234. Corrupt File - XML-related? (Excel 2007)
  235. Column Match Help
  236. toggling through a search
  237. [SOLVED] format date as text and keep the info ?
  238. Tab key jumps many columns!
  239. [SOLVED] Problem copying cells for e-mail
  240. Filter tag only in selected cells
  241. [SOLVED] SOLVED: adding day in date function
  242. Turn Auto Calculation off just for Specific Worksheets
  243. Embed a cell value within a link to an Excel file
  244. [SOLVED] Is the IF the best formula to use in this situation and help needed with it.
  245. How to export Excel data to an Access table
  246. [SOLVED] IF and OFFSET: how to OFFSET only if cell has a value in it (follows previous post)
  247. gridlines have disappeared
  248. How to avoid duplicate entries in same column
  249. HLOOKUP to get number for formula #NA error
  250. [SOLVED] Summing up cells that have an #n/a