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