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. Calender Fomat
  2. Row Highlight
  3. Shift Rows to Columns in Excelsheet
  4. "Sort" problem
  5. Find The Monday!
  6. Problem nobody can solve!!!!
  7. merged cells value
  8. Move sheet. delete row
  9. insert column default format same as right
  10. Mass number tables
  11. a formula needed
  12. Paging daddylongleggs - lookup question part 2
  13. Using the higher value
  14. Excel files from "My Documents"
  15. Indirect Function
  16. SUMIF query, possibly...?
  17. Sum up several sells from different sheets
  18. Identify parts of an image in excel
  19. golf tournament scoring question
  20. Cash Flow / Value Apportion
  21. Subtotal coded amounts sorted in numerical order
  22. Drop Down List
  23. Spell number
  24. Lookup ignoring values and at different row sizes
  25. Mac Keyboard
  26. How to seperate a date and time from one column and make into 2 columns?
  27. Moving pivot totals
  28. Comparing two spreadsheets
  29. auto correct data
  30. Searching for words in cells
  31. Conditional row count without using a pseudo column
  32. Match Data
  33. between numbers formula
  34. Dates, conditional formatting and vlookup
  35. formating list box using forms
  36. Using Wildcards in Find & Replace
  37. Help
  38. Changing Header Based on Page number
  39. Insert Column dynamically - VBA
  40. excel closing - no error messages
  41. Fill in the blank cells
  42. Automatic Invoice Numbering
  43. How do I ignore negative values in a formula
  44. Contextual spreedsheet with auto transcribe certain data to other sheet
  45. Index & Match - Individual Cells
  46. Subtotal Lost
  47. Automate filtering of multiple lists and transposing results onto another worksheet
  48. Pull down menu functionality
  49. Best way to present data
  50. Subtotal positioning
  51. Workbook sheet change problem
  52. Retaining Arrow Format
  53. Flash
  54. importing/filtering text data into columns
  55. How do I paste a huge amount of text into 1 cell?
  56. Protectiong Cells
  57. hyperlinking object files
  58. Leaving the Arrow Visible in a Data Validation List
  59. V-Lookup for numbers in various formats
  60. Problem with multiple IF statement
  61. Date Import Issues
  62. Pulling data from source files
  63. How can Ignore blank cells when using a macro for copying and pasting
  64. Look Up
  65. How to get new personalised bouton
  66. Roll Over Cell
  67. Inserting Rows that contain merged cells
  68. I need to link two different workbooks
  69. return a value from a range
  70. Line of Best Fit
  71. Printing 2 pages on one page
  72. Formula to convert times.
  73. Formula Help!!!!!!!!!
  74. Default date format
  75. Dynamic auto fill one worksheet based on date entered in master document
  76. INDEX & MATCH 365 Days
  77. Help needed with SUMPRODUCT please
  78. Selecting a value based on certain sriteria
  79. Finding the the last cell address for writing macro
  80. Excel Password Protection Error
  81. changing the year in more than one cell
  82. Excel Web Query decided to stop working - please help!
  83. Excel Calc Error : 14 <> .14*100 ?!?!
  84. Need help in Deleting custom dups
  85. Sorting a list of values and having the top 5
  86. Returns # of years, months, and days
  87. Match
  88. Pivot Table updating in Shared Mode
  89. Magnified Cell
  90. Summing difference of ranges with search criteria
  91. autofilter criteria linked to cell reference
  92. ROUNDUP Questions...
  93. Data Columns drag to other worsheet in rows
  94. what does the ! mean?
  95. Hyperion Retrieve
  96. Adding A Function On A Column
  97. Rounding problem
  98. How to extract multiple instances of a keyword from a cell?
  99. Find the closest date based on 2 variables
  100. Date and time Date not required
  101. If code for macro
  102. hyperlinking to pdf bookmark
  103. Printing filling the entire page
  104. Having diferent ranges of values depending in a select option....
  105. Pasting paragraphs on one line?
  106. Worksheet Security Measures
  107. How can I hide all rows that are empty?
  108. Displaying Multiple Values froma List Box
  109. Carrying on a Sequence?
  110. Count the length of a text string in a cell
  111. SUMIF for multiple variables
  112. How to Enable Horizontal movement, after hitting the enter key
  113. Question: Building an XML Template to open recurring data files
  114. Looking for MAX values under conditions..tough one!!
  115. Student Class Schedule Checking
  116. How to automatically refresh formulas?
  117. functions including several excel sheets
  118. Sort Rows by Colour
  119. something Wrong with my formula...Help
  120. Solver: Getting multiple combinations
  121. External refenrece non valid
  122. text import wizard
  123. Lookup Help
  124. Avoiding copyright symbol
  125. Macro to go to Macro
  126. Lookup question
  127. activating cell based on option selected
  128. Excel dependent drop down forms?
  129. Find and replace dates
  130. Add a date to a works tracker , which up dates my yearly planner calender.
  131. rounddown added to a formula
  132. Remove uninstalled left behind add on
  133. Comma separate keywords
  134. Forumla to update changing totals
  135. Copied worksheet, large size, slow loading
  136. Conditional Format for a Range of Cells
  137. If statement with nested Vlookup and Sum
  138. 2000 protection workaround
  139. Request to help on "Data Validation"
  140. displaying formula in cell
  141. Combining data from several worksheets
  142. Can you help me fill in a series?
  143. Extract Info From a Cell
  144. Conditional formatting for more than 3 conditions in Excel 2002
  145. Uploading?
  146. Inserting data horizontally
  147. Problem with an IF Statement
  148. Probability/Formula Help
  149. Help w/ Lists / Filtering
  150. sum with a changing number
  151. Need Help Asap
  152. word count
  153. Data Validation
  154. prompt user to fill out particular cell
  155. Data Validation
  156. Missing links
  157. Save
  158. Weird Problem
  159. cell information
  160. Looking for a formula
  161. Sumproduct - Alternative
  162. List Total Text
  163. Parse a Spreadsheet
  164. Excel Autofiltering Help
  165. changing text to cell reference
  166. How to find the first value upwards in a column.
  167. find specific character in a cell
  168. Formula's for
  169. new to exel question :)
  170. Dynamically change number format of a cell
  171. Five-digit Number Format Codes
  172. Display Unique Values In A Range
  173. Populate Column?
  174. Custom Number Formatting
  175. Date calculation
  176. Conditional formatting for more than one cell (a row)
  177. Urgent! Please Help
  178. Looking for tutorial on userform
  179. Question re count option in Excel
  180. Help with a Do...Loop
  181. Password protection and updating
  182. Format of Dates on Graph
  183. Sorting calculated dates
  184. excel single cell edit
  185. Converting Excel 2007 file to view through Excel 2003
  186. mapping and matching data from different sources
  187. Existing formulas will not calculate
  188. Import 50-100 xml files from multiple folders
  189. Referencing a cell to another sheet
  190. Pivot Table Question
  191. Thread missing
  192. Formula as Text
  193. Updating Links
  194. Conditional Format based on 2 scenarios
  195. Excel 2007 keeps crashing
  196. help with =sumif statement
  197. Need to add a sequence of numbers like 1,2,3,4,5
  198. If A1>0 input the higher value of X or Y
  199. Calculating percentage consistently with debits and credits
  200. from worksheet to webform
  201. Converting cell format to time value, very frustrating
  202. Pulling information from 1 of 3 Workbooks
  203. Cannot shift objects off sheet
  204. help with stubborn code!!!
  205. Cells format as individual pages
  206. Race results
  207. Import Multiple Files To Multiple Sheets in One Workbook
  208. conditionaly merge excel files
  209. Timesheet Formula
  210. Forumula/function/code help needed.
  211. Given date returning day of the week
  212. pulling month from date
  213. Modifying dates?
  214. Sorting within subcategories?
  215. "time" for a timesheet.
  216. Dont understand excel error
  217. Calculate number of weeks
  218. help with if/then formula.
  219. Allow only one cell entry in a row
  220. Changing certain columns from vertical to horizontal?
  221. Cool new tool for Excel Online
  222. Remove subtotals from multiple sheets
  223. Remove page number "watermark" from background...
  224. Auto fill of date (day of week)
  225. Automatic Row Height Adjustment
  226. color temperature plot
  227. Posting cell calues on a web page?
  228. Worksheet Security/Locking
  229. Compounding interest
  230. Converting a Word Table to Excel: restore carriage returns
  231. Transferring functions across worksheets
  232. Transpose This
  233. Renaming a named range
  234. Making sheets look the same with one click?
  235. Can you change the format of copy/paste?
  236. 20 min to calculate
  237. Comparing Columns
  238. Assigning cells based on date
  239. Finding weekends and holidays in a list of dates
  240. Remove both instances of Duplicate.
  241. Generating Dates
  242. Protecting Format Only
  243. Multiple Data help
  244. change words into numbers
  245. Excel: Linking Help
  246. Median - Excluding Zeros in a Range
  247. Changing 51707 to 05/17/07
  248. activate/deactivate hyperlinks
  249. HTML,Excel, Email
  250. Trying to get &1 to be plus 1