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. Protecting
  2. count unique in pivot table
  3. turning on scroll lock
  4. Changin =DEC2HEX conversion
  5. dividing by highest number in range
  6. exceeds 6 digits
  7. Second Logical test in if statement
  8. list box to combo-box
  9. adding text to front and back of entries
  10. Summing a Column based on reading matching items in another column
  11. if number starts then equal (something like that)
  12. probability question
  13. Excel Macro create password
  14. Advance deleting functions!
  15. dates issue
  16. Automatically Duplicate Row to Another Sheet
  17. Find Furthest Number to the Left
  18. Add 4 cells together, ignore the ones with text in
  19. Ignore certain letters
  20. Retaining Cell Data after Sorting
  21. Limiting Text Lenght
  22. change the date with a click
  23. Vlookup on 2 different sheets
  24. Create a drop down menu
  25. Using IF for numbers
  26. filtering duplicate entries
  27. Calculation to Number field
  28. Internet References
  29. Automatically Updating a row
  30. PivotTable Question
  31. counting text in a column if
  32. Housenumbers and initials
  33. format a cell
  34. #value!
  35. Conditional Formatting Cells In Diff Sheets
  36. Setting Permissions
  37. Excel function for value?
  38. Excel 2007, #!VALUE
  39. Visit organiser
  40. Formula question
  41. auto colour formatting
  42. trying to freeze a sheet
  43. Greater by 20% formula
  44. looking up a master sheet and returning positive values only
  45. Sort by Clicking on column headers
  46. How to 'fix' the value of a cell calc by formula...
  47. Add avatar to your threads
  48. Replicate and increment alphanumeric keywords?
  49. nesting rounding and if function
  50. extension
  51. selecting from a list
  52. Showing an image from the web
  53. How to set date as 01st of next month of a given date in (dd-mm-yyyy
  54. Locking Sheets on Excel 2007
  55. how to make a list?
  56. Counting only the cells in a column with numbers greater than 0.
  57. count questionaire results
  58. how can i round zero up to always display one
  59. COUNTIF formula
  60. Copying a function to cover many cells
  61. How to set up a simple form
  62. problem with dates
  63. How to leave cell blank with an equation?
  64. Procedure Too Large
  65. Link two Work Sheet by common column
  66. 4 seasons of date ranges - evaluate dates in which season?
  67. how do i say "or" in excel
  68. Comparing numbers in lists/columns of numbers
  69. Totaling calls every 15 minutes.
  70. Something strange ...
  71. Question using =today()
  72. Color triangle notification
  73. Change cell background with exception
  74. Matrix multiplication with complex numbers
  75. Slow down using COUNTIF
  76. Formatting Merged Date and Time
  77. Repeat functions with an individual variable.
  78. Date and Time Stamp if Saved
  79. automatically calculate price
  80. 1 Formula running multiple inputs?
  81. Excel Templates
  82. Changing time - take an average of the time
  83. Linked Spreadsheet and Formula Sorting
  84. how to use FORECAST
  85. Total schedule hours
  86. Nested If function
  87. Working With Check Boxes
  88. Round in VBscript for Excel
  89. Holiday accrual calculations
  90. Sorting by colour
  91. measuring frequency of an action.
  92. Getting a "nearly" response in my quiz
  93. External data Issue
  94. permuting 37 choose 5.
  95. ignore #DIV/0!
  96. Vlookup or Match?
  97. Cut and Past cells into a Cell Comment
  98. Flashing Font
  99. Table Join/Relate
  100. Changing Pivot Table Headings
  101. Error: Unable to get the RTD property of the WorksheetFunction class
  102. Skipping rows in cell references
  103. Excel tries to open other files when first opening
  104. Using tab key to move from cell to cell
  105. default text qualifier
  106. Turning off the clipboard sound
  107. Adding trailing space
  108. Formula to calculate percentage sales
  109. Can you email just the comments?
  110. Autoshapes grayed out
  111. Data Counting
  112. Match & Index
  113. want to get that equal sign in..
  114. Exel is opening my file
  115. If nesting limits
  116. Sorting & Ranking
  117. Slant in cell, two different values
  118. Formula and Function
  119. How to alter values shown in Excel
  120. If Function
  121. Excel 'Help' dialog box not working correctly,
  122. Want to keep the little numbers but use my first row as the column headers....
  123. time calculation
  124. Excel 2007 stopped working with Vista Business
  125. Maximum value
  126. Returning the biggest value
  127. Excel not recognising 1 or decimals as numbers
  128. VLookup -- Looking up if not there
  129. How to change the column name?
  130. How to set & lock an Excel field to a specific number of characters?
  131. How to turn off default wrap when pasting data
  132. Mirroring Content from Multiple Spreadsheet Worksheets on a Summary Worksheet
  133. A peculiar conditional sum
  134. vlookup not working, sumif does.
  135. print my two columns along the left hand side of the page and continue on the right h
  136. columns to repeat info for price list
  137. Excluding repeated values
  138. Linking cell to 2 columns
  139. sort like the other Col.
  140. Excel file in a web page that cannot be downloaded but can be used for calculations
  141. How to achieve table AUTOcompletion
  142. summing two ranges
  143. Refresh filter after data refresh?
  144. Data Management
  145. if date function
  146. Column Widths
  147. convert formula to its result
  148. Rounding up Averages
  149. Ignore a value in the cell
  150. Required formula excel.
  151. Calculate commission - IF AND ??
  152. Times and midnight issues
  153. stop Excel from reformating my dates
  154. formula that takes the diff between two cells and show only the positive
  155. Dependant? Data Validation
  156. Hyperlink in a Formula
  157. Repeating data in 1 column to multiple columns
  158. Nested IF
  159. stopping excel from autoformatting a function cell
  160. Is there a function that can be used to look at a date and display what actual day of
  161. Edit Links problem - "...links cannot be updated..." error always occurs
  162. Finding cells in large spreadsheet
  163. Menus disabled
  164. Warehouse product locator suggestions..
  165. Cell reference with number format?
  166. Combining sum if problem - another way?
  167. Drawing a sliding scale graphic
  168. rounding error?
  169. Simplifying A Forumla
  170. Preserve the formula
  171. Changing Criteria from absolute value to a range?
  172. increase years by 1
  173. Drop-down list and capture response
  174. Auto_Open Message Box, but option to disable Auto_Open
  175. Recommendation for VBA books for beginner
  176. Excel-document suddenly transformed into a dinosaur on 150 MB
  177. Autoformatting a row
  178. Autofilter
  179. Altering a Spreadsheet with images
  180. How to Tell if Name Exists?
  181. hidden objects
  182. Add two critera containing dates
  183. If Function
  184. complex calculation
  185. Import External Data
  186. deleting all error characters
  187. eliminating leading space
  188. Which Excel Programming book...
  189. Returning to original default sort
  190. Excel says Disk full - when it is not
  191. MS Query Update changes formulas
  192. How do I add "/>" to the end of a string?
  193. Zeros at the begging
  194. divide the final value
  195. Macros Disabled ?
  196. How to match identical data from two rows
  197. memo controls in excel?
  198. Column Progression in Formulas
  199. invoice forum
  200. Vacation Accrual
  201. Linked Cells Corrupted by Data Sorting
  202. Combinations summing up to 100%
  203. Each cell to accept number 1 to 5 only
  204. Conditional Formatting
  205. opening spreadsheet on wrong row
  206. making conditional formatting not continuous
  207. Transferring text between sheets?
  208. Trying to make a few lists from one big one.
  209. Hyperlink Security problem
  210. Color cell by value
  211. hiding a diagram
  212. Read-Only message not appearing
  213. Excel data type auto guess problem
  214. Viewing Tabnames vertically instead of horizontally
  215. Protecting a data validated cell
  216. create a formula to pull the person's name and the avg number of cartons
  217. merging cell details into one coulmn
  218. Self created validation list
  219. hyperlink bug/problem
  220. excel to html/text?
  221. carryover a balance from previous months
  222. Conditional Omission of Items on a Chart
  223. Converting decimals to 1/16ths
  224. IF Statement
  225. Fill in a series inconsistency?
  226. Using Excel Sheets as a Database Backend
  227. Summing from another sheet with Condition
  228. Using a mouse click as a direct input into a spreadsheet?
  229. Cleaning up a text file
  230. insert button in Excel 2007
  231. Counting conditions in arrays
  232. Way to view two separate worksheets of the same workbook?
  233. pasting and replacing old data.. sort of???
  234. Default Chart Title Text & Text From Cell
  235. user level authentication excel 03
  236. Goto Letter in Validation List
  237. Keyboard shortcuts - resize a column
  238. Round Functions
  239. Variation of Vlookup?
  240. ABS function
  241. window split question
  242. Arranging an interval
  243. convert a figure to text
  244. Average If Formula
  245. Text to Number conversion in Validation List!
  246. Pasting into a Protected Worksheet
  247. Getting a negative return value!!
  248. Exporting List (from autofilter list)
  249. League Schedule
  250. Check Box Formula's