PDA

View Full Version : Excel - New Users

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
  1. Check sign in a Cell
  2. Finding unique values in a column
  3. Plotting a square root line of best fit
  4. [SOLVED] Insert rows and formulas above Button
  5. Quick/easy Question: Blank cell vs =""
  6. How to create a logical search?
  7. Zero's Out
  8. Creating forms to feed into spreadsheets and then summarising in a final spreadhseet
  9. delete the rows in the filter mode
  10. Value lookup from multiple tabs
  11. formula problem
  12. VLOOKUP function
  13. Automating a task between two files
  14. [SOLVED] IF testing for match with range of values.
  15. 3 largest no along the column and its frequency
  16. Changing colours
  17. Help with a formula
  18. [SOLVED] How to create one file from many excel files
  19. multiple paste operations in same column
  20. Google Docs/Excel - Percentage converts to Decimal
  21. [SOLVED] Tallying types based on cell contents
  22. conditional formatting and letter/number grades
  23. Calculate withholding
  24. Graph Auto Update Problem
  25. how to search in a column
  26. [SOLVED] Add equal cells from different sheets
  27. [SOLVED] Rotate a chart
  28. Getting column to scroll with view
  29. Linking formula in subsequent rows to first row info
  30. Excel formula for ascending serial numbers
  31. Allocate points based on win, loss or draw
  32. [SOLVED] Converting minutes to hours and calculating pay
  33. =IF fomula, transporting data between sheets.
  34. Excel Formula trying to calculate difference between two dates
  35. [SOLVED] matching partial text within one cell to partial text within another
  36. Combo Boxes
  37. Pivot table
  38. Show user an indicator (color?) in one column based on conditions in other columns
  39. [SOLVED] Help cleaning up formula
  40. Automated schedules
  41. [SOLVED] Graphing and plotting multiple data series
  42. remove all duplicates
  43. [SOLVED] replace a cost
  44. Help wanted on excel task
  45. [SOLVED] How to calculate IF, NOT, THEN, OR
  46. Macro scripts to calculate cell value and exporting file format type
  47. Help Using a Master Worksheet #VALUE! ERROR
  48. Embedding image thumbnails in excel
  49. Spell Checker??
  50. [SOLVED] Change cell value if cell on another worksheet is not empty
  51. [SOLVED] Excel forumla to search in different excel file for matching criteria
  52. Using Excel for quotations and looking up descriptions and other information
  53. Changing scale of bar chart
  54. Removing Read Only from files
  55. [SOLVED] What do [brackets] mean in VBA?
  56. Cell formatting for Vlookup to work
  57. Mandatory cells
  58. Deleting sheets with local names - ver 2007 vs ver 2003
  59. Dynamic named range
  60. count only numbers
  61. Data setup
  62. How to make interactive calendar with months is sheet doc ?
  63. Using DataForm from a Macro
  64. Importing&linking music files to an excel sheet
  65. Unable to feed output from one cell/sheet/file to another
  66. How to copy sheet & change col headers
  67. Permutation creations on excel
  68. [SOLVED] Combining two separate functions into one function
  69. Query regarding conversion of figures
  70. adding and minusing at the same time
  71. Unable to grasp Excel to create database
  72. Decrease value each week
  73. Disable roundup
  74. VLOOKUP Issue
  75. Count number of cells based on 2 selections in the same range.
  76. sheet reached max limit
  77. Displaying Time
  78. Need to capture results automatically from one worksheet to another
  79. [SOLVED] LOOK UP function
  80. Hide then show specific column
  81. IF Statement Help
  82. Pivot Table Question
  83. Bit
  84. reverse values in a row
  85. [SOLVED] Mobile Phone Numbers/ Cell Phones
  86. Replace tab value inside formula with cell value
  87. Autoconvert to uppercase, not the "UPPER" function
  88. Display day of week
  89. copying text from one sheet to another
  90. Percentage calculations
  91. Making a cell appear blank
  92. seach specific word in column & write something different in next column
  93. [SOLVED] Logical test
  94. Zero value
  95. Number formatting issue
  96. [SOLVED] Formula to use drop down in next cell
  97. [SOLVED] Colour cell with biggest value
  98. How do I embed Visio drawings?
  99. [SOLVED] How to add your thread as Solved?
  100. Inserting rows after subtotals (in macro)
  101. calculate a percentage of a percentage
  102. Help with the "COUNTIF" function.
  103. [SOLVED] dynamic range for (example: subtotals)
  104. [SOLVED] Logical test? Showing when a date has expired
  105. .xlsx converter to .xls for excel 2003
  106. [SOLVED] How do I make a value show up in another worksheet?
  107. [SOLVED] Paying date
  108. [SOLVED] returning a value from a date range
  109. Adding dates in Excel
  110. Saving worksheet
  111. Lock cell dynamically as you enter values
  112. Copying from Word and pasting into Excel
  113. Referencing a filtered group
  114. [SOLVED] lookup and give an array/list
  115. [SOLVED] #NUM! error on MOD function
  116. SUM function not producing correct result
  117. Want to multiply cells if value is "USD"
  118. Consolidating Two Lists of Info
  119. [SOLVED] Excel 2007 - not reading cells as numbers
  120. Percentages problem
  121. return only cells with values greater than 0
  122. Increment in groups of 7
  123. [SOLVED] advance filter criteria
  124. [SOLVED] Putting multiple cells together in a list
  125. Find a specific text in multiple cell
  126. Best layout to match pairs of data?
  127. round time to nearest 15mins e.g. 16:12 to 16:15
  128. Paste deletes rows instead of moving them down
  129. Find my posts
  130. [SOLVED] Indirect formula
  131. [SOLVED] How do I automatically copy data from one cell to another cell?
  132. Unable to change format of all cells
  133. Format as a table colors not right
  134. Wildcard VLOOKUP or MATCH or both?
  135. [SOLVED] Trying to use a drop menu or list box
  136. Search by address
  137. Changing Font Size on a Button
  138. lost tabs
  139. Protected worksheet
  140. Drop down list that changes selected sheet
  141. [SOLVED] Last date
  142. Producing a table of unique values.
  143. Cost of Goods in Previous Years
  144. Sum depending on date range
  145. [SOLVED] Inserting a "check Mark"
  146. row function.
  147. [SOLVED] multiple lookup formula
  148. Create job cost sheet
  149. [SOLVED] Max and min values
  150. finding the latest date in a list of dates
  151. Parameter query/Reference is not valid
  152. [SOLVED] List of numbers, trying to put them each in their own cell
  153. Sorting two related columns
  154. [SOLVED] Sorting by rows
  155. Sorting Linked Worksheets
  156. Excel Formula equivalent of Access Formula
  157. Combining a column's data by referencing another
  158. sum multiple criteria date range
  159. [SOLVED] Orgainzing cells by highest number(Solved)
  160. Generating individual tabs of each state from master workbook
  161. If certain value of one cell is not met, count another column
  162. lookup the minimun but non zero value from a range
  163. Rota Calculation
  164. Hlookup -next largest number
  165. Excel mail merge ?
  166. convert excel file to address list
  167. [SOLVED] Fetching data from another worksheet
  168. Way of Inserting duplicate characters into a column list
  169. [SOLVED] Adding an email address
  170. [SOLVED] Sheet protection
  171. [SOLVED] Rearranging columns to rows
  172. Number Generator
  173. Time Sheet - Overtime
  174. Disable Calculation
  175. convert spreasheet to html
  176. [SOLVED] Freezing Rows
  177. Total the hours scheduled
  178. Specifying row number in formula
  179. updating sheet 2 from sheet 1 data
  180. Combining 2 SUMIF Formulas
  181. [SOLVED] A/P aging with date in IF statement
  182. Autofill using Offset Ranges in a Macro
  183. Permanently Changing Excel 2003 Default Color Templete
  184. Change cell color on click
  185. [SOLVED] How can I make a cell "transparent" if a formula is FALSE?
  186. Can you have "enter" return the cursor to the top of the next column in Excel 2007?
  187. [SOLVED] Minimum value excluding zero?
  188. Create sortable bank of Q & As?
  189. [SOLVED] custom formatting
  190. [SOLVED] Count multiple numbers in a cell
  191. [SOLVED] Billing Related, possib Lookup?
  192. security password - excel
  193. [SOLVED] Cell lookup after using MAX
  194. [SOLVED] Alternating Row Colors Automatically
  195. Link 2 workbooks
  196. Decreasing and Increasing in excel 2007
  197. Formula using two columns and average function
  198. Finding an amount in an adjacent cell
  199. Vba - insert popup calendar
  200. Create buttons
  201. Sum up status per row
  202. how to sum(group) a large database
  203. Why are things moving around?
  204. Formula for dates older than
  205. vLookup/Match/Index
  206. [SOLVED] insert rows/columns
  207. Simple Sums?
  208. [SOLVED] Sort Event Winners automatically
  209. Print Blanks
  210. [SOLVED] Copying data frm IBM mainframe to Excel
  211. Hyperlinks keep changing
  212. Automatic copying field content from one sheet to another
  213. Finding latest date
  214. Sumproduct
  215. Enter a date
  216. If statement
  217. [SOLVED] If statement
  218. Can I get Excel to interpret certain characters as new column or new row?
  219. Multiple Conditional Sum
  220. Multiple lines of text in one vertically merged cell
  221. Custom formatting a cell
  222. Why are colors messed up when I format as a table?
  223. Read Only
  224. my threads disappear
  225. Ranking table
  226. How to check if month in column B is before current month
  227. Accessing Conditional sum wizard in Excel 2007
  228. If or maybe a value lookup?
  229. Fixing historic data
  230. how to compute percentage of time looking at corresponding values in columns
  231. One Variable Data Table
  232. [SOLVED] exel formula for sorting digits
  233. Question over entering text
  234. Macro to find a row (based on matching criteria) and convert that row to value
  235. logging data from dynamically chaning cells
  236. Formulas not functioning
  237. [SOLVED] Macro for printing
  238. [SOLVED] pick the number from a group
  239. Changes Not Saving
  240. [SOLVED] Counting by categories and dates
  241. [SOLVED] Returning business hrs
  242. Re-naming many excel files in a folder by VBA
  243. [SOLVED] count decimal nos in a range
  244. division between cells
  245. Macro to move cell contents
  246. [SOLVED] How to lock certain cells or columns?
  247. How to change main language?
  248. [SOLVED] Get graphicsdata from different files
  249. Transferring by months
  250. please help, result should meet two conditions