PDA

View Full Version : Excel Miscellaneous


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 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270

  1. nested countif function
  2. Dynamic Formulae
  3. Tracing contributors to sum total
  4. Can Excel pick up user name?
  5. rows won't unhide? what am I missing?
  6. Number of calculations in a spreadsheet
  7. Forgotten Password
  8. Column widths when using XML
  9. Convert Formula To Plain Text
  10. Looking for Beta Testers for my Excel Game
  11. Re-arranging Info
  12. Freezing a column and a row
  13. excel index and match
  14. countif question
  15. number conversion after 15th digit
  16. Quadrant Chart
  17. Unit conversion
  18. Cells with @
  19. Convert Referenced Cells to Standard Values
  20. Inserting username.
  21. Pivot Table question
  22. If and Mid function
  23. Sum of cells don't equal
  24. Does anyone know of a way to enter data from a picture?
  25. Question about DATEDIF Function
  26. Expense Report Template Question
  27. formula that will count the number of columns that exists for the value in G4.
  28. saving file to a specific folder
  29. Bug with pivot table ?!
  30. Comparing two columns
  31. Calculating dates
  32. Limiting Text Within A Cell
  33. surname, first name sorting
  34. If and formula
  35. Determining all combinations of numbers
  36. Simple calculation based on "IF"..
  37. Return a list of all the worksheets?
  38. SUMPRODUCT Between Two Dates
  39. sumproduct of positive or negative cells only
  40. cell contents in footer
  41. Adding commas between full names
  42. Percentage not to exceed 100%
  43. About bgcolor within cell
  44. Return a list of all the worksheets?
  45. horizontal matching?
  46. Deleting Multiple Named Formulas
  47. Math Signs
  48. Closing Excel 2003 from Taskbar opens multiple pop-ups / dialogue boxes. Any ideas?
  49. data validation question
  50. word permutation
  51. Create automatically a range from the intersectionS of 2 ranges
  52. Percentage formula not working?
  53. Match Formula
  54. Merging 2 excel columns into one
  55. Display header on first page only?
  56. Hyperlink opens at bottom of worksheet
  57. 0's for missing data
  58. transpose question
  59. Shortcut to toggle absolute $
  60. Combining data
  61. Compute and store average scores
  62. Sequential numbering with gaps
  63. Custom format
  64. print a league performance graph
  65. keeping certain information on the same page
  66. chaning colours if not entry is made
  67. Validating Time entries
  68. How do I paste a particular cell to all worksheets without selecting individually
  69. How to use "IF" statements
  70. Data Modification? .....
  71. Macro reference change when worksheet renamed ???
  72. Can you Change the Alphabetic Column Names to Numbers?
  73. Create a seperate match report
  74. Data validation drop-downs
  75. linking to access
  76. How to know the value beside the largest value
  77. Mail Merge Query - Format of Merge Fields in Word
  78. Count cells only
  79. Make a Pivot Table Sum instead of Count
  80. How to ad a IF in a existing formula
  81. How to add 25 years on to a given date . .
  82. Mail Merge Query - Multiple Excel Worksheets into Single Word Document?
  83. how to create study flashcards
  84. Fill across a cell (Mac OSX)
  85. Problems with Print_Area in Excel 2007
  86. Access data from a delimited file
  87. MONTH Criteria
  88. Excel Formula =ROX()
  89. automatic link updates
  90. How to use IF and AND in a formula?
  91. insert rows only if data is present
  92. Autohide Column
  93. receipt error
  94. Installing Excel 2007 and keeping Excel 2003
  95. Calculating averages
  96. Multiple difficult
  97. Switching Pivot Table Source
  98. formula for payroll taxes w/ limits?
  99. Lock cell until....
  100. How to select phone numbers only?
  101. Do Not Call List Spreadsheet
  102. Scanning barcodes into Excel
  103. Formula For Average
  104. Dynamic URL
  105. Multiple Criteria - SUMIF
  106. Countif and averages avoid blanks
  107. Finding relationships between cells
  108. Worksheet Info. Cuts Off
  109. protect certain cells
  110. Formatting data
  111. make drop down box bigger
  112. Correlating two variables
  113. Creating a Look Up Matrix of Averages
  114. Database Data Entry
  115. Retrieving latest info from a website
  116. Program install directory ???
  117. Chart Legends
  118. Changing the Column and Row header color in excel
  119. Solution : Nested IF or VLOOKUP
  120. Project Bonuses
  121. Adding Barcodes to Excel?
  122. Warn about duplicate entries
  123. concatenate Text and numbers
  124. Cell formula from concatenate string
  125. text to = dollar amounts
  126. Data validation won't clear
  127. Reduce file size associated with background photo?
  128. Opening txt files with Excel
  129. Remove Spaces in cell?
  130. If a value is between, and multile between
  131. Converting time values from AM to PM
  132. Value present in a range
  133. perform a VLOOKUP with concatonated values
  134. Inquire split database with pivot table
  135. Character Limit in Cells
  136. inverting data top to bottom
  137. Excel 2003 "Compile error in hidden module: ThisWorkbook"
  138. shared workbook not releasing user
  139. gross pofit formula
  140. Average of separate cells, exclude zero
  141. How to sumif with multiple range and single sumrange
  142. A temporary fix for 'Cannot Empty the Clipboard' Error
  143. Converting a Date to Day
  144. countif date range + individual
  145. How to compare content of two columns
  146. Formatting bar chart into ascending order.
  147. Forward Slash Problem
  148. Converting text to numbers
  149. Picture If Condition Met
  150. excel timesheet
  151. Excell 2007 Conversion Upload
  152. similar to Mail Merge
  153. How can I convert PDF to Excel with formulas?
  154. SUMIF with multiple selection criteria problem
  155. IF AND formula
  156. Expandable/Collapsible Flow Charts?
  157. shared workbook
  158. Jumping to item in drop down list?
  159. Can't open Worksheet unless have Access?
  160. search for data
  161. IFs for multiple cells
  162. How to keep format when have a reference to a cell
  163. Finding errors in a workbook
  164. Copy page setup for all sheets in workbook
  165. Match Date, Choose Next Value
  166. How do I change the name of a file in a cells formula by linking to another cell?
  167. 'if' 'and' formula
  168. Date Formula - 1st,2nd & 3rd Sundays of each month
  169. SAP download to Excel
  170. Associating prices with drop down list
  171. A column showing first of the month
  172. paste special
  173. Unigue combinations of a set of numbers w/ no repeats
  174. lotus file into excel
  175. When is a "Comment" not a Comment?
  176. Formula for calcualting qty at given std size.
  177. Merge images from Excel fields into Word?
  178. Real-Time Data
  179. problems with links and bookmarks
  180. Instant Notification
  181. Enter Tick Mark
  182. If formula with Ranges??
  183. Showing Multiple Comments
  184. Pivot Table Layout
  185. Sorting sheets
  186. Footer Syntax in Excel
  187. Automatic Excel File Closing
  188. conditional formatting to lock any cell with a formula
  189. #VALUE! - how do you work around?
  190. <Resolved> HLOOKUP
  191. hyperlinks in the tables!
  192. Avoid Spacial paste
  193. number of product use for the day or week
  194. Sorting data
  195. INDIRECT function
  196. Y axis break
  197. ComboBox with Value?
  198. Excel 2007 Autosave
  199. Question about an advertising spreadsheet
  200. Create a coulmn that always has the Formula
  201. Display cell contents on top of solid-filled Autoshape
  202. Formula to work out Inventory
  203. Adding page number to multiple sheets in file
  204. conditional formatting based on currency
  205. "Imbed" Image in Cell on Spreadsheet
  206. variable file reference
  207. Transferring project to a different network drive without braking the template.
  208. chart - what percentage of the chart made up the mode
  209. Merging Duplicate data in Multipule Columns
  210. Count fields with data present
  211. Tex to Number Alteration?
  212. displaying data in descending order (automatically)
  213. Logical construct required
  214. <Resolved> Access/Editing Worksheet
  215. Long to boot a file what to do?
  216. Safety Of Opening Attachments
  217. Time format
  218. Creating A Football(Soccer) League Table
  219. Using the Date to apply calculations
  220. Ignoring nil values in calculations
  221. MOS Certification for Excel assistance
  222. Fill Down Using Keyboard
  223. Grabbing list of inner content from cells
  224. List dependant upon list
  225. Autocopy in word
  226. Excel 2007 (home and studient) and vista
  227. Inserting Data in Excel
  228. Arrow Keys Have Changed!
  229. Question about a combobox on userform
  230. Counting Cells while filtered
  231. Filling Forms
  232. IF statements
  233. Referencing to a file based on its name..
  234. Break link to external access table
  235. Lookup a text string within a table
  236. SUMIF or VLookup problem for 2 data ranges
  237. <Resolved> Date Differences
  238. radioactive decay
  239. color counting
  240. Time trouble
  241. Conditional Formatting with an If statement
  242. Drop Down List Selections
  243. Resolved >>> Vlookup
  244. IF +vlookup?
  245. Indent Function
  246. Indirect.ext, Indirect, GetValue
  247. Counting coloured cells
  248. [SOLVED] VLOOKUP -- automatically change col index
  249. Resolved >>> IF Statemtent
  250. Auto sort.