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] Start End Date calculation
  2. [SOLVED] Is there any limitation for if function ?
  3. [SOLVED] View two worksheets simultaneously.
  4. Sorting data query
  5. Minimized Window halfway off screen - can't move back down
  6. Auto secure cells as they become populated
  7. [SOLVED] Convert numbers with decimals to percentage
  8. Time Question
  9. Formula to reference previous cell in row...
  10. duplicates
  11. [SOLVED] Calculating Non-Numeric Cells
  12. Making the Spreadsheet look like an application
  13. [SOLVED] Date Column
  14. [SOLVED] Lookup to return multiple values
  15. [SOLVED] COUNTIFS and Paste Special Function
  16. [SOLVED] If Then Formula
  17. [Solved?] Changeable master form to update children?
  18. Sharing a workbook?
  19. spreadsheet mapping
  20. [SOLVED] If statement to return blank if cell D1 is empty...
  21. How to sort more than 3 columns
  22. [SOLVED] Formula for Lookup and Count function in new Excel update
  23. Lock cell after single use in shared work book
  24. Pie chart within Pie Chart?
  25. Disable Excel Web Access on MOSS2007
  26. [SOLVED] Macro to initiate on a cell's change in value
  27. Forcing users to fill in a cell before spreadsheet will save
  28. Get rid of Formula1 in a pivot table (Excel 2007)
  29. Look for the Highest Value
  30. Auto count every other column
  31. [SOLVED] Auto Sum a varying Range
  32. 2 columns of values, summing values in column 1 if corresponding number in column 2..
  33. [SOLVED] Simple sort
  34. Determine smallest number of units to make a whole
  35. [SOLVED] Cell reference plus 1
  36. Convert YYYYWW to date
  37. Incrementing hlookup row index
  38. Excel Compression..?
  39. Inserting rows into table, which copy the color of up/down rows. how to?
  40. Problem updating links
  41. [SOLVED] Pivot tables / report filter
  42. [SOLVED] Assign text value, then count
  43. [SOLVED] SUMIFS Help
  44. A friend suggested I try here to solve this
  45. Conditional Format / Data Bar question
  46. [SOLVED] Find the longest run of 0's in a column
  47. [SOLVED] Multiple Excel Checkboxes
  48. Password access to just one column
  49. Automatically count how many boxes are filled in
  50. [SOLVED] check if end of cell is a certain letter
  51. [SOLVED] number sequence
  52. Making a list of names from inputted data
  53. Ontime Method overloading the call stack.
  54. date calculations
  55. [SOLVED] formula for changing date different colours
  56. record data button
  57. [SOLVED] Excel always rounds up
  58. [SOLVED] IF formula?
  59. How could I solve this problem by solver or other functions?
  60. Text/Numbers Formula
  61. entering line number from all-data sheet that will autopopulate info into a form
  62. counting the number of entries
  63. [SOLVED] LOOKUP question
  64. Adding rows depending on user input
  65. [SOLVED] Protecting Worksheets
  66. [SOLVED] How to count the no. of occurrence of certain value if the range is filtered?
  67. [SOLVED] How to add parentheses...
  68. Searching for text strings within cells... how?
  69. Listing different cells from table
  70. backward Vlookup issues
  71. total column to minus what is in the debit Col (E) & add the Credit col (D)
  72. Matching Data in two worksheets
  73. [SOLVED] pulling data from Sheet 1 to Sheet 2
  74. Personal Sheet
  75. summarize thousand route digits
  76. If formula
  77. Adding Rows depending on user input
  78. [SOLVED] calculate duration of hours
  79. automatically display problem ...
  80. Can TEXT from a drop down cell be represented as a value in another cell?
  81. Alphabetizing a column, but ignoring specific words (the, a, etc)
  82. [SOLVED] Formatting cells as fractions
  83. I have 4 sheets - I want a 5th sheet that collects all the data and sorts it by month
  84. formula where we can track changes in different sheets
  85. Very large Excel 2007 doc page file problem
  86. Solve without Solver
  87. MS EXCEL 2007 Upgrade ?
  88. [SOLVED] Calculate daily interest rate
  89. [SOLVED] Time Span in hours
  90. [SOLVED] Formula to find age groups
  91. Import PDF to Excel
  92. celll reference
  93. celll reference
  94. Columns to interexchange
  95. to split the phone number and email id into two different columns....
  96. [SOLVED] IRR function is returning the wrong value
  97. count cell value contingent on other cell conditions
  98. Need Help with Array Formula using Vlookup and MAX
  99. [SOLVED] Finding the max value in a column based on a condition
  100. Weighted Moving Average
  101. Text presentation from an Excel sheet
  102. Determining if numbers span a range
  103. [SOLVED] Control Code input ?
  104. Need Help Badly
  105. Rounding-off Problem...
  106. day of Month to Day of Month of Year
  107. Using Custom Add-ins on Menubar
  108. [SOLVED] Find 1 character and replace entire cell
  109. [SOLVED] Converting A Word/Value To A Number
  110. Counting occurrences of a value within a range
  111. [SOLVED] carrying information from one sheet to another
  112. [SOLVED] Lookup value based on IF
  113. [SOLVED] Ctrl - home isnt going home on sheet for sorting
  114. time conversion
  115. How to convert .mdb to Excel?
  116. My "IF" Problem
  117. Can't save more then 65536 rows
  118. Time Format
  119. Can you mass convert Excel Files from .xls to .xlsx?
  120. calculating rest value by depreciation
  121. removing lost figures from my summary seet
  122. Comparing Columns to Find Matches
  123. Averaging selected data
  124. [SOLVED] List data into table
  125. [SOLVED] Multiple IF Statements
  126. how do i know the formula
  127. excel pivot table add data
  128. Remove duplicates from excel
  129. Countifs function
  130. Automatically Inserting Comments
  131. change alignment
  132. How to restrict people from changing page layout
  133. Can Excel do tally marks?
  134. Working with Worksheet Cell Links & Comments
  135. Cell formula becomes active
  136. Same Cell, all tabs starting with "Spread"
  137. Combine 2 cells (but not if they are the same)
  138. change in sum product formula
  139. Find missing values in logical sequence of letters+numbers
  140. remove period from number in a cell
  141. How To Parse Text String at Carriage Return Line Feed (paragraph)
  142. [SOLVED] how to reference a function from a different sheet
  143. changing colors
  144. [SOLVED] MATCH formula
  145. Making excel remember a pattern based on variables
  146. copy-n-paste one excel file into another.
  147. Database multipe field choices that can be sorted
  148. [SOLVED] (SOLVED)calculating average daily temperature in a greenhouse
  149. Spreadsheet Server Add-in Issue with Excel 2007
  150. [SOLVED] Apostrophe Issue
  151. Exponential Average
  152. Windows in Taskbar becomes unchecked automatically
  153. XML Source
  154. formula question If logic
  155. [SOLVED] SUBSTITUTE excel 2007
  156. Distinct Column B and One from Column A
  157. appending to a cell
  158. mySQL Microsoft Query Criteria Failure
  159. [SOLVED] Cannot remove comments in excel worksheet
  160. Emailing a workbook via a macro - turning the virus warning off
  161. Exclude 0 value in Ranks
  162. I keep getting errors when saving in CSV
  163. Change Test Color If Value is Greater Than Another
  164. If Then Formula
  165. Multiple Input Problem
  166. Looking up page something appears on
  167. [SOLVED] Conditional Formatting - with two conditions within one formula
  168. [SOLVED] formula to calculate staff performance
  169. [SOLVED] Date stamp in absolute column
  170. [SOLVED] showing duplicate values
  171. [SOLVED] zeros at the front of numbers
  172. How can I make this program?
  173. Automaticaly adjusting drawing
  174. Drop down box - Should be an easy one...
  175. Automatic link to file or folder?
  176. Conditional Formatting based on other cells properties
  177. Designing a KPI Reporting app within Excel
  178. Adding rows and embedded formulas depending on user input
  179. how to resolve number problem in excel
  180. Simple data search
  181. [SOLVED] Comparing 2 values.
  182. Displaying summary data on a second sheet based on a IF or TRU test?
  183. How do you return heading back to normal?
  184. [SOLVED] Sumproduct with different ranges
  185. How do i make a paragraph of emails into an excel spreadsheet?
  186. [SOLVED] Adding multiple cells
  187. IF statments
  188. [SOLVED] restricting an "entered number" range?
  189. [SOLVED] Prevent formula from updating when deleting cells / sheets
  190. Default Cell Format Changed
  191. SUMIF or COUNTIF?
  192. IF statement with VLOOKUP
  193. [SOLVED] Conditional Formatting on Date cells
  194. Categorizing labels??
  195. locate row and col insheet
  196. Counting values to create a unique total
  197. [SOLVED] Display last number in a column
  198. Auto-Sequencing Down a Column FC0001 to FC0500
  199. use "IF" to avoid getting anything written after...
  200. Data labels covering each other up
  201. Tracking Man Days Over Months
  202. Range Edit Control - keys do not work?
  203. [SOLVED] Results table to complicated to read
  204. Inverting data in a row
  205. [SOLVED] every n-th cell
  206. [SOLVED] Help Reorganising / Presenting My Data
  207. Creating permanent links between cells
  208. [SOLVED] Time Calculation
  209. [SOLVED] cell protection
  210. Transferring data from one workbook to another...?
  211. open the excel program in read only mode
  212. summry sheet result regarding area and tier
  213. [NOT SOLVED - BUT CLOSED] Can't exit design mode because - Error Msg
  214. diagonally dividing individual cell
  215. Apply formula to a column of numbers
  216. [SOLVED] How to turn off "assume formula"
  217. Invert Headers - MSExcel 2003
  218. I'll Try and make this simple!
  219. Excel to Word
  220. Validating a Cell
  221. Displaying the most recent sheet a search result is in...
  222. Pull data from one spreadsheet to another
  223. Using reference points through worksheets
  224. [SOLVED] Find parent directory
  225. [SOLVED] IF formula problem..
  226. Possible to edit Excel behavior for Time entry?
  227. Change row color if = to todays date
  228. How to import CSV and delimit
  229. Access database exported to excel is not updating
  230. Color problem Excel 2003
  231. Seperate excel documents, insert spreadsheet from template?
  232. How to sort and count?
  233. year to date formula needed
  234. [SOLVED] Make sliders function when spreadsheet protected
  235. Cell References
  236. "The Converter Failed to Open the File"
  237. hard calculator
  238. Transposing column links into row on another tab
  239. Need an advanced text-to-columns trick - break after 1st space only
  240. Cell auto-fill-in when data entered into another cell
  241. Help With Basic Feed Back Loop
  242. Time sum
  243. limited sychonizatiom
  244. Algorithm Matrix
  245. Subtract times from =NOW() cell
  246. [SOLVED] Conditional formatting
  247. Averages for big tables
  248. [SOLVED] changing "FALSE" "TRUE"
  249. [SOLVED] Count Number of Items With A and B
  250. [SOLVED] Calculating Chart Values over large Ranges with catagories