PDA

View Full Version : Excel Discussion (Misc queries)


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 | 

  1. Insert Space Between Initials
  2. A fun puzzle...
  3. Formula in one cell changes when data in another cell is cut andpasted.
  4. Clear Area Except Formulae
  5. Named Range Keeps Disappearing...
  6. Automagic Subtotals in Pivot Table
  7. formula of Inserting a Date in a cell without updating the date
  8. Excerl 2002...FInd and Replace not working properly
  9. How to lock row and columns to another user and they should not ableto delet or add any column and row in sheet only they can type and input fromdropdown list
  10. Import text into colums without using the wizard
  11. Hide #DIV/0!
  12. No auto spell checking in Excel like Word and PowerPoint?
  13. Re: Hello! I'm a newbie to this forum from Adelaide, South Australia.
  14. VLOOKUP + IF ?
  15. Pivot Table Running Sum %
  16. Syntax Again...
  17. Blank if zero
  18. Excel 2002 "locked for editing"
  19. How do I stop cell contents from spilling over into the adjacent cell?
  20. HOW DO I DUPLICATE SHEETS (24 plus) WITH NAMES
  21. Summing cells of a unique color
  22. Highlight cell values in other areas based on two columns
  23. Highlight cells based on values in other cells.
  24. Excel 2016 Won’t Open XLS Files
  25. Look up formula from table with uneven format
  26. Re: Excel Desktop shortcuts do not work
  27. Re: change a positive number to negative
  28. date format in excel 2002 on win 7
  29. Count
  30. How to password protect items in a dropdown menu
  31. Countifs Counting the occurrences of text based on conditions
  32. How to generate dynamic drop down
  33. Formula Help Needed
  34. Re: Trapped in a cell!
  35. Run Excel macro from Win 10 Run box?
  36. Text across columns
  37. Workbooks always open maximised
  38. Averaging durations formatted as hh:mm?
  39. Re: Copying a worksheet - won't work help please
  40. Re: short cut key for insert copied cells?????
  41. How do I exit downloaded Office 365 (web)'s e-mail's Excel attachments views on an iPad (iOS v12.4.1)?
  42. Formula to scan group of four cells?
  43. EXCEL SPREADSHEET FORMULA QUESTION
  44. Single Page in "Page Layout" View
  45. Cầu thang sắt ngoi trời
  46. Saving Custom Colors for Continuous Use
  47. Excel 2019 experience
  48. Excel 365 files stored on the local PC only
  49. VERY irritating "save changes" message
  50. "Merge And Center" greyed out
  51. Re: Trapped in a cell!
  52. problem using Text to Columns (Excel 2003)
  53. EXCEL spreadsheet with gridlines
  54. How to change data validation values based on different passwords
  55. enable trusted sources XL97 WinXP
  56. #DIV/0 ERROR FOR 2 FIGURES WHICH ARE 0%
  57. Can't Get EXCEL To Open Up (MAC/Mojave). Sr. Citizen Quest.,, Please
  58. Iterative Sum Calculation
  59. Iterative Calculation
  60. Create a dependent drop down list in Google Sheets in a whole columnnot just one row
  61. Pass Fail on multiple variables
  62. Preserving Cell Values for Comparison
  63. Anniversary dates
  64. Converting a date number?
  65. Year() Calculating as #REF
  66. Help needed in hanging the default file location for Excel and Word
  67. Doing a SAVE Doesn't Save Formatting Changes ?
  68. Re: Trapped in a cell!
  69. Check if a number is an integer or not (and using that in an IF)
  70. Best way to create a sorting table with non numerical values
  71. Office 365 Excel for MAC Number Format
  72. Count Weekdays and Weekends separate & < a given cell.
  73. Search Month within date range
  74. Object Assignments based on coordinates
  75. Nested IF function (simple)
  76. Re: Need to setup xls to compute and check Vin Digit
  77. Re: Shortcut to show all after filtering?
  78. Re: placing a reference to a cell in a print header
  79. Divide a number in one cell into several others UNEVENLY
  80. Re: Trapped in a cell!
  81. Average of different cells ignoring blanks
  82. Average of multiple cells across multiple sheets
  83. Average of different cells ignoring blanks
  84. Vlookup - Sheet Name in Cell
  85. Drop-Down References a Grouped Item - how to populate multiple
  86. Salary structure calculations
  87. Numbers stuck in strings. Does this number belong?
  88. replace - with missing numbers (e.g 1-4 = 1, 2,3,4)
  89. Function based on colour of cell text?
  90. Difference between two times
  91. Text keeps repeating in excel cell
  92. Comparing columns, need to quickly change what cols being compared
  93. How to locate cells with links to other cells/worksheets
  94. Countif?
  95. Re: Concatenating formulas
  96. Returning value from single row of filtered table, given the column header
  97. Re: Excel treats 1/2 as a date instead of a fraction
  98. Reposition Cells in a Column based on another
  99. Hyperlink with Mailto, concatenate, from other sheets in the same workbook
  100. Consolidate On Steroids???
  101. Day & Month reversed when importing text
  102. Wonder if INDIRECT is the right thing to use here...(probably not)
  103. Formatting based on other cells
  104. Extracting text from formula result
  105. Pasting text into VBA macro?
  106. Change macro to formula?
  107. Clear/delete all cells outside of a range
  108. Clean/delete all cells outside of a range
  109. Excel File Recovery Software
  110. Using a condition with a slope formula
  111. Re: Dragging Cells to Create Ascending Numerical List
  112. Problem with Paste function in a Table in Excel 2010
  113. FORMULA HELP Percentage of cells in a Range as Completed
  114. Cell not displaying as expected
  115. Hiding an unintended value
  116. Is a date month between 2 dates
  117. How to locate cells with links to other cells/worksheets
  118. Counting Nr of Entries in a Column which are Formatted as Date orText or Number
  119. Coverting Lotus 123 files to use with excel
  120. Edit Hyperlink dialog crashes Excel 365
  121. Access Database Repair
  122. Copy/pasting a date in text format?
  123. For Claus
  124. Seeing Data That I Used To Create A Chart: Bottom Bar Doesn't DisplayChart, Sheet, etc. Anymore ?
  125. Excel spreadsheet -- column widths and row heights change accordingto the printer selected
  126. VBA to add file as icon for various file types
  127. Lok up Formula
  128. Stripping out text?
  129. RE: How do I enter the formula for volume of a cylinder in Excel?
  130. making a copy/duplicate spreadsheet but row colors have changed
  131. Need Guidance on solving this problem....
  132. How to Separate One Column Into Many Columns with No Delimiter
  133. Fill cells based on value
  134. Formula to populate based on the dropdown selection..
  135. Spreadsheet With Multiple Columns To WORD as a Single Page Width ?
  136. Re: Trapped in a cell!
  137. Insert blank row in table using VBA and automatically populate active cell
  138. Re: Trapped in a cell!
  139. Sumproduct fails after turn of the year
  140. Referencing cells
  141. Re: Default value for drop down list?
  142. I click one cell in excel and it highlights a different cell.,
  143. how to "freeze panes" for a vertical column?
  144. Re: Unable to insert page break
  145. If with or
  146. Followup: Plotting A Distribution/Normal Curve On Top Of The BarChart ?
  147. Sr. Citien Question Re Bar Graph Plotting
  148. Excel 2003, is there a "snap to" function?
  149. Popup in Excel
  150. paste special
  151. combining data
  152. Highlight row on 3 conditions
  153. Excel Dynamic Named Ranges in multiple columns
  154. Sum a column in groups
  155. How do I sort the contents of cells in each row into ascending(earliest to latest) order
  156. Re: Copying a worksheet - won't work help please
  157. Re: Large Numbers in Excel?!?
  158. Re: Printing a booklet from Excel
  159. Formatting a cell based upon the contents of another cell
  160. Autofill dates
  161. Pasting spreadsheet into Facebook
  162. Lost password for password protected Excel file
  163. In excel 2000, IF function calculates incorrectly using "E"
  164. Need a pivot table subset of a pivot table (slicer doesn't work)
  165. Stack bar chart configuration in Excel
  166. Re: Crystal Reports export to Excel - Loss of Leading Zeros
  167. Can I keep external connections in a table?
  168. ROUNDING ISSUE
  169. Re: Copying a worksheet - won't work help please
  170. Adding the same field in the column field list of pivot table
  171. Re: Print titles must be contiguous and complete rows or columns
  172. how to use “or” in excel solver constraint?
  173. Unify dates in rows
  174. Activate a workbook?
  175. Calculated field formula in pivot
  176. How to handle Brackets [ ]
  177. Annual Escalator's and Total Contract Value
  178. How to copy to a specific worksheet?
  179. Excel disappearing text in formula bar
  180. What determines location of VBA code from recorded macro?
  181. Why this date result?
  182. Go to a column in a selected row?
  183. Adding a Trendline Problem
  184. quick annualization
  185. I want to extract the pence from a currency sum
  186. Formulae Required
  187. Run-time error '424': Object required
  188. Unable to turn off Speak Capabilities
  189. Copying an entire spreadsheet
  190. Why doesn't this content get fully displayed?
  191. Duplicate macros?
  192. Re: Grouping dates in pivot tables by week no.
  193. script error message
  194. Trendline formula not correct
  195. % Profit Loss Formula
  196. Sorting dates in Pivto table
  197. Day Trading Spreadsheet
  198. Simple Charting Problem, Please
  199. Scroll bar disappears
  200. Re: Trapped in a cell!
  201. Re: Coverting Lotus 123 files to use with excel
  202. Choose function not working
  203. Y Axis Shows Date, rather than Value ? Help Please.
  204. Trying to Run a Formula on the Combinations of Info from Different Books
  205. How to show full cell contents?
  206. Re: Black triangle in cell corner
  207. Cannot add borders
  208. formula needed for complicated lookup
  209. Total Interest Calculation
  210. Cannot drag Excel 365 (2016) window
  211. Complex: Date Ranges and Aggregating Data using IF Statements
  212. Excel 365 very slow opening files
  213. All my entries turned to #VALUE!s
  214. Excel 2013 shift end down
  215. Re: Print Row Number
  216. Make a decimal number return to zero
  217. Re: Print titles must be contiguous and complete rows or columns
  218. Copy the formula by dragging but down but calculate by going left
  219. save in new destination
  220. How to seperate people
  221. EXCEL averageif with different #of values to average per calculation,depending on two criteria
  222. Excel Average of dates with different data point #s and values.
  223. Averageif in Excel
  224. Sort isn't sorting correctly
  225. Index Match with if or iferror help
  226. File saving messages on launching Excel
  227. Re: Print titles must be contiguous and complete rows or columns
  228. Need help with many changed Hyperlinks
  229. Collect deraqilos from 1 column & paste link
  230. Opening Ribbon > Home without the alphabet soup?
  231. New group for MIS reporting related queries and answered, please join us
  232. Cost of each whole unit beyond
  233. Amend all Macros
  234. Change default settings for Comments?
  235. Automatically Conditionally Formatting Pivot Table based on Percentages
  236. Selec same row different column?
  237. Trapped in a cell!
  238. Removing unwanted messages
  239. List of multiple repeating numbers assigned unique but like valueswith a formula
  240. Capital letters
  241. Posting A WORD Question, Please
  242. XLSM and XLSX - what's the difference?
  243. Lost all content?
  244. Pasting symbol?
  245. Automatically Maintaining Cell Values for Comparison
  246. Customising date format
  247. Re: Print titles must be contiguous and complete rows or columns
  248. Highlighting cells when others are populated
  249. formula to calculate value based on threshold
  250. Help with charting
  251. Conditional difference between cells
  252. Re: Print titles must be contiguous and complete rows or columns
  253. Date sensitive formulas
  254. Regressions p-value is #NUM! whats wrong
  255. Twinning Cells
  256. SUMIF alternative
  257. Trying to install on Windows10 PC
  258. IF(ISERROR(VLOOKUP help required
  259. delete all rows EXCEPT rows with highlighted cells
  260. Edit & paste link help
  261. VBA code to split text data from a cell into multiple cells/rows
  262. Using AND and OR together
  263. Re: Deleting every other row
  264. summing a table based on a cell reference?
  265. Disappearing Curves ?
  266. Transfer data to cell location defined by row and column text headers??
  267. Re: Print titles must be contiguous and complete rows or columns
  268. Re: Print titles must be contiguous and complete rows or columns
  269. Excel 2010
  270. Macro organisation?
  271. Delete cells based on condition
  272. Dynamic + Fixed worksheet name
  273. Insert - Hyperlink - Recent Files - (How is this list populated)
  274. Loading excel problems.
  275. Pivot Tables
  276. Re: Print titles must be contiguous and complete rows or columns
  277. Re: Trapped in a cell!
  278. Spinners
  279. Re: Print titles must be contiguous and complete rows or columns
  280. Deleting rows VERY slow!
  281. Named Ranges anomaly(?)
  282. Re: Is there any tools to repair corrupt Excel file?
  283. Re: Excel File repairing tools
  284. kick the hacker of Google
  285. Conditional row height?
  286. Hello, Some of my cell totals are off by one penny!
  287. Hyperlink function to open PDFs at a certain page
  288. Re: page numbering in an Excel cell
  289. Excel macro - VBA code query
  290. cheap lace wigs 7O2h - How can you help cancer patients by cutting yo
  291. How to delete text prefix ' ?
  292. From data to summary?
  293. Table filtering broken by Subtotal function in Excel 2010
  294. Draw Lines from cell values?
  295. Re: Deleting every other row
  296. Re: Dragging Cells to Create Ascending Numerical List
  297. Dynamic Data Validation list
  298. Re: Print titles must be contiguous and complete rows or columns
  299. How to handle this logic test
  300. Need formula that will only increase letter
  301. Trendline Not Showing ?
  302. Sr. Citizen With A Few Basic Charting Questions, Please
  303. Lookup unique cell with date and time combined
  304. Count the number of times a cell has been up-dated
  305. Sr. Citizen (Very) With WORD Question, Please (I know an Excel Group,but...)
  306. when adding a column the answer turns to zero
  307. Extract IP address from...
  308. Counting Coloured Cells - Conditional Formatting
  309. Conditional Formatting with multiple sheets and VLookup/Offset
  310. Help to deciper the String Extraction formula
  311. Conditional Subtotal with data table
  312. Excel changes not saved, then show up
  313. Re: help adding and subtracting stones and pounds
  314. How to send messages from computer
  315. Help Required (19th Dec 2015)
  316. Page break preview has thrown a wobbly
  317. Group expense splitting
  318. Convert visa pdf statements to three columns in excel?
  319. Help Required - 11th Dec 2015
  320. Help Required 9th Dec 2015
  321. Signature software
  322. Drag down a formula which uses multiple columns?
  323. Look up formula?
  324. Guidance Required #01
  325. Values from a weighted average
  326. Need Help with ROUNDUP
  327. Formula in Col B to detect if an entry in a list in Col A is uniqueor not
  328. Convert seconds to hh:mm:ss?
  329. Export a text file from each row of a spreadsheet
  330. Office 365 Home Premium Excel vba options greyed out on developer tab
  331. Dynamic Hyperlinks
  332. Vlookup is giving #N/A
  333. How To Search And Replace A Special Character In A String
  334. invalid cell reference
  335. Remove borders, keep grid-lines
  336. Excel 2013
  337. Weird Problem With Excel 2013
  338. Re: Copying a worksheet - won't work help please
  339. Re: Can't Break Links
  340. Excel Vlookup Not Returning Correct Information
  341. Help with Excel Formula (Multiple Vlookups in an If Statement"
  342. Update of two cells from a cell.
  343. Re: Print titles must be contiguous and complete rows or columns
  344. Re: Print titles must be contiguous and complete rows or columns
  345. Removing Unnecessary duplicated data
  346. How do I create an equation to copy a row of data from one worksheetto another if it meets certain criteria
  347. help .Windows xp
  348. copying a row of data using a formula
  349. Baffling sum error?
  350. Re: excel doesn't keep formatting, have to redo it each time I open it
  351. Trendline formula does not mimic actual trendline
  352. Summing with conditions
  353. Excel
  354. Excelapalooza in Dallas, TX- Who's Going?
  355. Help Needed
  356. Control dial solution?
  357. Pivot Table record-name wrong/corrupted in list
  358. Time formulas
  359. Show numberic coded date as a proper date within format cells
  360. Enter column of hyperlinks
  361. Complicated lookup from a table with scales
  362. Drop Down list and supporting functionality
  363. Can't Print Vertical Grid Lines; Why ?
  364. Editing a long text line?
  365. Convert hh:mm:ss to decimal hours?
  366. Help with Excel Formula?
  367. Ho to get the top ten values in a sheet
  368. #DIV/0! error
  369. Exporting Yahoo Data into Excel?
  370. Sumproduct slowing down my file
  371. How to prevent duplicates using index,match & large
  372. Coloring table based on value
  373. Dangers of using Excel as a database
  374. User-defined concatenation
  375. Can`t file XLS. Excel 2007
  376. How to display cell A1 in a pivot table
  377. Where is "ignore DDE" set in Excel 2003
  378. Recover broken sheet in XLS document
  379. Column Widths in Word and Excel
  380. Shift schedule conditional formatting
  381. excel file crashes windows explorer
  382. Re: Print titles must be contiguous and complete rows or columns
  383. How to restore BKF files ?
  384. Compare-text in different columns fall in same row
  385. Statistics / Probability
  386. Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file
  387. How to extract Data from a excel spreadsheet to another excel spreadsheet?
  388. Help Required
  389. Multiple Holidays using Networkdays
  390. Extracting data with multiple criteria and values
  391. I need a tutorial on Excel formulas
  392. Date conditional formatting
  393. Help Required using SUM function with Vlookup
  394. Re: Macro for converting Excel list to QIF?
  395. Count Nonblank Rows based on another cell range meeting specific criteria
  396. Pixels to MM2
  397. Installing Excel 2010 After Excel 2013
  398. Adding Rows In Spread Sheet
  399. Can't open excel files
  400. Recovering corrupt excel file
  401. Re: Print titles must be contiguous and complete rows or columns
  402. Excel 2007 - Unreadable content when opening files
  403. VBA Code to Round Range & Not Exceed 100
  404. Formula for calculating whole lengths
  405. Can you "Time Stamp" in Excel?
  406. Copy Once Paste Multiple Times
  407. Find first cell in row with an "x" in
  408. Repair Excel Files.
  409. Countifs within a date range
  410. Characters after the last space in a string
  411. Re: excel doesn't keep formatting, have to redo it each time I open it
  412. Quantities of random values
  413. counting text based cells
  414. autofill handle rows to coulmns
  415. Conditional formula
  416. Re: cell formats
  417. IF this cell is between 2/1/2015-2/28/15, then do something
  418. I can't rename worksheets - help
  419. Workbook Connection(s) failing to refresh in copy of working spreadsheet
  420. Puzzling refusal to paste into hyperlink
  421. Unsupported data cannot be repaired or removed.
  422. Days from a date excluding weekends and holidays
  423. Merge and Center
  424. Excel Opening Problems ? And, Other Equiv Spreadsheets ?
  425. How to open/recover excel 2003 document?
  426. ####### in cell
  427. Entering 'GTi' but I get 'Gti' !
  428. I deleted some Excel files. Help me please to recover it.
  429. Help with creating an invoice calculator with multiple drop down menus and functions
  430. Helpl with formula lookup
  431. Continuous Invoice Nos.
  432. Insert formula in pivot table
  433. Employee scheduling and re-assigning problem.
  434. Re: Print titles must be contiguous and complete rows or columns
  435. Help to create a macro
  436. mapping from excel
  437. TO split worksheets in a single file to multiple files
  438. Re: Print titles must be contiguous and complete rows or columns
  439. count calls per hour
  440. Bjj Gi Suit
  441. Reference Formula Help
  442. Numbers showing Up Centered in Cell ?
  443. Re: Print titles must be contiguous and complete rows or columns
  444. Re: Print titles must be contiguous and complete rows or columns
  445. Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis
  446. Excel 2007 strange behavior
  447. How to reference the value from another cell in a VLOOKUP table array
  448. Lookup from a pivot table
  449. T. Shirts
  450. Autofill with data from multiple sheets from a different workbook
  451. Conditional SUBTOTAL in XL210 Table
  452. Boxing Gloves
  453. Print Area to include text box
  454. Alternative reference formula for sumproduct formula help
  455. Decimal point in bar chart and similar
  456. How can I stop automatic date formatting?
  457. For Claus:
  458. Days open Calculation
  459. Showing Letters For Column Headers Rather Thann Numbers ?
  460. COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER
  461. Cell color change based on Date
  462. Top Down Charts
  463. Excel cannot open the file .xlsx
  464. forgot the password to open xlsx file - pl help
  465. Constant Yellow Square
  466. *.xlsx files won't open
  467. Why is this code not working ?
  468. Flipping numeric values
  469. Macro to insert pictures in comments
  470. 'Cannot insert object' message when I try to put a button on a worksheet
  471. How to rotate inserted picture in Excel comments?
  472. Which graph to use...how to present the data
  473. Conditional formatting in Excel 2010
  474. #NAME? error in aging calculations
  475. Macro to add numbers in a text string
  476. Manditory cells in table
  477. Formula Help please......
  478. How to create a sequence based on another column values?
  479. php export problem
  480. php export problem
  481. Match 1 sheet to another and return adjacent
  482. Formula to count occurrences in a filtered column
  483. Find Min Time taking 24hrs into account
  484. I can only delete an entire row not a cell in excel 2013?
  485. I need help with this program written in Visual Basic for Excel 2007.
  486. Conditional formatting lowest number greater than zero
  487. Create Macro to pull data from a warehouse management system?
  488. Export as pdf form to ipad
  489. Look UP formula by referencing certain values of lookup cell
  490. Ribbon Display Options askew??
  491. How to Recover excel file?
  492. Re: Print titles must be contiguous and complete rows or columns
  493. Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham)
  494. Formatting AlphaNumeric string in a cell
  495. Suddenly a caret sign appears every time I type an equal = sign
  496. How pull ID#s that meet specific "yes" requirements
  497. Numbers change in cell even when formatted as text
  498. Re: Dragging Cells to Create Ascending Numerical List
  499. Bold rectangle cursor in VB Editor
  500. Formula result not displaying correctly in cell
  501. Conditional formatting - using a value to control color of bar
  502. Column Chart with one of them Up Bottom - Is that possible with Excel?
  503. files wont open
  504. Securing an Excle File?
  505. Why this paste result?
  506. Populate 2 worksheets based on a master.
  507. Color above and below trend line
  508. Advanced Filter : Multiple Not Equal Filter SOLVED!
  509. Blank typing, then appears...
  510. problem with fractions to decimal
  511. Next January 1 or July 1
  512. Data Validation Error Not Working On Paste Special Values
  513. How to convert , comma to . dot in excel to do the following calculation?
  514. If function with lots of criteria
  515. This has got to be fairly simple, so...
  516. Find and Select in Excel on Mac
  517. Find First Negative Number after 'X' has been reached
  518. MegaStat Add-in Error
  519. Filling Empty Fields
  520. How to Search down a column fo a specific number of digits
  521. disable f lock on HP pavilion dv7-4277
  522. Updating gestational age based on today's date
  523. converting money formatting
  524. Cell format to remove decimal and keep zeroes
  525. Merging multiple columns into one column (dynamically)
  526. Find the max number of objects to be placed on a surface
  527. Automatically Repeating Rows on Each Tab?
  528. Removing Line Breaks Within a Cell
  529. Re: How to restore a file ??
  530. How secure are Excel passwords?
  531. best Graphic design company in Chennai
  532. Plz Adding me <3
  533. Can I get date in this format?
  534. Make Data Associate with Text
  535. writing a sort macro
  536. Pivot table filter list - listing irrelevant subcategorys
  537. Find nth position of word
  538. Using AutoFilter from VBA
  539. Re: Can't Break Links
  540. Stacking data in 3d Line graph with a multidimensional array [10][4][10]
  541. Activating hyperlinks
  542. Formatting a Spreadsheet
  543. Formula help
  544. Need IF Statement to yield percentages
  545. Help/Check my Formula
  546. two macros together
  547. What does { } mean in excel formulas?
  548. Starting a new line
  549. Trailing 30 days sum calculation with excel
  550. What does "" mean in Excel?
  551. Sum value in all columns that their title is the same
  552. Can someone fix this IF(AND) for me?
  553. Camera Tool Linked Tables Keep Recreating Upon Opening Workbook
  554. How to STOP Excel from changing my data
  555. Split Business Name and Address into 2 fields
  556. counting blank cells within two columns
  557. Dropbox change Trigger an event
  558. Excel to PDF or XPS boilerplate routines
  559. macro to print report
  560. problems getting this macro to work
  561. macro to print xps then save with name value in (B2)
  562. Sending An email through Gmail without STMP
  563. Random time?
  564. Associating messages with random numbers?
  565. Locking Macros from being edited, but not viewed.
  566. Remove date format?
  567. Help with an Excel macro please?
  568. Cannot copy worksheet to another file
  569. Splitting cell contents into other columns
  570. looking for excel formulas when time is used
  571. Re: Print titles must be contiguous and complete rows or columns
  572. how can i ask excel to find "Event" AND NOT "Eventdate"
  573. Excel Issue with "Average" showing in Status Bar
  574. End(xlDown) Issue
  575. Power Pivot Variance Column
  576. why comes the error?
  577. how to get the total of two lines
  578. Re: Split hours and minutes in two different cells
  579. how can i print non adjacent pages from a worksheet
  580. how to add a combolist drop down to each row
  581. how to get the resultsheet from the markslips
  582. how to append a phrase to a cellcontent
  583. why the macro is not included in the list?
  584. Seeing Two Different Excel Files At Once: How, please ?
  585. Lookups In Excel
  586. what are the posting options in excelbanter?
  587. Pivot Table with Data Model Connection - getpivotdata #REF error
  588. Re: Get Column Letter of Active Cell in VBA
  589. Saving a range for later reference
  590. how to get a simple macro to paste value
  591. how can i change a sequence of numbers using find replace
  592. INDEX / MATCH Table Values
  593. Flag or Delete a line from Sheet 1 if a wildcard search matches froman Exclude list of words in sheet 2
  594. Copy unformatted value of cell via macro
  595. Excel 2007: Help creating a macro that will run Solver?
  596. Excel 2007: Help creating a macro that will run Solver?
  597. Excel 2007: Creating a macro that will run Solver.
  598. is it possible to ask excel to input from another sheet?
  599. if there is a blank ,how to get the blank cell in a range be highlighted
  600. Format Cells
  601. how to get the content in bigger font and in color when points
  602. drop box/data validation help
  603. Calculation based on year of entry
  604. convert CSV to XLS format using command
  605. Countifs or a pivot
  606. Complicated Match Formula with conditions
  607. Exporting Data From Excel to SQL
  608. Split cell based on uppercase letter
  609. shortcut-> deleting entire row (not just the data)
  610. Formula IF
  611. Need a formula for a descimal integer into a whole number
  612. Re: Split hours and minutes in two different cells
  613. Find text in cell and copy from 4 characters in front of the found text.
  614. Inserting a colon into text
  615. Re: Persistent "Formula refers to empty cells" error despite cellsevidently NOT being em
  616. Creating sequential numbers plus a letter
  617. IF formula with certain conditions to achieve a desired value
  618. Expanding Date formula
  619. Entering a Text Symbol ?
  620. Having Blank Cells, etc. ?
  621. Sharing workbooks limitations - Merged Cells
  622. Return column values based on criteria (HLOOKUP & VLOOKUP?)
  623. Conditional If/Else statement
  624. Copying Rows with values in column A pasting in a new doccument and saving that doc
  625. Can the IF function be used with values from multiple worksheets?
  626. Drop down in Graph (excel 2003)
  627. Removing overlapping values
  628. Golf scores
  629. Inserting slashes in dates in Excel
  630. Conditional formatting for time
  631. Re: "natural join"
  632. Re: Need a QIF to CSV/XLS converter! Is there any??
  633. Default font for comments
  634. Password protecting multiple pages, and then some.
  635. Code to format cells on several worksheets
  636. 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
  637. data spans multiple rows within each cell is collapsed when FILTER is used
  638. Inserting columns
  639. Re: Graphics in a Cell Comment
  640. WEB QUERIES ID and PASSWORD
  641. Re: Excel Passwords
  642. microsoft excel has stopped working message giving by program
  643. How to delete ALL cells containing the same data --- REVISED
  644. How to delete ALL cells containing the same data
  645. Re: "natural join"
  646. test
  647. Excel Date Formatting
  648. Excel Dash formatting
  649. Dates, And Their Corresponding Numbers: How To Show ?
  650. Enter carriage return in Excel 2010 text string
  651. New to Banter...
  652. Parsing
  653. How to print cell # while printing in excel
  654. When I insert a worksheet the cell format is accounting
  655. Sorting Revision Labels in Excel
  656. what do these ----> {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula?
  657. Email notifications, does this forum have that deature?
  658. How to filter rows data based on background color of individual cells
  659. Standard Deviation and Averages based on criteria
  660. Print on only one page
  661. Pie Chart and Table Query
  662. IF Statement accepting only positive values
  663. Re: Print titles must be contiguous and complete rows or columns
  664. Keep spreadsheet on pc & laptop in sinc -how?
  665. Macro for updating the filename along with data
  666. Excel CSV Files; Creating Of
  667. Excel And Notepad
  668. How to Update SUM formula after inserting rows
  669. Quote Marks Question
  670. For Claus Busch: From OP Re Quote Marks.
  671. Comparing two lists in Excel
  672. if statement with vlookup
  673. Adding Quote Marks To A Very Long Column. How, Please ?
  674. How can I keep zeros in the beginning of a mobile number @
  675. Help with Sumproduct searching cell contents
  676. If Function neglecting 0 as a number
  677. If function..please help
  678. Need help with IF statement (function)
  679. Need help with a formula...
  680. Need help with an IF Function
  681. Search cell value in same column
  682. Locking Pages and/or Workbook
  683. Web Query
  684. Pivot Table - Row Label Combination
  685. Anyone having problems with Outlook macros after updating to Windows 8.1?
  686. Change Color of cell
  687. export data by selecting date range
  688. Find value based on two lookup values
  689. VLookup or Macro?
  690. V Lookup multiple entires
  691. VLOOKUP isn't working properly in Excel on Mac
  692. Run-time error 1004 - can anyone help with this macro please
  693. Conditional formatting with dates
  694. Re: Get Column Letter of Active Cell in VBA
  695. is it possible to sort by approximate date?
  696. Blank Sheet with Gridlines
  697. Calculating interest due on late loan payments
  698. Counting number of items excluding duplicates.
  699. Re: Get Column Letter of Active Cell in VBA
  700. Font is changing when editing a cell
  701. Re: Excel file recovery
  702. how to fix REF and VALUE with a circ ref with iteration
  703. excel files get lost
  704. iserror problem
  705. Help with an Excel formula please?
  706. Copying data into new text file with script
  707. Re: Freezing Conditional Formatting
  708. Building a pivot with a massive data set
  709. Weird behaviour when entering hyperlinks
  710. Keyboard shortcut to select a column?
  711. PivotTable - Filter Row
  712. Help with time formats in Excel 2007,
  713. How To Have A Cell Be Blank If...
  714. Re: convert CSV to XLS format using command
  715. Template Wizard w/ Data Tracking add-in
  716. Indirect
  717. Look Up values from a pivot table
  718. how to format cells -fill color
  719. Pivot table put multiple "Values" in one row but I want them in one column.
  720. Formulas Won't Run if I Open File from Explorer
  721. What does "" mean in an equation
  722. What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke
  723. Code to delete rows based on value
  724. Help please with cut paste and formulas
  725. Help with last 7 days running total
  726. I need help please
  727. If then formula with multiple cells
  728. How to fit data for a 3 variable function
  729. The picture is too large and will be truncated
  730. countif with some conditions
  731. Index Match QUestion
  732. Greater Less or Equal
  733. Re: Split hours and minutes in two different cells
  734. Create a new set of data from 2 data sets
  735. MouseOver/MouseHover Event On Autoshapes
  736. Find Duplicate names listed in opposite order
  737. how to carry forward a total from one page to another
  738. Revenue for month
  739. Array formula - nee help
  740. Multiple functions
  741. How can count the number of cells that fulfill certain criteria in other cells
  742. Data Lookup - Copy and Paste
  743. Data Validation "The Source Currently Contains an Error"
  744. Excel Saves Random .xlsm File Everytime I Save
  745. sirfpaisa - What Is Equity Stripping?
  746. Concatenate, currency & sum formula
  747. Remove border
  748. Re: How to Get Filtered Data from SQL server into Microsoft Excel 2007
  749. Complicated look up formula with simple calculation inserted in the formula
  750. How to insert border around text in footer dynamically in excel?
  751. Help with calculating time and a half - I've got straight time and double time.
  752. tiny discrepancies in fixed-point numbers
  753. How to create absolue path link to another workbook (Excel 2003)
  754. Excel Visual Basic to get current row number
  755. Help with drop down selection and populating related data...
  756. Yet More Excel VBA Help Please
  757. multiple scenerios in excel
  758. Find date in excel string previous to last occurence of specific text
  759. More VBA Help please
  760. Multiple worksheet summary
  761. Excel VBA setting Ranges
  762. Conditional Formatting
  763. I need to cut characters off of a list of text cells...
  764. Comparing columns of data?
  765. Multiplying Values only less than 1.5
  766. "If" function and Upcoming Dates
  767. After Copy Past shows Error. (#VALUE!)
  768. Extract data in rows (with line breaks) to form a table
  769. CSV->Excel Data Problem
  770. Re: Exceeding 64000 rows in excel
  771. Distributing cell value (not text-to-columns)
  772. Are the parentheses the problem?
  773. Index/match across multiple columns?
  774. use xlup and offset in a range of cells
  775. Copy pair of columns
  776. Testing for hyperlink error
  777. Getting Text data using the Data - Subtotal feature
  778. Cannot remove empty rows
  779. Count After Filter in macro
  780. Determine if night shift by start & end time
  781. Excel 2003 save as .XLSX
  782. Re: How create a Purchase Order Form that stores data?
  783. Re: How create a Purchase Order Form that stores data?
  784. if cell is blank
  785. Compile Error help
  786. Negative value to positive
  787. Problem Re Passwords, etc.
  788. Auto date function in the footer
  789. How to invert Cols/Rows?
  790. Help with Column to Row formatting
  791. SUMIF evaluating blank DATE data
  792. Advanced Sort/ look
  793. Spellchecker anomaly... Checks spelling on a Forms Button text label...?
  794. Countifs with if and date range
  795. Index/Match Lookup with a merged col
  796. Slicers and Calculated Items in Pivot Table
  797. Filtered drop down list
  798. Excel 2007 pivot table using analysis services cube as data source
  799. Excel Stops Working
  800. Spell Check Protected WORKBOOK
  801. Excel Stops Working
  802. Change text color with an IF statement
  803. the cells that some rows have in common
  804. need to extract email addresses from excel files
  805. a function that deletes all rows with no value in a certain column?
  806. Ignoring specific number
  807. Need IF statement to categorize time into "Morning", "Afternoon", "Evening"
  808. Find & Replace problems... at the end of my thread (ha)
  809. Count If Formula Not Working - Help!
  810. My Data Has Headers
  811. Drop Down Calendar in Excel with a Default Value
  812. Re: Trapped in a cell!
  813. Finding Text within an Array
  814. how to write a dependent validation with all numbers
  815. Paste embedded file corrupts?
  816. File extract error?!?
  817. IF Statement Reading Zero's
  818. need help writing formulas.
  819. Speeding up Excel simulations
  820. TEXT "ddd" giving #N/A on some machines
  821. L2013 not running code from XL7, second posting
  822. XL2007 code not working in XL2103
  823. Make peak values move to low value region - Peak Lopping - HELP!
  824. Scientific Notation
  825. Assigning a value to one cell based on the date in another... And then doing it again
  826. prevent deletion of a workbook in a shared network drive
  827. prevent deletion of a workbook in a shared network drive
  828. IF statement help
  829. Separting negative numbers from letters in cells
  830. Randomizer
  831. CountIf from multiple sheets in another workbook
  832. if row has duplicates, concat entries in another column?
  833. sumproduct with COUNTIF With An INDIRECT
  834. Complicated Data Selection
  835. Formula Help
  836. Count the number between range of cell for a particular person
  837. Sum to a mid point in a dynamic table
  838. Look UP and then caluclation with IS ERROR
  839. Finding required growth rate
  840. adding up checked boxes in cells in a row
  841. Combining Duplicates
  842. need help in fine-tuning a formula that removes blank cells in a column range
  843. Converting images into Excel Mosaics
  844. Creating a Dropdown that is Related to the Value Given in Another Cell
  845. Index and Match
  846. Converting billion to million
  847. Date Calculation - Astro Calculation
  848. LookUP certain words and return back corresponding values
  849. Formula help - Match & IF
  850. Extract numeric values from an alphanumeric cell based on a criteria
  851. How to count but exclude overlapping data
  852. Re: Excel.csv file problem
  853. Printing line numbers
  854. Merging data
  855. Complex Timesheet
  856. Multiple files open when starting Excel
  857. Excel Copy & Paste Issue ??
  858. Highlighted
  859. How to synchronize all cell values?
  860. Formula to Look up values from a pivot table
  861. adding accross sheets
  862. data from multiple files: best way to extract
  863. Formula fill series?
  864. complicated excel formula may need an algebra wiz
  865. File Corrupted
  866. Complicated Look UP
  867. Top 5 list if data meets a criteria
  868. Master the Checkboxes
  869. Number range as a percentage
  870. Userrange to formula
  871. reverse pasting rows with alternate blank cells
  872. Using Drop Down list to an If Statement to another Drop Down list
  873. Removing Unwanted Data
  874. External links not updating
  875. Excel - different figures returned?!
  876. Improve speed of the routine
  877. Colour Coding dates
  878. Copy All Visible Cell Of Sheet1 To Sheet2 Last Blank Row
  879. How to avergage colums
  880. Help!! find two number recurring numbers in row??
  881. Complicated Pivot table
  882. Excel vba UserForm Lists not registering default values?
  883. Excelling, the iPhone reference for Excel
  884. Look UP formula for 2 and 3 conditions
  885. how to make a sheet invisible?
  886. Return values from one column IF a certain value in another column
  887. how to get the percentage symbol with the result?
  888. Assign numerical value to text in a cell
  889. Import Multiple CSV Files from Same Folder into Open Workbook
  890. Re: COMBIN
  891. how to show that a thread solved?
  892. how to get a range of cells rounded off to the nearest value?
  893. how to link ranges into transpose style?
  894. Searching And Summing
  895. Formula to calculate commission based on sliding scale
  896. Matching data in columns
  897. "cannot shift objects off sheet" error
  898. Using Excel VB, Update a specific cell, on any change of anotherspecific cell
  899. Return last non-blank cell in column
  900. Match Copy/Paste Macro almost there
  901. how to find text vaues for a given grade?
  902. Puzzling quotes around text
  903. numerical value to text description
  904. Possible to have multiple sheets refer to a master template sheet?
  905. How to pull in data from rows and columns if there are blanks?
  906. Convert multiple columns into a single row
  907. display '2+2' as '4' in a cell?
  908. Excel opening MSSynch in 2010? How to stop it?
  909. countif on multiple criteria
  910. Macro
  911. how to select contents from a col which lies in between other columns
  912. Find values across a row and return a text value from the same column
  913. Search multiple words and display result?
  914. Automatic printing by filter?
  915. Crazy Variance Formula
  916. summarizing data from various workbooks
  917. Assigning values
  918. How do I reference one OR another worksheet?
  919. Excel equations
  920. Does Publisher 2013 have autoflow?
  921. Re: bullet point lists in Excel
  922. Axis formatting
  923. find -> list of records
  924. To Garry of GS Excel contribution fame
  925. How to extract data from a spreadsheet into a form/create form from spreadsheet data
  926. Search OF Macros for a specific phrase
  927. check first 3 characters of a cell and compare to a table
  928. How can i extract certain text out a cell and copy it to ther cells
  929. Currency autofit
  930. how to convert grades into a value
  931. How to use Sumifs with vertically and horizontally criterias
  932. Large Excel Email list with Non printing character
  933. Pulling a specific email from cells and putting info in new row
  934. Splitting single table to multiple tables?!
  935. Multiple items selected multiple dependancies available
  936. How Can I subtract from time within a 24 hour clock?
  937. Cross referencing a weekly menu list with a grocery list
  938. excel partial match
  939. Living in one place or always moving for a good job, house, or even climate:
  940. If statement for a range of cells
  941. ="'"&F1&"'," Excel errors in one spreadsheet but not other one?
  942. Duplicates Deletion ?
  943. Changing Text To Numbers ?
  944. how to encryption and dencryption
  945. how to copy paste the figures in adjoining cells?
  946. For Joey2004 et al. From OP: Re Appending Question
  947. Appending Text To Numbers ?
  948. Average problem
  949. Re: Print titles must be contiguous and complete rows or columns
  950. excel 365? develop offline?
  951. Calculate horses age as at 1 August
  952. Countif to exclude blanks
  953. Some chart types cannot be combined...
  954. Re: How to Get Filtered Data from SQL server into Microsoft Excel 2007
  955. Problem with user functions in Add-ins for multiple persons
  956. GETPIVOTDATA #REF! error XL2003/2010
  957. Date Conditional Formatting
  958. Opening excel 2010 spreadsheet from Access
  959. Formula Question
  960. Copying puzzle
  961. Using Auto filtered Data
  962. Unable to freeze panes
  963. U*nexplained ribbon change
  964. Dropdownlist and Vlookup
  965. Data Validation List
  966. Add image in forum
  967. Changing Monthly Data to Daily Data?
  968. Rounding dollar amounts to the 9 cents
  969. Permanently link formula references to Column Names and not Column Cell Numbers
  970. Additional columns for Pivot table
  971. Need urgent help with excel formula
  972. Forgot Excel Password
  973. To remove #DIV error
  974. Formual to lookup sumtotal from data with spaces
  975. Formula for percentage calculation
  976. Add numbers if cell fill is a certain color; How To?
  977. Moving Average
  978. Conditional Format Entire Workbook
  979. Formula Help
  980. Excel date formate doesn't change
  981. Start sheet in a workbook
  982. Excel on Iphone
  983. Look UP using 3 conditions
  984. hide row with drop down value
  985. Excel dup names not listed merge cells
  986. Excel Bug
  987. trying to figure out Count feature
  988. Shared File problems over VPN
  989. Copy rows to new sheet based on value in column A
  990. Transpose
  991. Why cant I expand the equations parameters without error?
  992. Subcategories in Drop Down List
  993. Trying to create a dynamic filepath within VB
  994. No tools manu?
  995. Splitting multiple values in cell & automatically running a conversion between units
  996. Unlink cells- how?
  997. count data between two same data
  998. Averaging feet and inches (not decimal feet)
  999. VBA not selecting worksheet with titles
  1000. Cell not calculating after importing data