PDA

View Full Version : Microsoft Excel Misc


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

  1. How to convert or transpose variable list into table
  2. Re: Suddenly a caret sign appears every time I type an equal = sign
  3. Re: Populate 2 worksheets based on a master.
  4. How pull ID#s that meet specific "yes" requirements
  5. Numbers change in cell even when formatted as text
  6. Re: Dragging Cells to Create Ascending Numerical List
  7. Bold rectangle cursor in VB Editor
  8. Re: Formula result not displaying correctly in cell
  9. Re: Conditional formatting - using a value to control color of bar
  10. Column Chart with one of them Up Bottom - Is that possible with Excel?
  11. Re: files wont open
  12. Securing an Excle File?
  13. Greater Than Symbols and calculations
  14. Why this paste result?
  15. problem with fractions to decimal
  16. Re: Next July 1 or January 1
  17. Re: Next July 1 or January 1
  18. Re: Data Validation Error Not Working On Paste Special Values
  19. Re: Data Validation Error Not Working On Paste Special Values
  20. How to convert , comma to . dot in excel to do the following calculation?
  21. Re: If function with lots of criteria
  22. Re: This has got to be fairly simple, so...
  23. Re: Find First Negative Number after 'X' has been reached
  24. Re: Find First Negative Number after 'X' has been reached
  25. Re: Filling Empty Fields
  26. Re: Filling Empty Fields
  27. Re: How to Search down a column fo a specific number of digits
  28. disable f lock on HP pavilion dv7-4277
  29. Re: converting money formatting
  30. Re: converting money formatting
  31. Merge Multiple workbook sheets into one workbook
  32. Merging multiple columns into one column (dynamically)
  33. Find the max number of objects to be placed on a surface
  34. Re: Automatically Repeating Rows on Each Tab?
  35. Macro to duplicate row based on cell value
  36. Re: Removing Line Breaks Within a Cell
  37. Re: How to restore a file ??
  38. Re: How secure are Excel passwords?
  39. Re: How secure are Excel passwords?
  40. making a map with excel data
  41. Can I get date in this format?
  42. writing a sort macro
  43. Pivot table filter list - listing irrelevant subcategorys
  44. Using AutoFilter from VBA
  45. Stacking data in 3d Line graph with a multidimensional array [10][4][10]
  46. Activating hyperlinks
  47. Re: Formatting a Spreadsheet
  48. Formula help
  49. Re: Need IF Statement to yield percentages
  50. Re: Help/Check my Formula
  51. Re: Help/Check my Formula
  52. two macros together
  53. Excel Query setup
  54. What does { } mean in excel formulas?
  55. What does { } stand for in excel formulas?
  56. Starting a new line
  57. Trailing 30 days sum calculation with excel
  58. What does "" mean in Excel?
  59. Sum value in all columns that their title is the same
  60. Re: Can someone fix this IF(AND) for me?
  61. How to STOP Excel from changing my data
  62. Re: Split Business Name and Address into 2 fields
  63. counting blank cells within two columns
  64. Re: Dropbox change Trigger an event
  65. Excel to PDF or XPS boilerplate routines
  66. alt down arrow shortcut not working
  67. problems getting this macro to work
  68. macro to print xps then save with name value in (B2)
  69. Re: Sending An email through Gmail without STMP
  70. Re: Random time?
  71. Re: Associating messages with random numbers?
  72. Re: Locking Macros from being edited, but not viewed.
  73. Re: Locking Macros from being edited, but not viewed.
  74. Remove date format?
  75. Re: Help with an Excel macro please?
  76. Cannot copy worksheet to another file
  77. Splitting cell contents into other columns
  78. Re: how can i ask excel to find "Event" AND NOT "Eventdate"
  79. Excel Issue with "Average" showing in Status Bar
  80. Set chart series endpoint dynamically
  81. Re: End(xlDown) Issue
  82. Power Pivot Variance Column
  83. Re: how to get the total of two lines
  84. Re: how to get the total of two lines
  85. Re: how can i print non adjacent pages from a worksheet
  86. Re: how to add a combolist drop down to each row
  87. Re: how to append a phrase to a cellcontent
  88. Re: how to append a phrase to a cellcontent
  89. Re: why the macro is not included in the list?
  90. Seeing Two Different Excel Files At Once: How, please ?
  91. Re: what are the posting options in excelbanter?
  92. Lookups In Excel
  93. Pivot Table with Data Model Connection - getpivotdata #REF error
  94. Re: how to get a simple macro to paste value
  95. Re: how can i change a sequence of numbers using find replace
  96. Re: how can i change a sequence of numbers using find replace
  97. Re: Flag or Delete a line from Sheet 1 if a wildcard search matches from an Exclude list of words in sheet 2
  98. Copy unformatted value of cell via macro
  99. Excel 2007: Help creating a macro that will run Solver?
  100. Excel 2007: Help creating a macro that will run Solver?
  101. Excel 2007: Creating a macro that will run Solver.
  102. Re: is it possible to ask excel to input from another sheet?
  103. Re: is it possible to ask excel to input from another sheet?
  104. Re: if there is a blank ,how to get the blank cell in a range be highlighted
  105. Format Cells
  106. Re: Calculation based on year of entry
  107. convert CSV to XLS format using command
  108. Countifs or a pivot
  109. Re: Complicated Match Formula with conditions
  110. Exporting Data From Excel to SQL
  111. Split cell based on uppercase letter
  112. Pivot Table Counting Text Data
  113. shortcut-> deleting entire row (not just the data)
  114. Formula IF
  115. Need a formula for a descimal integer into a whole number
  116. Re: Find text in cell and copy from 4 characters in front of the found text.
  117. Re: Inserting a colon into text
  118. Re: Persistent "Formula refers to empty cells" error despite cellsevidently NOT being em
  119. Creating sequential numbers plus a letter
  120. Re: IF formula with certain conditions to achieve a desired value
  121. Expanding Date formula
  122. Entering a Text Symbol ?
  123. Having Blank Cells, etc. ?
  124. Sharing workbooks limitations - Merged Cells
  125. Re: The picture is too large and will be truncated
  126. PLS HELP ME TO SOLVE THIS PROBLEM
  127. Re: Can the IF function be used with values from multiple worksheets?
  128. Re: Drop down in Graph (excel 2003)
  129. Re: Persistent "Formula refers to empty cells" error despite cells evidently NOT being em
  130. Re: Golf scores
  131. Re: Inserting slashes in dates in Excel
  132. Conditional formatting for time
  133. Re: "natural join"
  134. Re: if row has duplicates, concat entries in another column?
  135. Re: if row has duplicates, concat entries in another column?
  136. Help with formula
  137. Re: Default font for comments
  138. Re: Default font for comments
  139. Re: Password protecting multiple pages, and then some.
  140. Code to format cells on several worksheets
  141. please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? i got macro which works with 4 digits
  142. data spans multiple rows within each cell is collapsed when FILTER is used
  143. When sharing, can I force an Excel document to open in a certain view?
  144. Re: Graphics in a Cell Comment
  145. microsoft excel has stopped working message giving by program
  146. How to delete ALL cells containing the same data --- REVISED
  147. How to delete ALL cells containing the same data
  148. Dates, And Their Corresponding Numbers: How To Show ?
  149. Re: Enter carriage return in Excel 2010 text string
  150. Re: New to Banter...
  151. Re: Parsing
  152. How to print cell # while printing in excel
  153. Re: When I insert a worksheet the cell format is accounting
  154. Re: Sorting Revision Labels in Excel
  155. what do these ----> {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula?
  156. Re: Standard Deviation and Averages based on criteria
  157. Email notifications, does this forum have that deature?
  158. How to filter rows data based on background color of individual cells
  159. Print on only one page
  160. Re: Pie Chart and Table Query
  161. Re: IF Statement accepting only positive values
  162. Trendline Not Appearing In Chart Problem ?
  163. Keep spreadsheet on pc & laptop in sinc -how?
  164. Excel CSV Files; Creating Of
  165. Excel And Notepad
  166. Re: How to Update SUM formula after inserting rows
  167. Re: How to Update SUM formula after inserting rows
  168. Quote Marks Question
  169. For Claus Busch: From OP Re Quote Marks.
  170. Re: Comparing two lists in Excel
  171. if statement with vlookup
  172. Adding Quote Marks To A Very Long Column. How, Please ?
  173. Macro to push data to another workbook
  174. How can I keep a zero at the beginning of a mobile number?
  175. How can I keep zeros in the beginning of a mobile number @
  176. Re: Help with Sumproduct searching cell contents
  177. Re: Help with Sumproduct searching cell contents
  178. Re: If Function neglecting 0 as a number
  179. Re: If function..please help
  180. Re: Need help with IF statement (function)
  181. Re: Need help with a formula...
  182. Re: Need help with an IF Function
  183. Re: Need help with an IF Function
  184. Re: Locking Pages and/or Workbook
  185. Re: Search cell value in same column
  186. Web Query
  187. Pivot Table - Row Label Combination
  188. Change Color of cell
  189. Re: export data by selecting date range
  190. Re: Find value based on two lookup values
  191. VLookup or Macro?
  192. how to calculate hrs flown in last one year
  193. Re: V Lookup multiple entires
  194. VLOOKUP isn't working properly in Excel on Mac
  195. Re: Conditional formatting with dates
  196. Blank Sheet with Gridlines
  197. Calculating interest due on late loan payments
  198. Counting number of items excluding duplicates.
  199. Font is changing when editing a cell
  200. how to fix REF and VALUE with a circ ref with iteration
  201. iserror problem
  202. worksheet renames - specific
  203. sum last 3 numbers greater that 0 in a range
  204. Re: Help with an Excel formula please?
  205. Re: Help with an Excel formula please?
  206. Combining two non-contiguous lists into one for data validation, with one range being dynamic
  207. Weird behaviour when entering hyperlinks
  208. Keyboard shortcut to select a column?
  209. PivotTable - Filter Row
  210. How To Have A Cell Be Blank If...
  211. Re: convert CSV to XLS format using command
  212. Template Wizard w/ Data Tracking add-in
  213. Indirect
  214. Re: how to format cells -fill color
  215. Pivot table put multiple "Values" in one row but I want them in one column.
  216. Formulas Won't Run if I Open File from Explorer
  217. Excel 2007 - Pivot Tables Include Filtered / Hidden Values inSubtotal / Total
  218. Re: What does "" mean in an equation
  219. What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke
  220. Re: what does ! mean in excel
  221. rows height
  222. Re: Code to delete rows based on value
  223. Re: Help please with cut paste and formulas
  224. Re: Help please with cut paste and formulas
  225. Help with last 7 days running total
  226. I need help please
  227. Re: If then formula with multiple cells
  228. Re: countif with some conditions
  229. Re: countif with some conditions
  230. Re: Greater Less or Equal
  231. Re: Greater Less or Equal
  232. Re: Greater Less or Equal
  233. Sumproduct, countif and format?
  234. Re: Create a new set of data from 2 data sets
  235. Re: Find Duplicate names listed in opposite order
  236. how to carry forward a total from one page to another
  237. Re: Remove border
  238. Re: How can count the number of cells that fulfill certain criteria in other cells
  239. Re: Data Lookup - Copy and Paste
  240. Re: Excel Saves Random .xlsm File Everytime I Save
  241. Re: Concatenate, currency & sum formula
  242. Re: Help with calculating time and a half - I've got straight time and double time.
  243. tiny discrepancies in fixed-point numbers
  244. How to create absolue path link to another workbook (Excel 2003)
  245. Excel Visual Basic to get current row number
  246. Excel Vlookup Help
  247. Automatically Enter Formula in a Cell After Entering Data in Another Cell
  248. Re: Help with drop down selection and populating related data...
  249. Re: Help with drop down selection and populating related data...
  250. Re: multiple scenerios in excel
  251. excel copy and paste...
  252. Yet More Excel VBA Help Please
  253. Re: Find date in excel string previous to last occurence of specific text
  254. More VBA Help please
  255. Re: Multiple worksheet summary
  256. Re: Multiple worksheet summary
  257. Excel VBA setting Ranges
  258. Re: Conditional Formatting
  259. Need to merge worksheets - Excel 2003
  260. Re: I need to cut characters off of a list of text cells...
  261. Re: "If" function and Upcoming Dates
  262. Re: Multiplying Values only less than 1.5
  263. Re: After Copy Past shows Error. (#VALUE!)
  264. CSV->Excel Data Problem
  265. Re: Are the parentheses the problem?
  266. Re: Are the parentheses the problem?
  267. Index/match across multiple columns?
  268. Re: Copy pair of columns
  269. Re:Copy pair of columns
  270. Re: use xlup and offset in a range of cells
  271. Re: Copy pair of columns
  272. Question about conditional formatting of zeros in Excel
  273. Re: Testing for hyperlink error
  274. Getting Text data using the Data - Subtotal feature
  275. Cannot remove empty rows
  276. Determine if night shift by start & end time
  277. Excel 2003 save as .XLSX
  278. Re: How create a Purchase Order Form that stores data?
  279. Re: How create a Purchase Order Form that stores data?
  280. Re: if cell is blank
  281. Compile Error help
  282. Re: Negative value to positive
  283. Re: Negative value to positive
  284. Problem Re Passwords, etc.
  285. How to invert Cols/Rows?
  286. Re: Help with Column to Row formatting
  287. Re: SUMIF evaluating blank DATE data
  288. Re: Advanced Sort/ look
  289. Spellchecker anomaly... Checks spelling on a Forms Button text label...?
  290. Re: Countifs with if and date range
  291. Re: Index/Match Lookup with a merged col
  292. Filtered drop down list
  293. Excel Stops Working
  294. Re: Spell Check Protected WORKBOOK
  295. Excel Stops Working
  296. Re: Change text color with an IF statement
  297. Re: the cells that some rows have in common
  298. Re: need to extract email addresses from excel files
  299. Re: a function that deletes all rows with no value in a certain column?
  300. Re: Ignoring specific number
  301. Re: Find & Replace problems... at the end of my thread (ha)
  302. Re: Need IF statement to categorize time into "Morning", "Afternoon", "Evening"
  303. Re: Count If Formula Not Working - Help!
  304. Drop Down Calendar in Excel with a Default Value
  305. Re: Trapped in a cell!
  306. Finding Text within an Array
  307. how to write a dependent validation with all numbers
  308. Paste embedded file corrupts?
  309. File extract error?!?
  310. Re: IF Statement Reading Zero's
  311. need help writing formulas.
  312. Speeding up Excel simulations
  313. Re: L2013 not running code from XL7, second posting
  314. Re: prevent deletion of a workbook in a shared network drive
  315. Re: IF statement help
  316. Re: Randomizer
  317. Re: Separting negative numbers from letters in cells
  318. Re: CountIf from multiple sheets in another workbook
  319. Re: if row has duplicates, concat entries in another column?
  320. Re: sumproduct with COUNTIF With An INDIRECT
  321. Re: Complicated Data Selection
  322. Formula Help
  323. Re: Count the number between range of cell for a particular person
  324. Re: Sum to a mid point in a dynamic table
  325. Re: Look UP and then caluclation with IS ERROR
  326. Re: Combining Duplicates
  327. Re: adding up checked boxes in cells in a row
  328. Re: Index and Match
  329. Re: need help in fine-tuning a formula that removes blank cells in a column range
  330. Re: Creating a Dropdown that is Related to the Value Given in Another Cell
  331. Re: Creating a Dropdown that is Related to the Value Given in Another Cell
  332. Converting billion to million
  333. Date Calculation - Astro Calculation
  334. Re: LookUP certain words and return back corresponding values
  335. Re: Formula help - Match & IF
  336. Re: Extract numeric values from an alphanumeric cell based on a criteria
  337. Re: How to count but exclude overlapping data
  338. Re: Excel.csv file problem
  339. Printing line numbers
  340. Re: Complex Timesheet
  341. Re: Highlighted
  342. Re: Highlighted
  343. Excel Copy & Paste Issue ??
  344. Re: Highlighted
  345. How to synchronize all cell values?
  346. Re: adding accross sheets
  347. Re: adding accross sheets
  348. data from multiple files: best way to extract
  349. Re: Formula fill series?
  350. Copy paste data from a column to a row
  351. HELP!! New to Excel. Need complex SUMIF.
  352. Re: Top 5 list if data meets a criteria
  353. Re: Complicated Look UP
  354. Re: Complicated Look UP
  355. Re: Complicated Look UP
  356. Re: Complicated Look UP
  357. Re: Number range as a percentage
  358. Re: Userrange to formula
  359. Re: Using Drop Down list to an If Statement to another Drop Down list
  360. Re: Removing Unwanted Data
  361. Re: Excel vba UserForm Lists not registering default values?
  362. Re: How to avergage colums
  363. Re: Improve speed of the routine
  364. Re: Colour Coding dates
  365. Re: Copy All Visible Cell Of Sheet1 To Sheet2 Last Blank Row
  366. Re: how to get the percentage symbol with the result?
  367. Re: Excel vba UserForm Lists not registering default values?
  368. Re: Excel vba UserForm Lists not registering default values?
  369. Re: Look UP formula for 2 and 3 conditions
  370. Re: how to make a sheet invisible?
  371. Re: Return values from one column IF a certain value in another column
  372. Anyone Has A Template For Aoristic Analysis?
  373. Re: how to get the percentage symbol with the result?
  374. Import Multiple CSV Files from Same Folder into Open Workbook
  375. Re: COMBIN
  376. Re: Matching data in columns
  377. "cannot shift objects off sheet" error
  378. Re: Using Excel VB, Update a specific cell, on any change of another specific cell
  379. Puzzling quotes around text
  380. Re: numerical value to text description
  381. Re: Possible to have multiple sheets refer to a master template sheet?
  382. Re: Convert multiple columns into a single row
  383. display '2+2' as '4' in a cell?
  384. Excel opening MSSynch in 2010? How to stop it?
  385. Re: countif on multiple criteria
  386. Re: Macro
  387. Re: how to select contents from a col which lies in between other columns
  388. Find values across a row and return a text value from the same column
  389. Re: How do I reference one OR another worksheet?
  390. Re: How do I reference one OR another worksheet?
  391. Re: Automatic printing by filter?
  392. Crazy Variance Formula
  393. summarizing data from various workbooks
  394. Assigning values
  395. Re: Excel equations
  396. Re: Multiple items selected multiple dependancies available
  397. Re: Excel equations
  398. Does Publisher 2013 have autoflow?
  399. Re: bullet point lists in Excel
  400. Axis formatting
  401. find -> list of records
  402. To Garry of GS Excel contribution fame
  403. Re: How to extract data from a spreadsheet into a form/create form from spreadsheet data
  404. Search OF Macros for a specific phrase
  405. check first 3 characters of a cell and compare to a table
  406. Re: how to convert grades into a value
  407. Re: how to convert grades into a value
  408. Currency autofit
  409. Re: Large Excel Email list with Non printing character
  410. How to use Sumifs with vertically and horizontally criterias
  411. Pulling a specific email from cells and putting info in new row
  412. Re: How Can I subtract from time within a 24 hour clock?
  413. Re: Cross referencing a weekly menu list with a grocery list
  414. If statement for a range of cells
  415. ="'"&F1&"'," Excel errors in one spreadsheet but not other one?
  416. Duplicates Deletion ?
  417. Changing Text To Numbers ?
  418. For Joey2004 et al. From OP: Re Appending Question
  419. Appending Text To Numbers ?
  420. Average problem
  421. Re: Countif to exclude blanks
  422. Re: Calculate horses age as at 1 August
  423. excel 365? develop offline?
  424. Re: Problem with user functions in Add-ins for multiple persons
  425. Some chart types cannot be combined...
  426. GETPIVOTDATA #REF! error XL2003/2010
  427. Re: Date Conditional Formatting
  428. Opening excel 2010 spreadsheet from Access
  429. Copying puzzle
  430. Unable to freeze panes
  431. Re: Dropdownlist and Vlookup
  432. U*nexplained ribbon change
  433. Re: Add image in forum
  434. Re: Permanently link formula references to Column Names and not Column Cell Numbers
  435. Re: Forgot Excel Password
  436. Re: Formula for percentage calculation
  437. Re: Add numbers if cell fill is a certain color; How To?
  438. Re: Conditional Format Entire Workbook
  439. Re: Add numbers if cell fill is a certain color; How To?
  440. Start sheet in a workbook
  441. Re: Excel on Iphone
  442. Re: Transpose
  443. Dynamic Excel data into locked Word form
  444. Copy rows to new sheet based on value in column A
  445. Re: Why cant I expand the equations parameters without error?
  446. Re: Subcategories in Drop Down List
  447. Trying to create a dynamic filepath within VB
  448. No tools manu?
  449. Unlink cells- how?
  450. Re: Averaging feet and inches (not decimal feet)
  451. Re: VBA not selecting worksheet with titles
  452. Cell not calculating after importing data
  453. Re: Delete certain text from cells
  454. Re: Using the If function for a date range
  455. Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons?
  456. Multi-demensional frequency distribution
  457. Copying data to the next blank row
  458. Re: How to Remove Excel Protection?
  459. Adding cells by 2 criteria that move.
  460. AUtofiltering dates
  461. Re: Import Images into cells from a file without using VBA or Macro. Can it be done ?
  462. Re: Excel Formula
  463. Hi, is there a way to access mouseover (hover) data in excel)?
  464. Re: sumproduct() function resulted in an error #DIV/0
  465. Re: How to read data from the workbook selectively?
  466. Formula help
  467. Re: Define a dynamic Print_Area
  468. Re: Dates
  469. Re: Dates
  470. Re: Dates
  471. Default font
  472. Re: Macro for saving file as cell ref
  473. PowerPivot How to chart with contiguous time axis?
  474. Question on the occupied field of the pivot table in excel spreadsheet
  475. Pivot Tables and Filter Criteria Display
  476. Re: Adding text to email body
  477. Re: Specific hours worked between two time intervals
  478. Formula Audit mode active in one column only; cannot kill.
  479. Re: how can I lock/unlock a range of cells depending on state of a checkbox?
  480. Re: Font options
  481. Tracking Access in Read-Only Files
  482. Tweaking VBA
  483. Re: Data Validation help
  484. vlookup
  485. For Claus From OP:
  486. To GS Re .csv Commas
  487. .csv Commas ?
  488. sum character
  489. File Name Chages ?
  490. Re: Formula- Count of items that meet a specific range criteria
  491. Re: Formula- Count of items that meet a specific range criteria
  492. Query of List Option
  493. Application.GetSaveAsFilename
  494. Duplicate Line by cell qty
  495. Re: number of months and days between two dates without approximation
  496. Re: filter result- total row numbers varies
  497. Re: Formulas
  498. Re: Formulas
  499. I'm loving Interse
  500. Re: Excel Shortcut Key
  501. Re: Excel 2007 - Sudden Disappearance of Character Spacing
  502. What is "--" in Excel Formula (SUMPRODUCT)
  503. Re: Drop Down Selection Assistance
  504. Re: Macro that sorts data with blanks at the bottom
  505. Re: VLookup using two criterias - looking for a efficient way
  506. Macro: finding a cell on one worksheet and copying to another worksheet
  507. Re: Look UP using 4 criterias
  508. Re: Multiple Regression - polynomial fit
  509. Move cells up
  510. Move cells up
  511. Re: Vlookup using two criteria -not working
  512. Re: Weighted Grades Worksheet
  513. Re: Weighted Grades Worksheet
  514. Re: how to add a letter to front of column sample ID
  515. Re: how to add a letter to front of column sample ID
  516. VBA : Class does not support automation error.
  517. Re: Function help: Reference cell based on another cell's value?
  518. Re: Function help: Reference cell based on another cell's value?
  519. Re: How to compare two work sheel cell by cell
  520. Simple Timer facility
  521. Re: New User: Copy Cell and Insert into Cell of Text.
  522. Printing Excel File Custom Properties in the Footer
  523. Re: if function
  524. Re: what does 6.9544E+23 stand for
  525. Re: if function
  526. Re: if function
  527. Re: multiple columns into one column and autofill(?) question
  528. Re: Macro adds "=" to each cell in defined range across multiple worksheets
  529. Re: Please Help
  530. Re: Having trouble with formula
  531. Re: Please Help
  532. Re: formula with text and rounding
  533. Re: XL 2003 very slow to Copy. XP SP3
  534. 3 variable 2 dimensional line graph
  535. retrieving values from a certain column
  536. Re: Bracers before text in a single cell
  537. Automatically join files
  538. Re: Find rows that contain capital letter?
  539. Re: Difference in Time hour what formula to use in excel?
  540. Re: Question regarding an auto-search facility
  541. Re: Question regarding an auto-search facility
  542. Re: Question regarding an auto-search facility
  543. Re: Compare a column of substring with another column of strings and get count
  544. Re: Complicated Look Up (without making changes to the blank spaces in the table)
  545. Re: Simple IF Statement Help!
  546. Re: how to get a warning when data is entered wrongly
  547. Re: Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) betweenentry time
  548. Re: the forumula bar is not visible
  549. Re: Complicated Vlookup and array
  550. Excell 2000 macro will not open file!
  551. Excel 2002, problem with Text to Columns
  552. formula question - weighted sales/distribution
  553. Re: I have an excel spreadsheet. I want to export each single rowsinto a new email on mi
  554. Re: Help matching combined text cells
  555. Re: Print Macro w/drop down list
  556. Running an app which requires quote defined parameters
  557. Re: Gridlines
  558. Re: Link data from Another cell
  559. Re: add multiple letters to the end of multiple cells
  560. Re: Gridlines
  561. Exchanging data
  562. % Difference between cells based on variable...
  563. Re: Remove Data which is not match with other column
  564. Re: Insert File name in Excel File
  565. Re: countif function
  566. Reading CSV with numbers in text format, Excel automatically convertsto scientific notation
  567. Re: VLOOKUP returning #N/A ??
  568. formula help... lookup or ref?
  569. freeze panes
  570. Re: Need Help Regarding Points of intersection in graph.
  571. Re: Extra help on Nth Day of month
  572. Re: Excel wont Paste Special wont paste formulas it says Unicode text
  573. Re: How to replace a constant from a cell containing date and time
  574. If statement with dates
  575. Re: Setting Range with a Loop
  576. Re: designing a macro
  577. Re: designing a macro
  578. Re: How to search specific list in different sheet
  579. Re: Project If Function
  580. Speech Recognition & Dictation in Excel: How to turn it on?
  581. Re: how do I search thru the values in my column and replace withnessesary values
  582. Remove colour change
  583. Edit File Information
  584. Spelling checker problem on a specific worksheet only
  585. expert needed...
  586. Re: How to count innings pitched?
  587. Convert HH:MM AM to HH:00 AM
  588. Re: Permutation/Combination/Pairs order unimportant.
  589. PowerPivot query
  590. Re: Auto populate from list on separate sheet
  591. Re: Auto populate from list on separate sheet
  592. Re: need help with excel
  593. place code where?
  594. Re: need help with excel
  595. Using Filter more than once
  596. Formula autofill to cells below formula arguments are cell areas in different columns
  597. separate questions and answers of a test
  598. from to 3 rows to 12 rows (please macro or formula)
  599. Re: Formula to change name format
  600. Re: Sort Marco won't work in 2010
  601. Re: How to calculate multiple conditions?
  602. Re: How to calculate multiple conditions?
  603. Re: Can you display entire rows that match a certain criteria...
  604. Populate row with work days
  605. Re: Sort Marco won't work in 2010
  606. Re: Sort Marco won't work in 2010
  607. Problem with Kill Syntax!
  608. Change all text on Spread sheet
  609. Need help deleting data
  610. Re: =IF function with current date
  611. Re: =IF function with current date
  612. Re: LEFT function not working with dates
  613. Re: LEFT function not working with dates
  614. Informal invite to "Excel Blackbelts"
  615. Need Help with VLOOKUP
  616. Re: Data Validation Query
  617. help on summing a random combination
  618. VLOOKUP returning #N/A result
  619. Re: Need to reorganize - transpose columns to rows per article number
  620. Re: V Look up with drop down functionality
  621. Re: Address fields in columns...
  622. Re: Problems with static dd/mm and rolling year
  623. Transpose, but how?
  624. Need to reorganize - transpose columns to rows per article number
  625. HELP - A formula or sheet you want to move or copy contains the name ....
  626. Number of work days between two dates entered into a user form text box
  627. Error message with nesting
  628. Re: V Look up with drop down functionality
  629. Re: Address fields in columns...
  630. Advance Macro help
  631. excel 2010 + copy array
  632. Re: adding small letter on top right of value
  633. Re: how to open PRN files in Excels?
  634. Re: Help with a Formula to turn various words into numbers
  635. Re: randomly picking up an array element from an array of elements
  636. Re: adding brackets to every cells without changing content
  637. Re: randomly picking up an array element from an array of elements
  638. Date format/value different when opening manually compare to VBA macro
  639. Re: Countifs formula
  640. Re: changing rows *and* columns in automatic formulae
  641. Re: Search for either one or the other
  642. Re: Summing across multiple columns
  643. Re: Search for either one or the other
  644. Re: Search for either one or the other
  645. Re: How do I stack data in Excel 2007?
  646. Re: Excel Invoice help
  647. Re: Excel Invoice help
  648. Re: Conditional Formatting in Excel 2003
  649. Total formula
  650. Re: Find Max value within a Offset
  651. Re: How do I insert a row without the formula changing?
  652. Re: Making inputs for average formula dynamic
  653. Re: Auto-populate spreadsheet based on database info?
  654. Re: Look up with multiple variables
  655. Re: Please Help! Can't solve excel problem
  656. Data Lookup Question
  657. Re: Rostering form: Adding New Lines to a table about a totals calculation.
  658. Re: Help! How do I ignore blanks cells in an array?
  659. Re: How to insert date continuosly onto sheets if the first sheet hadbeen put the date?
  660. Re: Help with a Formula to turn various words into numbers
  661. Re: Look Up with Multiple Conditions
  662. Re: How to insert date continuosly onto sheets if the first sheet hadbeen put the date?
  663. Re: Need help matching similar data...
  664. Help with this formula
  665. Help Writing a SUM Formula
  666. Excel 2007 Problem Paste/Enter Key
  667. Re: Conditional formatting disappears when cell contents deleted
  668. Re: Help Needed - Making Numbers
  669. Re: IF Function Question
  670. Formula Assistance
  671. Re: Comparing two columns with conditional formatting
  672. Re: Variations against one value
  673. Using 'indirect' function with full network path
  674. Re: Variations against one value
  675. Re: Worksheet name as a variable in VBA
  676. Re: trying to get data from rows to columns
  677. Re: Help with Look Up with multiple complex conditions
  678. Re: Rostering form: Adding New Lines to a table about a totals calculation.
  679. Re: Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet
  680. Re: Calculation with a Blank or 0 Cell
  681. Re: Finding largest total of ANY two values in a data set
  682. Re: Conditional Formatting Dates Less Than 14 Years Ago
  683. Stacked graph
  684. Extending a selection
  685. Re: Sumif & Countif
  686. Move data from every other row to columns
  687. Sort by Every Other Row?
  688. how to strip an individual symbol from each row in a column
  689. Re: Auto populate monthly and quarterly data
  690. Re: Auto populate monthly and quarterly data
  691. Re: Macros and Email
  692. Re: Average with conditions
  693. Re: Separate Values
  694. Re: Separate Values
  695. Force zeros in Excel 2007 when cells blank and keep commas for thousands
  696. Matching records based on a common field
  697. Re: A way to extract info from multiple excel files, based on content?
  698. Re: A way to extract info from multiple excel files, based on content?
  699. Text to columns
  700. automating data across cells/sheets
  701. Format appears stuck..how to break formatting
  702. Re: Excel 2002 file is suddenly read-only?
  703. Re: Excel 2002 file is suddenly read-only?
  704. Help With Nested SumIf / Or
  705. Re: HOW-TO make a random selection from a set of data and divide itinto sub-team
  706. Re: Getting "N/A"
  707. Re: Colour cell yellow when there is not data entered
  708. Date and If problem
  709. formula to count text entries and return text with most entries
  710. Re: Multiple IF's ??
  711. Re: Dates and if statements
  712. Re: Duplicate with Criteria
  713. Re: input field linked to button to create a table
  714. "Unwrap" Excel list into table, to facilitate pivot
  715. Correct process for creating a linear trend line in Excel
  716. Re: Extracting specific info from cells
  717. Summarise data on multiple sheets
  718. Re: Extracting specific info from cells
  719. Re: CSV file conversion + True/False over multiple columns of data
  720. Re: Excel and date ranges
  721. Re: Need to have data in one column
  722. Tree from Parent/Child Pairs
  723. [HELP]CLOCK TIMER USING ECXEL
  724. Displaying time gaps
  725. Re: closet lookup
  726. Re: closet lookup
  727. Re: Calculating Work Time
  728. I can't copy and paste equations
  729. Re: SIMPLE DRAGGING issue
  730. Re: Populating cell with string not in workbook
  731. Max Length in a row
  732. Re: Saving Formulas in Excel
  733. Re: Making cells appear on screen but NOT print
  734. Re: printing on paper size of 10 inches X 12 inches
  735. FORMATTING CELLS
  736. Re: Making cells appear on screen but NOT print
  737. Conditional formatting
  738. Re: Excel Auto Sum
  739. Re: Dividing worksheet into multiple workbooks
  740. excel formula for markup and profit margin
  741. Re: Dividing worksheet into multiple workbooks
  742. Re: Avoiding display msg when saving a .xlsm file to .xlsx
  743. Re: Insert Rows Below
  744. Re: Insert Rows Below
  745. Need to highlight cells in special order
  746. Re: Insert Rows Below
  747. Re: Merge excel files with different column headings
  748. #VALUE error which disappears when I use F2, ENTER
  749. Re: Excel macro to copy the rightmost column to a new column
  750. Summarize the monthly recrods by name