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. Issue with Vlookup over 3 sheets
  2. VLookup Not Updating New Data in Table
  3. Conditional Formatting
  4. to enumerate
  5. Match and Highlight Characters in a Range
  6. Sales Commission Calculation
  7. "Scrolling" Sheets within a same file
  8. Timesheet / Overtime rate calculation
  9. Access Export to Excel
  10. Add leading zeros to existing data in a cell
  11. Calculating Overtime (after 40 hours worked)
  12. formatting/formula question
  13. Custom Format
  14. Pivot table count
  15. IF function
  16. Counting occurances in a column
  17. Vlookup referencing tab name
  18. commission
  19. Duplicates
  20. Link formulas to Zipped excel files?
  21. Print path data saved in Excel
  22. Excel if and vlookup
  23. Search in Excel database and sum the contents
  24. Zip file on Save ?? - Excel 2003
  25. Built-in Date Filters in Excel 2007
  26. Pivot Calculation
  27. Help wanted
  28. Macro for Automatic Excel Charts
  29. Extract First Name from Full Name
  30. Difference Formula
  31. Text file opens "fixed width"
  32. Grouping by inconsistant values
  33. Unencrypting a variable
  34. case sensitive validation
  35. Change Location of A1 Excel 2007
  36. Text is going out of cell
  37. Extracting Excel Records
  38. Naming a range of cells
  39. lookup question to automate spreadsheet
  40. Costa Rica phone numbers
  41. Excel MCQ's
  42. Adjust Scroll Node ???
  43. lookups
  44. concatenating date and time
  45. Adding up Individual values
  46. Excel Metadata and HP Job Storage mode
  47. Inserted objects in excel not opening
  48. Latest MS Update Breaks Excel 2003!
  49. How to make any characters typed in a range uppercase
  50. save as xml
  51. formatting characters showing in datasheet
  52. Printing Headers/Footers
  53. Create a calendar
  54. Summing data
  55. trouble extracting data from a particular website
  56. data accumulation
  57. Calculating Net Working Hours.
  58. Excel formatting question
  59. Twisted Dates
  60. Concatenation
  61. Importing PDF's
  62. Cell Reference + 4 rows
  63. Excel 2003 - updating multi worksheets..
  64. Splitting Cells with Line Breaks
  65. how do i open csv data files into seperate sheets ?
  66. 2007 Edit Links
  67. Import from Excel to Visio 2003
  68. How to Disable New Excel Instances???
  69. counting the number of multiple unique patients entries
  70. Repeating work sheets
  71. If statement to return blank instead of zero
  72. Editing Data when its been Vlookup'ed
  73. Using Excel for a booking System?
  74. change the color of a circle according to statement
  75. A Form and Drop Down Box
  76. Erroneous link update message on open
  77. create a dropdown list that when I choose a title such as "cleaner" the adjacent cell
  78. Format problem
  79. Check boxes or List boxes?
  80. Linking hyperlinks
  81. Price Grid with Percentage Change
  82. Round
  83. Associating .xls files with Excel 2003 when Excel 2007 is installed
  84. Repayment Calculator
  85. Random number generator and matching all numbers
  86. calculate the number of mondays between 2 given dates
  87. Multipul lines in a cell
  88. If statement with "left" condition applied to a date
  89. MS Releases 4 Critical Office Security Patches (3/12/08)
  90. Copying data from 200 worksheets into 1
  91. Adding an updated/revised date/time on the end of row.
  92. choices
  93. Sorting numbers a specific way?
  94. LINEST driving me crazy
  95. Find/Replace Help - Sports Ranking Data
  96. Reference Function Help - Sports Ranking Data
  97. Timetabling
  98. Changing cell background color automatically
  99. Data not displaying in pivot table
  100. Unique Job numbers in Excel
  101. Vlookup to return 0 instead of #N/A
  102. Combining Multiple Fields with Duplicate Data
  103. total of different items bought per month
  104. How to replace data in one row with values from another?
  105. English formulas and short cut keys on danish Excel
  106. Macro's
  107. Multiple If Then Vlookups.
  108. Calculate the percentage of a column.
  109. Counting Values Based on Criteria
  110. Formating When Transposing
  111. Capitialization of names
  112. Linked Data
  113. Open Hyperlink in New Window
  114. Converting a Hyperlink to Show Actual Email Address, Not Be a Link
  115. Counting the number of formulas in a spreadsheet
  116. Lookup issue.
  117. have a specifc list appear based off of a name (see details)
  118. More than 7 IF's Nested?
  119. Pulling rows from one worksheet into another
  120. Refresh Web Query
  121. Consolidating Spreadsheets
  122. calclations between times
  123. Conditional Formatting
  124. creating printout from Column values
  125. calculations between time
  126. Indirect & Vlookup
  127. Excel Permutations!
  128. all the possible permutations of six numbers in multiples of 10 equaling to 100
  129. Saving Into HTML Format
  130. Average / Percentage
  131. Pivot Chart (Changing data sources)
  132. Excel File shows different data on different PC'S
  133. Separate a range of numbers
  134. Excel files on other PCs
  135. Gridlines!?!?!?!?
  136. How can I use xml file format
  137. formula to seach and accumulate data from another sheet
  138. Major Formula Problem
  139. Filling Question
  140. pivot table is red!
  141. Excel File Fails/Closes When I Save
  142. Caclulation
  143. complicated filtering of my list
  144. Sumif
  145. web query programming questions.
  146. Pasting folder pane info into Excel
  147. Advanced Filter issue
  148. Feeding Excel Contents into a Word Doc
  149. Filtering
  150. Concatenate Problem
  151. cell manipulations
  152. Automatically change 3 different sheets
  153. Multiple Pivot tables using single Pivotcache
  154. Mass delete mailto: entries in cells,
  155. Print Preview option
  156. YTD Percentage Formula
  157. Max 3 Results
  158. Days as per month.
  159. Changing report to auto sort
  160. Formula to return a list based on user input
  161. Converting date to month/year and sorting
  162. Exporting with Text Identifiers
  163. Validating formulas in cells
  164. Conditional formating not working on #Value!
  165. Delete last 9 characters from a cell
  166. Combining Excel columns
  167. Mid and Find function
  168. Keyboard symbols changing only within excel
  169. conrtinued sequence
  170. Autocopy formula
  171. unmerging cells and repeating data
  172. Sum amounts with same code in another column.
  173. Compare two lists using Pivot Tables?
  174. Text vanishes in print preview
  175. Can excel recieve emails
  176. Manual Cross Tabulation - Pivot Table Question
  177. Extracting and saving data from .csv file
  178. have a cell change colour when selected?
  179. to unhide more than one sheet at a time?
  180. Linking from Excel 2000 to a map
  181. Difference between two months
  182. using PopTools in Excel for complex problem
  183. Automatic fill incriment
  184. Random Text Selection
  185. Find duplicate sources
  186. Column Field w/i OFFSET Function
  187. forumla to return the value that a cell had on a specific date
  188. How do I make summary using a pivot table
  189. Format Cells?
  190. How to highlight the selected cell
  191. Import Data or Lookup
  192. Why can't I see the Cursor in Excel
  193. about if formula
  194. Rounding Multiple Numbers
  195. Macro Code to find and replace text in every worksheet not working
  196. Sort Error
  197. Somproduct
  198. Sheet tabs
  199. Identifying the number of unique values in an array
  200. How can I read hard disk serial number from excel?
  201. Eliminate Special Characters
  202. Two versions of the same file?
  203. Calculate total leaves available
  204. sumproduct/or
  205. Link warning
  206. external data
  207. Option Buttons. How do you change size ???
  208. date and time stamp
  209. Replacing a worksheet in Excel
  210. Trying to plot 2 graphs with different axis in one
  211. How I Lock my Excel Documents to specific computer(s)?
  212. Combination query in excel
  213. Replace a Cells contents after a value is entered
  214. Auto Replacing words?
  215. Commission schedule formula
  216. if function for dates
  217. IF Function?
  218. Color Change when selected
  219. Rounding down
  220. creating a ledger sheet from a workbook
  221. split up an address block
  222. Macro for creating a pivot table
  223. Strange cell behaviour
  224. Odd Problem Using Time Date Function
  225. Combination challenge
  226. userform textbox calculation
  227. divided by zero error
  228. returning Specific Text
  229. How to reference a different sheet with a long formula?
  230. Fantasy Baseball Draft Workbook
  231. Moving Words in One Cell to Another
  232. preventing page break in a group of cells?
  233. Opening file
  234. List Autofill
  235. Sumif?
  236. Seeking Wisdom - Community Service Spreadsheet
  237. unique use for autofill
  238. excel 2007 saves everything as read only
  239. identifying duplicates
  240. replace the 11:30 with the letter C
  241. Merging two tabs in excel, into one
  242. Show Current Month
  243. Date and Data Locking?
  244. See all cells referencing a certain cell
  245. Excel Data From Web Problem.
  246. Selectively Pull Records Into Master Sheet
  247. If cell has Hyperlink code
  248. Non default functions in pivot tables
  249. search for word in string of text = true or false?!
  250. search for key in string of text & return position in that string