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. Cell Protection
  2. Conditional Formatting
  3. Organising Colums
  4. Formula dependent on cell
  5. place alphabet randomly in cells?
  6. [SOLVED] color the result
  7. I need some help
  8. [SOLVED] Sum with ABS?
  9. How to make three "pages" in one worksheet
  10. need to change this SUM(E3:(INDIRECT("E"&(ROW()-Graph!$B$2)))) to work different
  11. [SOLVED] fill-down formula
  12. Header row is not row 1...how to look up by name listed in another row?
  13. [SOLVED] condition a formula
  14. How do I recreate several spreadsheets the easy way
  15. Chaning a sum total to a text
  16. Digital signature and PDF Conversion
  17. Help Please
  18. [SOLVED] lookup max value and reference from there.
  19. embeded formula
  20. [SOLVED] sorting by frequency
  21. Value Error - How to return blank when value error
  22. Qs: Letter color and column sorting
  23. Send To Email Help
  24. drop down additions
  25. javascript and web query
  26. Pivot Table design problems (% of grand total etc)
  27. Click cell to bring up pdf file
  28. [SOLVED] how much sick time used
  29. is it possibel to have multiple input values in one cell?
  30. Conditional Edit
  31. [SOLVED] Date formula question "workday"
  32. cannot open protected DBF file?
  33. Formula for multiplying range of numbers by 2 values
  34. Referencing every Nth Row from another worksheet
  35. [SOLVED] #ref! & sum
  36. [SOLVED] need help with countif formula
  37. HELP: Time format prob in excel 2007
  38. Moving only certain dates by formula to other sheet
  39. Variables in text
  40. [SOLVED] "If" query
  41. Unable to collapse a group
  42. Windows Updates make Excel run funny?
  43. [SOLVED] Populate a list using credentials from a linked column
  44. Excel Workbook in Email
  45. Change Cell Values to '0' based on contents of another cell
  46. If number in XLSDOC1 matches number in XLSDOC2, colour the line in XLSDOC1. How to?
  47. data validation minus the blanks
  48. [SOLVED] IF and MAX statement
  49. Multiple User Passwords for a Workbook???
  50. Pivot Table calculation
  51. Compare 2 spreadsheets
  52. Multiple IF's
  53. signature in email using excel
  54. Macro
  55. timed save
  56. [SOLVED] Searching multiple columns
  57. [SOLVED] vlookup from multiple columns with only one return
  58. 2003 xl problems saving to 2007 xl
  59. formula result value different than that displayed in cell
  60. Row value concatination for matching rows of another column
  61. [SOLVED] Extract from string
  62. [SOLVED] macro to mark up a complete column by 10%
  63. Cursor locked up
  64. [SOLVED] Data Validation
  65. [SOLVED] Eliminate formulas, but keep data
  66. [SOLVED] #Ref error in chart legend
  67. incrementing alpha numeric field
  68. Cherrypick without ctrl key?
  69. Is it possible to Add Columns into the Middle of Existing Linked Data?
  70. multiple tables in excel
  71. [SOLVED] finding median with criteria
  72. Calculating Number of Pallets
  73. [SOLVED] Calculating a number from answers to an audit
  74. Variables and how to use them
  75. Multiple variables effect on two result cells
  76. concatenating a list of emails
  77. Find a number in a column then assign another cell number for the output number
  78. [SOLVED] Copy and Paste Macro
  79. Formula for a downloaded gant chart?
  80. 3 columns
  81. [SOLVED] Displaying Cell Date with "&" in another Cell
  82. [SOLVED] Sumproduct using blank cells
  83. Removing spaces or transferring columns as one chain of numbers
  84. [SOLVED] Click and Mark a cell with an "x"
  85. [SOLVED] Copying Subtotals
  86. [SOLVED] Help with complex interpolation (Civil Engineering Earthwork Problem)
  87. [SOLVED] Filling in information in Blank Cells
  88. Combining multiple mailmerge recipients to one
  89. Sum & Sumproduct
  90. Monthly hospital admissions data
  91. Inserting in a protected sheet
  92. Automated Popup When Cell exceeds certain Value
  93. [SOLVED] How to get unique value from two columns in a third colum
  94. C# code works fine with Excel2007 but produces exception while running with Excel2003
  95. Dynamically change validation list
  96. ODBC Connection
  97. Frequency Function Pivot
  98. [SOLVED] Auto Filter Get Value
  99. Dynamic Range in Sum Function
  100. [SOLVED] Time formula issue
  101. To retain the value of previous record
  102. Where do I start
  103. [SOLVED] Arrranging Data in equal rows
  104. [SOLVED] Adding data from specific names ugh!!
  105. Compare??
  106. [SOLVED] Adding column values.
  107. highlight values
  108. Excel Case Formula (if/then)
  109. Turning the text of the content of the cell into red in a conditional formula
  110. lining up data
  111. Predictive Model Formula
  112. [SOLVED] Excel w/ Word Drawings to PDF = Graphical Noise Glitch !?
  113. [SOLVED] conditional, variable formula
  114. [SOLVED] vlookups
  115. [SOLVED] Complicated Template
  116. Protecting a range of cells (with password)
  117. [SOLVED] Adding Time
  118. How to delete a worksheet w/out activating it
  119. Organize Dates
  120. conditional format?
  121. Pivot Table, filtering on individual counts, not total
  122. [SOLVED] Number Format and Duplicates check
  123. Problem with Importing Data from Webpage
  124. Does anyone know if these guys are legit?
  125. #n?a
  126. Need to separate path names and leave the .exe
  127. Formulas that direct you through a path
  128. Finding multiple cells that add up to a desired amount
  129. Extending formula in a column automatically to lower rows
  130. Decimal points where they shouldn't be
  131. formula to move only certain dates to other worksheet
  132. ODBC Connection to MS Project
  133. [SOLVED] Automatic counter
  134. [SOLVED] Summing in a VLOOKUP function
  135. Auto Filter - Number of records
  136. Expanding a Cell based on another cells contents
  137. Excel spreadsheet table auto generate fixtures
  138. Splitting Excel sheet by identifier
  139. How to create unique numbers in a column, like the autonumber function of access
  140. 2 lists of numbers, I want to match them up
  141. Counting multiple Colour Cells
  142. [SOLVED] Capture some characters within the cell
  143. Find Match in Excel 2003
  144. [SOLVED] Replace Function problem
  145. Algorithm matching clocked hours to required hours
  146. Weird? Phenomenal.
  147. Test if a number match one of a range
  148. Excel VBA to Data Mine: What if website doesn't update?
  149. Convert this formula to a value
  150. Find and delete UserForm
  151. Formatting cells
  152. creating a booklet from multiple worksheets
  153. Date a worksheet was last updated
  154. is this an index or combination with lookup
  155. using 1 cell info automaticly if another cell has no data in it
  156. [SOLVED] lookup with mutiple returns
  157. Calculate Date difference in pivot table
  158. Formula Bar Obscures Column Headers
  159. circular reference question
  160. Hidden Code In WorkBook
  161. Multiple-level value generation
  162. entering a formula after a random range
  163. Turn numbers into a range
  164. why does excel open some files as csv?
  165. Can I move sheet tabs from bottom to top?
  166. [SOLVED] Excel 2000 - show billable days
  167. Using a drop down list to populate a different cell
  168. disable PASTE function?
  169. Average in Hours of Two Date Ranges
  170. Sorting Various bits of data
  171. Text conversion to Month
  172. [SOLVED] Serial number date displaying incorrect day?
  173. Unknown Cell
  174. Protect a sheet BUT allow drop downs?
  175. Cell Formatting
  176. Formula required - matrix!
  177. [SOLVED] excel logical formula
  178. [SOLVED] change excel defaults
  179. Print Area
  180. Information from a list to a letter
  181. How to plot 3 data sets on the same line graph, but not connect the data?
  182. Auto summarise
  183. Removing BOTH duplicate entries
  184. Hitting Enter
  185. [SOLVED] Limiting number of characters in a line
  186. ask - make some workbooks in one file
  187. addition formula not working
  188. [SOLVED] Highlighting the duplicates in Eight rows:
  189. Code problem.
  190. If, then formula
  191. Drop down delivers different data
  192. Need to add 10% to entire worksheet...
  193. [SOLVED] Transpose values all cells from Sheet2 to Sheet1
  194. Cannot Format Cells
  195. How Do I...
  196. [SOLVED] Removing #DIV/0!
  197. [SOLVED] Repetition
  198. Excel 2007 - Can find pivot table field list
  199. drop down text formula
  200. Pictures altered when sorted
  201. Notepad data to excel convertion
  202. Formatting data in excel
  203. Maneating Formating text
  204. [SOLVED] Excel bug ? for SUMIF
  205. Row height question
  206. Macro To Compare date and send E-Mail
  207. [SOLVED] If statement
  208. Subtotaling based on date in a column
  209. How do you calculate entries between months?
  210. How do you trigger calculations?
  211. Count if with Multiple conditions
  212. [SOLVED] Copy and paste a cell value
  213. Giving Text a Number value
  214. systems dynamics and excel
  215. Macro to auto log data between sheets
  216. Set row background to transparent ?
  217. [SOLVED] Cell definition with 3 assumptions
  218. Calling a macro through another spreadsheet takes forever!
  219. [SOLVED] Using ' in cells
  220. Data Form on protected worksheet.
  221. Removing spaces throughout various fields
  222. [SOLVED] Calculating Percentage based on Dynamic Cells
  223. [SOLVED] How do i order selections contigously
  224. [SOLVED] Simple Help That Wont Take 2 Mins Please.
  225. [SOLVED] Custom format, combined date, time and letter
  226. [SOLVED] Find and Copy
  227. [SOLVED] Certain Columns to Rows
  228. [SOLVED] if and - if or statements
  229. [SOLVED] Is there a way to delete decimal numbers only?
  230. Summing values conditionally
  231. [SOLVED] Combinations using Formula
  232. Occurences
  233. Temporarily suppressing cell content
  234. Autosum returns incorrect value
  235. [SOLVED] Similar Groups in a Column
  236. excel as a data base
  237. How to click on a cell and call up info from another worksheet or file.
  238. Working with negative numbers
  239. Trying to calculate minutes using Sumproduct Formula.
  240. Value and Codes
  241. get a second large ?
  242. a formula to read values from other sheets - Pivot Table
  243. Custom format pence
  244. [SOLVED] Summary of Cells on Main Sheet
  245. Help with a mega argument formula
  246. smallest number not zero
  247. Adding Tabs of Same Sheet How to Update Summary Tab
  248. [SOLVED] How to calc stdev but to exclude 0's. Prefer no array cntrl + Shift + enter calcs
  249. Worksheets opening up when excel starts
  250. Collating data in several columns