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. XLViewer
  2. Multi column conditional formatting
  3. Drawing conflict between 2003 & 2007
  4. excel links for beginners
  5. Weekending Date
  6. Drop Down Lists - navigation
  7. pasting fraction... turns into date
  8. conditional formatting
  9. Possibly vlookup
  10. Message when exiting
  11. identify the range according to 1st dp
  12. How to show chart with stack bars on the left and right?
  13. How to substitute #N/A for "0"
  14. I need help with this calculation
  15. Page setup
  16. screen anomaly - small squares between cells
  17. How to calculate with function countinuos average?
  18. How to count numbers with function COUNTIF?
  19. Length of text string to use LOOKUP command?
  20. "If-Then"...
  21. Lookup & Sumproduct???
  22. formatting
  23. Unintentional Highlighting
  24. Date formula
  25. VLOOKUP function
  26. 'Not responding' every time I open databse
  27. Text formula
  28. Blinking Cell
  29. Referencing a cell based on the value in another cell
  30. Setting default validation depending on another cell criteria
  31. Using NETWORKDAYS to find holiday date clashes
  32. Buckets with if formula
  33. deleted data how to recover
  34. XL2007 + SharePoint Import: Format ??
  35. Calling a Sub from Workbook_Open
  36. Missing reference in a named range
  37. referencing cells
  38. Counting number of x's
  39. Counting
  40. Questions from a Beginner-level user
  41. Cell Reference
  42. Can rows be locked with out freezing them
  43. Addative Percentages
  44. Even the simplest of formulas does not work
  45. Number of Monday - Friday weeks
  46. Empty cells taking up space
  47. toolbars dissapeared cant get them back
  48. XML import and Export file
  49. conditional formatting/highlighting cells
  50. Create a Custom Data Entry Form
  51. LOOKUP Query
  52. IF formula error
  53. opening spreadsheet - filename issue
  54. My Chart keeps loosing the format I set...
  55. #Value sign on information in excel updated from web.
  56. closing without asking for save
  57. What is wrong with this If statement?
  58. Isna Vlookup
  59. Excel saying cells not equal but they are...
  60. unable to delete a line
  61. Date less than greater than
  62. Protected Sheet + autosum
  63. Formula for multiple fornames into seperate cells
  64. Multivariate Analysis in Excel
  65. can't insert a new worksheet
  66. Suddenly, Excel won't open often used file
  67. Dividing one cell by another
  68. Copy column without repeated number?
  69. User input into a hidden formula
  70. Display remote PC time
  71. function to count cells
  72. dates
  73. MAX function to make a table
  74. coloring cells
  75. Setting decimal places
  76. Getting data from one column into anothe without copy->paste
  77. Linking to CSVs
  78. Validation List
  79. Help adding unique values
  80. formula only works when saved
  81. changing the default settings of pivot table
  82. Access data in Excel
  83. Opening Excel
  84. How to transpose data from 2 columns into a table?
  85. WTF is going on here with number values?
  86. Unique Random Number generator
  87. Custom Data Validation Formula Limit Restriction
  88. Match Cell Then Copy Alternate to Next Blank Cell
  89. Lookup or Formula?
  90. hyperlink question
  91. data entry- banning duplications
  92. Drop-Down List Explosion
  93. Insert Comment to Multiple Cells
  94. Include an effective date in an existing formula
  95. How can I force Title Case in a cell?
  96. Grabbing specific data from another sheet.
  97. Subtract from inventory
  98. Number Alignment
  99. No new fonts??
  100. Excel reports with web interface???
  101. How to delete a row when a cell value is a "D"
  102. copy/paste information into a sheet.
  103. Playing Video using SnagIt software in Excel
  104. Random selection of multiple rows with two defined categories
  105. multiple users- Share workbook
  106. shuffled deck of cards
  107. 2007 W-2 & 1099-Misc
  108. different fonts concatenated
  109. Default number formatting - Pivot Table
  110. excel data to print format
  111. Countif and Mid
  112. Return every 3rd cell from list
  113. Formulas to convert Personal Names to different formats.
  114. Automating some fun? lookup, pivot...
  115. Validation Formula
  116. Converting a cell's contents to a formula
  117. Matching and Ranking
  118. Pivot talbe with name range excel 2007
  119. Auto filtering?
  120. Averages
  121. =IF(Sales!J9>=45 <=55, 100, 0)
  122. sum bar in PivotChart
  123. Inserting dashes in a 15 character string
  124. Lookup and copy data between two spreadsheets
  125. time calculation
  126. imprinting a worksheet with the directory path with a formula
  127. Parts List
  128. Drop down box dependant on a drop down box
  129. Doing statistics with data analysis add-in
  130. Extract numbers only from a cell containing text also.
  131. search formula
  132. Calculating values against the criteria detailed within this message ...
  133. code to determine if outlook has sent email.
  134. vlookup
  135. Shifting rows of data according to dynamic date update
  136. Format
  137. 1am Overtime in timesheet
  138. SUM using every VALUE IN EVERY 3rd CELL
  139. 3D Name Range
  140. excel default negative numbers
  141. Matching negative value w/ corresponding positive value
  142. Number Sequence and Inserting Rows
  143. Protect Worksheet
  144. Hyperlink To Explorer Folder
  145. Dragging formulas by row reference..?
  146. Scatterplot - Perpendicular Distance Calculation
  147. Postcode check
  148. Date Formatting
  149. Formatting a Cell with concatenation Formula
  150. Formula Signs & Rules
  151. Excel and Multimedia
  152. lookup from 2 cells
  153. "Solver" not available
  154. finding data doubles
  155. Rollover Pic from online folder...multiple records
  156. counting and percentages in multiple sheets
  157. command button
  158. template creation
  159. Conditional format row
  160. selecting cells in multiple worksheets by criteria in formulas
  161. ****High and Low****
  162. Putting The Data From 2 Cells Together
  163. Multiple Excel Macro Warnings
  164. excluding sheets from SUM formula
  165. Validation - Referring to the cell above
  166. Format a row based on text criteria
  167. PRODUCT function problem
  168. adding a rule
  169. Insert Flash into Excel Worksheet to Run Automatically
  170. SUM problem
  171. how to install an application
  172. Countif function?
  173. Lookup question by row data
  174. Certain worksheet not printing on selected printer
  175. Getpivotdata
  176. Excel - won't open with double click, must open Excel then browse for document?
  177. Using Excel on the web
  178. Data Validation
  179. Character \"\" in formula?
  180. Automatic Currency Conversion
  181. Importing data
  182. PC-Mac Conflict
  183. Remove a single character from a cell
  184. formatting question...this is a toughie
  185. Comparing two columns of data that are near identical
  186. Not enough fields
  187. attempting to add multiple values into left footer
  188. What does this Compile Error message mean?
  189. Combining 2 Spreadsheets
  190. HELP!! Copying information from multiple worksheets
  191. Sorting by Values
  192. Problem with matching IP numbers with IP ranges
  193. if statement problems
  194. How to make a pop out message when the pointer point on the cell
  195. transposing problem
  196. integrading visio shapes to excel
  197. How to change the color of the cell when the value in it exceed certain range?
  198. How to use hyperlink to link to a chart.
  199. Rolling calculation
  200. write a multi-column formula for an inventory spreadsheet
  201. Best way to protect a workbook???
  202. Another Date Forecaster
  203. Count Frequency?
  204. Highlighting if a range of cells meet a value
  205. Date Forecasting
  206. If Statement
  207. Financial problem - Excel to the rescue but wait...
  208. Forumulas in colums
  209. Formula to return next month end date after a month end date.
  210. 3 formulas in 1 cell using replace command
  211. Priniting from a database in Excel
  212. Find winning numbers
  213. Variable External Reference:
  214. Design mode problem
  215. VBA code to find item in list and copy adjacent 2 rows
  216. Figuring Vacation Time Formula
  217. Incrementing Alpaha/Numeric count with a formula
  218. highest and lowest value in 1 minute and self updating
  219. Removing Line Breaks In A Cell
  220. Splitting Up 2 Words In A Cell Into Seperate Ones
  221. Formating Cell Number Code
  222. Excel file won't save
  223. About the date format in excel
  224. Text Box within protected doc question
  225. Top 5 Bottom 5 List, and trapping errors.
  226. Copy sheet to WORD 2007 - objects moving
  227. Exporting toolbar
  228. Flow of circular calculation among cells.
  229. If statement - formula not compiling
  230. Keeping a new Style
  231. create border across entire row based on current week
  232. Weighted Average
  233. Using Checkboxes in Macro
  234. Automatically capture cell notes and formatting
  235. Formulas not Calculating
  236. counting occurences
  237. Scale on charts keeps auto-updating
  238. Import Emails to Spreadsheet
  239. if statement
  240. Comma Delimited to Rows, Over 255 Records
  241. Calculating 401k Company Match up to 6%
  242. Time to Numerical Conversion
  243. Date
  244. Pasting multiple lines of text into one cell
  245. single cell printing
  246. drop downs messages
  247. Excel 2007 file save problems
  248. Sum Time
  249. Cell Formatting Question
  250. Any vba code or formula to add cells from new sheets??