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. Include Computername in data souce path?
  2. Conditional Formatting
  3. length Calculation
  4. isnumber
  5. Copying a picture in a header
  6. Display but dont print cell
  7. different column width
  8. Conditional counting
  9. Sorting a colum by CASE?
  10. Hyperlinking
  11. Statistics in excel with time values (mode, stdev etc)
  12. SUMPRODUCT query - with more than 1 criteria
  13. Missing icons in Office?
  14. Cancelling the Update Values Box
  15. Basic question from infrequent user
  16. Match data
  17. Replacing tags within a cell
  18. Grouping in MS Query - SQL attached
  19. Query spread sheet...
  20. Problem with "grouping" data
  21. Re-registering date and time picker controls
  22. Macro to convert character to hex code in excel
  23. Gray out cells in excel
  24. Should I use Goal Seek, a function, or a macro?
  25. trailing dots
  26. Sorting groups of rows
  27. Save before exit
  28. Command Button Appearance
  29. seeking maximum value
  30. Click to select cell under drawing object
  31. Problems using Hyperlink
  32. What does the option "Background Query" do (option in Pivot Tables for external data)
  33. Timecode calculations? Other questions as well
  34. separate web data
  35. User Form - Mandatory Input
  36. Another Golf Handicap Question
  37. Display the Date/Time a worksheet was last updated (tied to external data)
  38. Else function?
  39. User Form - Drop Down List
  40. Macro: Named Ranges
  41. Simplifying Macros
  42. Invalid external reference to a worksheet (Excel 97)
  43. Hyperlinks
  44. Excel column breakdown
  45. Formula
  46. Overlap Text Into the next Cell
  47. Formatting multiple cell problem
  48. Find and replace values...
  49. Finding the MAX in a group of cell depending on a criteria
  50. Formula or VBS
  51. Drop down in excel
  52. Reference Website
  53. Split rows query
  54. Dependent validation
  55. General Tracking System in Excel
  56. Find All Results
  57. Excel Spreadsheet Colour
  58. Adding Features 'Add, Edit, Delete' to spreadsheet
  59. Alternate row colors
  60. new instance Excel application
  61. Splitting
  62. data management
  63. excel max row number
  64. Anybody been using Excel since the 1980s?
  65. Info from one Workbook showing in another Workbook?
  66. Reference cell based on value in another cell
  67. Find the last occurence of data in a list
  68. week date
  69. Export MS Word file to MS EXCEL
  70. Format currency - euro
  71. Selecting multiple entries from a list
  72. Real numbers representation in excel
  73. Advice on excel project
  74. Pooling date
  75. Linking Access to Excel
  76. Preventing zero when referencing another cell
  77. Linking Workbooks
  78. preventing a cell from printing
  79. How to get date to appear correctly in other cells
  80. Inserting blank row between each data row
  81. adjusting size of list box
  82. Underlined and bolded text causes Excel to crash
  83. HLookup!?!
  84. Macro & error check
  85. extracting data
  86. Does such a function exist
  87. Survey data into excel
  88. On the edge
  89. Conditional formatting question
  90. Concatenate format problem
  91. IF command
  92. Insert a check box in excel
  93. Concatenate Problem
  94. Firstname, Lastname > Lastname Firstname
  95. Entering lists
  96. Conditional Formatting 07
  97. Hidden columns NOT HIDDEN on shared workbook
  98. Text box editing
  99. Splitting an excel file by column content
  100. generate random numbers from a frequency list
  101. Drop Down List
  102. nesting "IF's" & "Lists"
  103. Lookup formula
  104. Data validation arrow
  105. extra page on a worksheet
  106. Text Transforming? Could really use a minute of help...
  107. finding a value in a range
  108. Cell reference to Combo Box
  109. Passing Query String into MS Excel
  110. Cell wrap limit?
  111. Auto populate a form
  112. Formula in a Text box
  113. Summing a lot of data from many sheets... formula too long
  114. Count if criteria is met
  115. Sort cells by first 3 letters
  116. Rectangles, 1000's of them in spreadsheet.
  117. sum of numbers
  118. Link question
  119. Sum Product - partial match
  120. Change decimal places based on selection of the test
  121. Ready to throw my ARRAY formula out the window
  122. saving code to csv file
  123. On Load View Centering
  124. Hyperlink link to worksheet
  125. importing information to a pre-made form from a large spreadsheet
  126. if then vlookup not sure?
  127. Gathering information from one worksheet to another
  128. Why can't I import the entire credit card #?
  129. substitue characters
  130. Formatting cells
  131. Why do we have to use "text-to-columns" to turn text to dates?
  132. if formula
  133. Can you have variable inputs when pulling data from an external source?
  134. Master Pivot table?
  135. Wierd Cell Format Problem
  136. VLOOKUP Returning Blank OR Zeros ?
  137. delete all the extra blank rows at the bottom of spreadsheet
  138. correct syntex for if(today()=......
  139. Compund IF and VLOOKUP
  140. Duplicated row removal
  141. Removing spaces from phone numbers..?
  142. Find
  143. Excel 2003 not locking speadsheet for editing
  144. Text?
  145. Conditional formatting question
  146. How do I make Excel-document load up without menu-bar?
  147. Colouring Cells that remain clear when printed
  148. Statistics question
  149. Deleting extra number in cell
  150. Filtering Question
  151. Summing error
  152. Slow drawings
  153. Pivot Table sorting
  154. Sort by state not working
  155. hide zero and NA
  156. Custom Number Format
  157. If False statement
  158. Transpose? Macro? If
  159. Delete row if Begins with
  160. Add Leading Character to Names in a list
  161. Protecting Worksheets
  162. Date and Text combining
  163. Delete rows
  164. Auto Name Changing
  165. Customer/Supplier management database
  166. Excel not calculating
  167. Rate Function in Excel
  168. How make Excel-document load up in full screen?
  169. Combining 2 spreadsheets
  170. Tab key
  171. Excel 2.007 for Accountants Ebook
  172. adding ' in cells
  173. Making one cell recognise another
  174. COUNTIF with the criteria being less than referenced cell.
  175. Extracting Data Based on Criteria
  176. excel link to Contacts in Outlook
  177. Conditional formatting referencing another cell
  178. Matching range of values
  179. Text to Columns
  180. Hyperlinking/linking cells in different worksheets/books
  181. Formula question
  182. how to make visible formula in cell?
  183. Getting round a password..?
  184. How to delete a fixed term from a formula automatically ?
  185. importing data problems
  186. Anyone knows if it is possible to apply Search and Replace to part of a formula?
  187. Is it possible to place a Sound Alert like Conditional Formating
  188. Formula too long problem.
  189. Access Export giving ' infront of numbers
  190. Unused Named Cells
  191. Count Meetings in Pivot Report
  192. sort data
  193. Conditional embedding of images/animation
  194. Personal.xls vs. Book1
  195. Selecting equally spaced cells and putting the info into columns...
  196. Tricky Excel Code
  197. Converting inputted negatives to positive #'s
  198. Sumproduct or count?
  199. CUSUM for health research
  200. Visual Aid to Cell
  201. actual number
  202. Count
  203. Spread sheet is full of pages
  204. excel data forms
  205. Excel 2.007 drawbacks vs. Excel 2.003
  206. Timer
  207. ASCII code of other langauges like Russian
  208. Matching two columns
  209. counting working days in current month
  210. Compressing data
  211. mutual exclusive write to Excel file
  212. Oil Production/Month/well type
  213. Large data sources
  214. Automatic filling in cells
  215. Last YTD figures automatically updating each month, to compare with current YTD
  216. .BAT file with Parameter in Excel
  217. Trying to count length of sequence
  218. help plz
  219. Nest Min in If statement
  220. Crosswalk Data
  221. Removing Formulas
  222. Subtracting time
  223. # n/a problem
  224. Combining Text from Adjacent Cells
  225. Opening/closing Excel
  226. Today's date in a cell
  227. One from column B
  228. Search a Column
  229. Not working [=IF(G2>=9/1/2006, "2005","2006")]
  230. How do I print multiple excel files?
  231. Anyway to combine multiple sheets into master?
  232. Multiple If Conditions
  233. conditioning format
  234. Free Excel 2003 Certificates.
  235. Spreadsheet won't update or calculate links
  236. Textbox properties
  237. Refresh Form
  238. Filter prompt "Fixed Objects wil move"
  239. Data reverts back to previously saved version
  240. Sumif ?
  241. List Error
  242. Binary numbers
  243. Football Player Evaluation Grades
  244. Error linking between two excel files
  245. Filter Multiple Numbers with AutoFilter
  246. Getting Excel to perform
  247. What can I do to reduce filesize on a MONSTER spreadsheet?
  248. Numbers to Text - 25 - Twenty Five
  249. Serchable database
  250. Interchanging Columns