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. Last piece of text in a string (multiple lengths)
  2. Linking a pivot table filter to a control cell
  3. Tricky lookup problem
  4. How to convert into number?
  5. creating a query using MSQuery
  6. Combining and merging duplicate data.
  7. How do you deactivate cells in Excel?
  8. Jumping To Precedents On Other Sheets
  9. Database
  10. freeze and split at the same time?
  11. Merging duplicate lines in a Database
  12. Vlookup to count non blank cells
  13. Column Data to Appear as Column Headings in Another Sheet
  14. Deleting double rows
  15. Calculated field - pivottable
  16. setting range criteria in pivot table
  17. please help (drop down list)
  18. I have a formula that uses this { } but can't duplicate it
  19. insert a hyperlinked TOC (of sheets) into Excel
  20. remove task panes in Exel 03
  21. Formulas over multiple cells
  22. The file is corrupt and cannot be opened
  23. Macros
  24. problem with indirect
  25. How do I capture a date?
  26. ignore cells that are blank
  27. Need help linking spreadsheets and displaying only populated rows
  28. percentages
  29. How do I remove LOTS of blank rows at once
  30. Hyperlink or, use what?
  31. 16 digit numbers
  32. inserting a subtotal
  33. Return Header
  34. Decimal Rounding
  35. Removing duplicates
  36. Working on multiple spreadsheets at the same time
  37. How do I export contacts from Excel to Outlook Express?
  38. worksheet tabs
  39. attache' 4 GB
  40. Finding Contents of a Specific Cell (Address) out of 1000's of Add
  41. Are Date filters available for items in the Filter area of pivot t
  42. result will go to right box
  43. sum a specific range
  44. Get Pivot Function - Use of Pivot Table Name
  45. Printing page numbers
  46. tweecijferige getallen beginnend met een 0
  47. totally lost - named range and vlookup
  48. Formula to calculate business day
  49. Conditional Formatting - Excel 2007
  50. Number Sorting
  51. Faster closing of large spreadsheet
  52. a blank page appears at the end of a printout in excel
  53. Convert Time to Number
  54. Can't exit Design mode because control 'SignCal' can not be created...? VB
  55. Remove # Symbol
  56. Removing parts of Data in a Cell / [], #
  57. HOW CAN I ADD UP ALL VALUES WITH THE SAME REFERENCE..
  58. Excel drop down list
  59. How do I return the value of an adjacent cell?
  60. Opening a PDF in Excel 2003
  61. Sort all worksheets in a workbook
  62. Remove all define Name
  63. Launching A Worksheet in Excel 2007
  64. Number of Occurrences of a String Value within a String
  65. Dynamic report based on user input
  66. how to count the number of occurences of a letter ?
  67. Compile error
  68. Make a "BLOCK Form" in Excel?
  69. Troubleshooting
  70. how do you know if the caps lock is enabled in ms office 2007
  71. Formula based on condition
  72. Formula or macro needed for sorting complex data issue.
  73. George Excel
  74. Adding cells depending on a date
  75. Headers and Footers size
  76. Most commonly dialled extensions
  77. Count of Different Columns
  78. How to set the formula (26 Nov)?
  79. How To Percentrank by Specific Range
  80. same range name in different sheets
  81. Converting Address from one column to 8 columns
  82. How do I save a text to speech document?
  83. How to do it in excel?
  84. Link to a Particular Excel 2007 Worksheet
  85. Dates in Excel 2003
  86. Excel hyperlink loses its path on save
  87. Is there a way to prevent Excel from automatically formatting data
  88. AVERAGE function
  89. Mass move data in rows to columns.
  90. Screen flashing
  91. open a file
  92. nested function limitation
  93. Conditional Formatting - recognise #N/A
  94. vlookup in excel 2007
  95. duplicates
  96. any way to check if a cell with perticular text is in the same pla
  97. Special Characters causing problems
  98. Calculation not working?????????????
  99. Formula Help
  100. Dynamic Range (again)
  101. VLOOKUP as a vb code
  102. find & replace - digit wildcard
  103. Combobox dropdown list???????????
  104. Duplicate Remover
  105. Default Template - EXCEL 2000
  106. Help ~ Trying to Lookup from multiple pages
  107. Keying in numbers makes curser jump
  108. Suddenly checking links
  109. Making Me Crazy ~ Please Help...
  110. Descriptive Statistics
  111. Input Box for today's date
  112. Is it wise to put pdf pics next to peoples names on spreadsheet?
  113. inserting a pdf file
  114. How to rank
  115. Help Creating a Drop Down List from a List in another worksheet
  116. change date abbreviations in excell 2003
  117. can a work sheet have an alert to calendar
  118. Creating Text based chart and formula help?
  119. como ganar dinero facil
  120. blinking or flasing fonts or background in Excel
  121. Sales Cost Calculator - lots of variables!! Help Please!
  122. Change Data Source for Multiple Pivot Tables
  123. Check Box better printabilty
  124. Merging/Combining workbook data
  125. matching up data
  126. Referencing the same cells
  127. Conditional Formula
  128. Macro to retrieve information
  129. Find Period Date?
  130. multiple user in excel to edit a userform
  131. my excel sheet is not displayed but black screen appears
  132. Real Data Formatting Challenge
  133. CF using Toggle Button result
  134. Table lookup
  135. Comparing Data on 2 sheets
  136. adding a formula to items in a drop down list
  137. Keyboard Shortcut to toggle b/w Find and Replace and ActiveWorksheet?
  138. #num fix
  139. automaitcally changed text when copying
  140. Excel Auto Filter
  141. #VALUE! error
  142. Very slow to save file
  143. Need to split a cell in a column
  144. Vlookup
  145. deleting a calendar
  146. counting by group
  147. Data Validation...I need to add more entries!!
  148. Data Validation List from different sheet
  149. Potential Bug in Find All application
  150. cannot view all of the data in a cell
  151. Automatically Sort Alphabetically
  152. Vlookup Function
  153. Finding a word in CSV files
  154. autofill variable lenght column w/ sequential numbers using VBA
  155. how do i prepare a macro to insert drawing object on specific cell
  156. Formats in formulas
  157. Need Help Copying Excel Files to a CD
  158. Re: dropdown lists and populating new table based on the selection
  159. No color is showing up when cells are selected
  160. An alternate input method?
  161. Can I use a formula to copy info while adding a whole new row?
  162. time claimed
  163. building a value for a filter
  164. How the conditional formulas work
  165. Return blank not 0
  166. powerpoint show
  167. Cell to return blank not 0
  168. how do i correct this error
  169. weird! Excel refuses to compute numbers...
  170. Return blank
  171. Can I move the excel input box to the bottom of my screen.
  172. How do I get the different excel docs on 2 different screens?
  173. Build and execute dynamic instructions
  174. Ignoring a cell contents
  175. Opens as Read Only
  176. Compensating for Excel rounding errors
  177. Default Printer
  178. I have a problem with a formulae.
  179. How do I change name in single cell from last, first to first last
  180. Cell size 2007
  181. Sumif() with dates
  182. how do I merge two 2007 excel documents
  183. Check boxes
  184. How to remove newlines from worksheet
  185. Data validation between workbooks
  186. Conditional Formatting (Excel 2007) Format Row Color Based on X
  187. Identifying numbers froma text
  188. Quick Sort
  189. Drop down lists in excel
  190. Defining Names for Outlook's import feature
  191. generating list of data from frequencies
  192. Sum
  193. Excel 2007 SP1 will not repaint the entire spreadsheet.
  194. too many formats
  195. Using IF functiona and validation list
  196. Changing text color based upon If
  197. List Box in Control Tool Bar
  198. InputBox Help
  199. Encryption type settings.
  200. Sumif that returns specific limited/rolling range
  201. Trim all but the last four digits off a list of SSN's.
  202. Status bar disappears when restoring screen size
  203. how do I merge two files?
  204. how do I unmerge an excel document?
  205. File names within formulae
  206. Find within Date Range
  207. "Object doesn't support this property or method" in Excel 2003
  208. Printing ranges
  209. Macro to print a cell range
  210. Slow Calculation
  211. Chinese Text in Excel 2003
  212. Please help. This is way too tough for me.
  213. 3D pivot tabling
  214. Questing regarding Date Stamp
  215. Unhide multiple sheets
  216. HOW WE CLOSING MS.EXCEL.
  217. Can pivot charts show MMM formatted dates
  218. Can Pivot charts show dates in MMM format (excel 2003)
  219. inconsistent order of dates on pivot axis
  220. Recent Documents List is Empty
  221. Bar and Line graph combi?
  222. Excel 2003 Pivot Table Anomoly
  223. Subtotals and copy and Paste
  224. 4 SETS OF CRITERIA USED TO DISPLAY ANSWER
  225. how do i save file to show current worksheet
  226. جندي بريطاني ... يتحول الى امرأة بعد رجوعه من العراق !!! بالصور
  227. formular discrepencies
  228. How can I add to a drop down list after I have selected it?
  229. How do I reference the same cell in all previous sheets?
  230. User ID
  231. Conditional Formatting Excel 2008
  232. pivot table
  233. Paste issue
  234. The Paste Function in Excel 2007
  235. InputBox with VBA
  236. Two functions in one formula.
  237. How to use 'header' tags<h1>etc in web pages made w/ Excel ???
  238. How can I isolate the last two words in a text string?
  239. Format Checkbox text
  240. 2007 List of Open Files?
  241. Manage worksheet with lots of information
  242. edit & configure add button & code
  243. Save As
  244. Re: Spreadsheet Help Please
  245. Excell Row Selection Problem
  246. Largest Prime Number
  247. How to select the date?
  248. How to determine the frequency?
  249. fomula which returns the amount depending on the currency code
  250. Vlookup
  251. nesting if formula
  252. NEED A MACRO CODE TO USE IN A USERFORM
  253. Import Multiple XML Files into Excel
  254. not sure how to resolve this issue on my computer
  255. generating unique reference number
  256. How to determine the highest occurrence?
  257. Removing ' from a lotus file
  258. Works in 2007 but not 2003
  259. How to recognize changes in slope of data?
  260. how do have 2 conditional formats for one cell
  261. edit configure add button and code
  262. Formula Calculation
  263. Excel read only or enc
  264. Make a smaller version of excel doc, 4 to a page?
  265. How to display the value in different format?
  266. if question
  267. Report
  268. macro criteria copy
  269. How to import PDF into Excel?
  270. Excel 2002: How to lookup the last number and text in a column ?
  271. Could not load object
  272. formula for different values
  273. Selecting Multiple items from drop down list
  274. 1+3+5+7+9+11+13+15+17+19=100 make a sum of 5 numbers make 50
  275. Sorting
  276. the grab and drag function isn't working in excel any ideas?
  277. How to open "bas" file?
  278. Hide columns but not the top rows
  279. How do I write a formula to obtain information from another spread
  280. When I add a row to my source sheet, it doesn't update my linked .
  281. There is no row at position 0
  282. Logical functions If, And
  283. Printing Worksheet/Workbook
  284. Pivot Table - cells imported as 'Blank'
  285. how to create new row in excel when a new records is added in acce
  286. Dynamic list on a cell
  287. Create a worksheet based on filtering of another?
  288. Switch between relative, absolute, and mixed references
  289. Looking up duplicates
  290. Excel 2003 to 2007
  291. Convert rows to columns
  292. Runtime error 1004
  293. Combine text and formula
  294. totaling & averaging a spreadsheet
  295. #num
  296. Taskbar
  297. DOS Command
  298. Unprotect sheet to "Refresh All" Access queries
  299. On call calendar question
  300. Working with links
  301. How to get excel to export quotes always...
  302. Forcing a workbook to open on a certain page
  303. Complicated (I think) formula (Excel 2002)
  304. Records Database
  305. Opening at specific cell - No Macro
  306. Worksheet as an image
  307. Using Hyperlinks in Excel on web
  308. Comparing Data Across Cell Ranges
  309. automated list form a different source
  310. how do i get cells in Excel to appear bumped-in or bumped-out?
  311. Removing password protection from an Excel workbook
  312. formual to determine if date falls on weekend, adjust date to Mond
  313. Formuls not working (Excel 2007)
  314. Excel 2002: How to identify error in a column ?
  315. Excel 2002: How to get the first and last reference in a column ?
  316. How to show "DRAFT" on print versions of test documents.
  317. Nested If
  318. Tab Order between Cells and Text Boxes
  319. SPLITTING DATA INTO NEW WORKSHEETS FROM ONE WORKSHEET
  320. How to delete a row if strong NOT found....
  321. Sort with blank rows between data rows
  322. Help understanding CSE results
  323. Excel 2007 - Page layout view is not compatible with freeze panes
  324. Change ref type
  325. Syntax error
  326. Counting how many days since last accident occured on the job
  327. deleting lots of hyperlinks in Excel 2007
  328. How to set the formula?
  329. Help with Printing Userforms
  330. Problem copying Chart and Data from Excel 2007
  331. Copying cells between sheets in a workbook
  332. Help With Manipulating Data
  333. vb code help
  334. If Formula?
  335. Changing link target
  336. running proc in excel
  337. Problem pasting jpg file into cell
  338. Drop down lists and comments
  339. If excel sheet protected, combo boxes won't work
  340. Print Preview Discrepancy
  341. macros
  342. circular error problem for vat calc
  343. formulas
  344. Keeping track of useful hints in Excel Community
  345. Goal Seek in a Macro
  346. consolidating customer list for mailings
  347. changing zip code to number
  348. Auto Copy/autofill Text from sheet to sheet if meets criteria
  349. Formulas
  350. CountIf to determine Date - 3 yrs
  351. Collate data
  352. Auto numbering inserted rows.
  353. How many characters does an Excel cell hold?
  354. odd behavior
  355. How to convert text to number?
  356. Dynamic Chart Question
  357. Dispaly results, rather than a formula
  358. Comparing information on 2 worksheets
  359. Printing UserForms
  360. how do i graph the first derivative of a line
  361. Mouse Wheel does not work in Excel
  362. count / match
  363. Save changes? even when you've made none
  364. Conditional Format Font Vs Normal Font
  365. Cell format problem
  366. COUNT
  367. Excel Attachment
  368. subtract a range from an added range
  369. How do you change the font in the pop up spell check box?
  370. Relative Hyperlinks
  371. how can i insert a picture with formulas?
  372. Can I create a sports schedule in Excel?
  373. Importing external data into non consecutive rows
  374. Auto fill adjacent cells
  375. Help! Drop down list problems.
  376. Excel "Offsetting" Rows
  377. How do I create a purchase order log in Excel?
  378. How many total worksheets can be added to a workbook?
  379. capitalize first letter
  380. Dates in cells are no longer visable but are showing as ########
  381. Scroll problem
  382. Adding additional worksheets to an existing template
  383. Fill in formulas for rows with data only.
  384. if condition on currency formated cells
  385. Need help with formating cell
  386. Import External Data to template format 2007
  387. How do I set up hierarchy in Excel?
  388. Keyboard shortcut
  389. Xlookup that returns variable sum data
  390. Pulling info referencing another column
  391. Copying and Pasting VLOOKUP/HLOOKUP Formulas
  392. Index, Match, If
  393. Blank line after control break
  394. how do I generate a unique reference number???
  395. Match, Index, If
  396. How to direct to a cell from text
  397. Pop up menus !
  398. My columns now have numbers instead of leters, how do I change thi
  399. Convert Excel document to PDF with different page orientation
  400. Sort data with blank rows dividing data
  401. editing comments in MS excel 07
  402. Automatically Change Formula Cell reference
  403. ACTIVATING A SOUND ALERT ON CELL VALUE
  404. in excel 2007, how to remove all the text box in one operation ?
  405. Linking cells
  406. how to change #num! result to zero?
  407. Why is Paste Link not available when I Paste Special
  408. can you create a spot in Excel which you can turn on and off by c.
  409. Compare Excel file size
  410. remove duplicates problem
  411. How do I print "DRAFT" on my worksheets?
  412. Excel 2002: How to make the date format uniform ?
  413. Excel 2003
  414. Temperamental VLookup - HELP!
  415. How can I create a macro for my email address?
  416. sales pacing example
  417. Lookup Issue
  418. Merging identical workbooks in Excel 2007
  419. using a cell as criteria instead of cell contents
  420. Protection Gets Removed!!
  421. format cell that contain text and fraction
  422. code to remove rows containing a character string
  423. Having problems with a calender
  424. Transfering one cell of word to excel
  425. How to set in LastSaved and LastSavedByin a Excel document (2007)
  426. How to set in LastSaved and LastSavedByin a Excel document (2007)
  427. How do I UNSHARE an Excel Workbook
  428. some test appear in wropng
  429. SUM alternate columns
  430. Referencing Defined Names in Other Workbooks
  431. Multiple if condition formula required
  432. Worksheet Name Variable?
  433. Replacing hard returns in long text strings.
  434. Blank Background.
  435. What would the term be????
  436. Error Starting MS Help
  437. SUMIF: How to add some cells and ignore other cells in a row
  438. Visual indication of trend direction
  439. Formula not working
  440. Data validation lists
  441. Lookup table_array
  442. Partial Hidden Text in a cell
  443. Conditional Formating Help Needed.
  444. Formula Content linked to other cells formula Content
  445. How to set the formula?
  446. NUMBER CONVERt INTO TEXT
  447. Excel won't open when it should.
  448. MS Excel Filters
  449. Excel 2000 problem
  450. Row height changes when spreadsheet emailed....
  451. Creating a calendar in excel with the data from another spreadshee
  452. How to add this?
  453. sumproduct conditional statement
  454. How to use indirect function?
  455. need a formula
  456. Hide Rows & Columns by date
  457. copying cells
  458. Looking for a function to use ...
  459. how do I repeat page headings on seperate pages?
  460. Generate a List By a Condition
  461. Text Box Format Default
  462. Static date
  463. Formula
  464. Looking up value
  465. Sum of values based on different criteria
  466. Filtered Counting
  467. In 2007 I am having difficulty distinguishing highlighted areas
  468. excel 2007 formula results not displaying
  469. Changing the Comments Font
  470. auto sum not working - how enable?
  471. counting
  472. Restricting Characters within a User Form
  473. configure add button & code
  474. Multiple Instances for Multiple Monitors...
  475. AutoCalculate appears disabled - how enable??
  476. merge multiple worksheets from multiple excel files into oneworksheet
  477. Vlookup with more than two values
  478. Calendaring Excel to either a Calendar Template or Outlook
  479. & to combine cells/Keep formats
  480. Row Labels
  481. Conditional Format
  482. Printing Excel 2007 Graphs
  483. drop down list
  484. My filter does not pick up all text
  485. how should I setup workbook to acheive my desired results?
  486. want image to define the cell size
  487. Custom Filter w/ formula
  488. Macro to include more cells for selection to print
  489. Cell Selections
  490. Automatically fill in TRUE values
  491. Finding Top 5 Expense Items with Comments
  492. Printing formulas
  493. How do I show + or - in cell without affecting formula?
  494. How can I show only rows that have data in excell 2003?
  495. default time to PM after 12:00 pm
  496. Can I send an inserted shape behind the cell text?
  497. why are column names are numbers instead of letters
  498. Custom Filter in a Macro
  499. Saving A 30 Page Report As A PDF
  500. Expanded V-lookup two coumns from seperate sheets return other col
  501. Editing Conditional formatting formula
  502. No more new fonts may be applied in this workbook
  503. add sheets to exsisting file
  504. Automaticalle generate sequential reference number
  505. Copy column to another spreadsheet but get value errors
  506. cell equal another cell
  507. Returning a value from text
  508. Brackets on one PC but not another in Excel 2003?
  509. Pivot Table Data Source
  510. Listing by category
  511. Increase Strings/bytes on a cell
  512. Saves worksheet as copy
  513. Wrapping text leaves blank line when printing
  514. LOOKUP problem with non-sorted vector
  515. Determining a future date, again
  516. Small spreadsheet opens with no toolbars?
  517. What date is7 days from given date in Excel 2000
  518. can a linked spreadsheets sort automatically when data is added
  519. Dynamic Autofill
  520. Installing Solver
  521. Data Validation on Data Entry Form
  522. How to set the value?
  523. Making a cell empty
  524. Selecting rows based on a value
  525. Add comments to a graph
  526. Filtering a list of words
  527. Excel 2003 comments lost in Excel 2007
  528. pivot chart default colours
  529. subtracting dates in an IF statement
  530. Can an excel cell/column be forced to CAPITAL letters only?
  531. How do I change the default log file location?
  532. Rows into columns
  533. Remove dublets
  534. Formula
  535. Using Excel and SQL
  536. Multiple if formula
  537. Opening Excel 2007 using Excel 2003
  538. Find the next date for a product
  539. Automatically hide a row if it is empty
  540. right click save as feature
  541. I cannot CANCEL 'Speak Cells on Enter'
  542. How to query a spreadsheet?
  543. TIME
  544. macro repeating getting the data
  545. Convert Excel 2007 data forms to Access 2007 ?
  546. Conditional Formatting
  547. How do I create open house flyer with 2-3 finance options ?
  548. Multiple Cells - Data Validation/Conditional Formatting
  549. Excel automatically changing my column with "E" to exponential Num
  550. DATE FORMAT CHANGE FROM EXCEL WORKSHEET TO PIVOT TABLE
  551. Help
  552. Gridlines and Margins
  553. Converting to PDF
  554. Can you prevent Copy-Paste from changing formatting without macros
  555. Fill Series Not Functioning
  556. Current Time
  557. User Defined Function is not working for me in Excel 2007
  558. Match criteria in two columns and give a third colums result
  559. Pgm on desktop "HotChocolatec" suptobe PPpgm. what is it? can't f
  560. comparing cells
  561. Delete Duplicates: Sum values & Consolidate
  562. Data in one cell = 1 in another cell
  563. one particular cell in a print area will not print out
  564. Minus Key Results in EXT Message in Status Bar
  565. Concatenating all records in column b where column a=x
  566. Time formula
  567. Columns only go to IV in Excel 2007
  568. text converted to scientific notations
  569. Column Numbers
  570. Use relative address for database query
  571. Search and match two colums give third column result
  572. email entire spreadsheet (unhide rows)
  573. Adding parenthesis to a formula?
  574. Add up a value that meets 2 criteria
  575. addbuttonandcode
  576. can you automatically size text to fill a column?
  577. how to use if statements or vlookups
  578. Copy only specific information from one colum to another worksheet
  579. Nested Formula Help
  580. SUMPRODUCT
  581. How to stop automatic cell shading
  582. Finding primes
  583. Show Formatting of Columns
  584. Summation fuction not working
  585. Data in cells with gridlines moves up within the cells.
  586. list duplicates
  587. highlight color missing when selecting cell ranges with CTRL key
  588. legend
  589. help with IF, if it is the answer..
  590. Sum If
  591. Missing Cheque numbers in a bank book
  592. VLOOKUP combined with AND
  593. Merging New Column Into Spreadsheet Each Month
  594. Excel (xls) files spontaneously converting to text files
  595. Varying selected cells returning value always to the same cell
  596. Re: Toggle between Worksheets
  597. Re: Toggle between Worksheets
  598. Toggle between Worksheets
  599. Shortcut for sheet tabs, name box, outline buttons
  600. Sorting with photos
  601. Input Time in AM/PM
  602. Data calculation
  603. uneven ranges and coding
  604. keyboard is locked after starting in both word and excel
  605. how to enable data option on a pivot table
  606. My spreadsheet will not update new info
  607. insert URL and data into cells
  608. VBA for Date custom Filter
  609. First Day of the Year
  610. Excel Headers & Footers
  611. formla
  612. Slow Calculations
  613. How do I increase speed of arrow buttons to move from cell to cel.
  614. excel 2007 - how to insert row with formats and totals of previous
  615. Creating Views within pivot tables
  616. How to overlay gridlines on a picture in Excel?
  617. How to keyboard select a row except the last two cells
  618. #n/a drving me mad, need to force ignore or remove them - Help!
  619. Nested lists in excel 2002 - newbie
  620. Worksheet will not scroll
  621. excel 2007 spreadsheet
  622. "How do I cross out boxes"
  623. Filtering Lists With Targeted Data in Multiple Columns
  624. How do I de-dupe two columns of data in excel?
  625. Pictures
  626. Dialog Box for un-connected links
  627. Enter text in a Combobox
  628. CountIF
  629. setting a cell length limit
  630. Filter based on Format?
  631. Time
  632. Linking IF formulas between 2 sheets
  633. Additional selectef name-filter
  634. Radio buttons
  635. How to remove text edit from Autoshapes
  636. Radio buttons
  637. Radio buttons
  638. Cumlative % on a Pivot Table
  639. HOW DO WE CHANGE THE FUNCTION BAHTTEXT TO ENGLISH IN 2007
  640. email excel sheets
  641. SUM IF sum of two collumns
  642. Setting the date format
  643. Adding values from adjacent columns
  644. Data Validation/Conditional Formating
  645. How many delayed per week
  646. How to find same number in different cell of Worksheet?
  647. RE:FILE CAN ONLY OPEN AS READ ONLY
  648. changing values
  649. Can I paste an EXCEL chart from a word doc into EXCEL and edit it
  650. Enquiry
  651. Now
  652. Hyperlink Copy & Paste
  653. Any way to Lock format but not the values?
  654. Excel Drop-down lists
  655. Read only file is NOT Read only
  656. Rosters
  657. Calculate the number of days from a specific date
  658. Macro needed to pull data from one worksheet and enter it in anoth
  659. sum based on 3 critaria from 2 columns
  660. What formula should I use to extract multiple data from one column
  661. text in multipul cells
  662. Extract number from text string based on number's format?
  663. SumIF Formula
  664. entering a whole number e.g. 4, results in a decimal entry, 0.04
  665. How to set up the tab button to advance more than 1 cell in Excel.
  666. Count if in multiple rows / columns
  667. format cell
  668. Limiting text entries
  669. Charts in Excel 2007
  670. Count Highlighted numbers in an area
  671. IF formula..
  672. Can "Header Row' option be removed from Sort dialogue box?
  673. Updating Pivot Table report
  674. column width
  675. Monthly Percent Increase
  676. functions searching by date
  677. abs formula
  678. Look up & auto populate between sheets
  679. Convert time entered to decimal
  680. Pivot table data sorting
  681. How to change cell contents based on date?
  682. Reverse mortgage math?
  683. open downloaded .csv file
  684. VBA to total record count
  685. Data Validation - Cell Colour
  686. Inex and Lookup searches
  687. Stop automatically removing leading zeros?
  688. Not able to edit or do anything in Excel 2007
  689. Printing PDF's
  690. Center Shortcut Key
  691. Pivot Table Chart
  692. Subtracting Time
  693. Can Excel 2002 XML Spreadsheet format be read by Excel 2007?
  694. Time formula Needed
  695. Invalid Range Name
  696. Return Month & Year of Date Value
  697. Subtotals of Items in A Column based on Spec. Values found in Colu
  698. Multiple Lookup Criteria (revisited)
  699. How to combine two worksheets into one. Only ONE column is common.
  700. Use VLOOKUP in a sumproduct calculation
  701. Advanced Filter
  702. Creating PDF's through VBA
  703. Sums with conditions and multiple columns
  704. VALUE err calculating indirect number
  705. how to get "EndDate" of a project?
  706. Row Numbering dependant on amount in a cell
  707. How to calculate with workingdays instead of calendar days
  708. How to Include a specific Cell's Contents in a footer Excel 2003
  709. Replace cell references with names
  710. Show a date based on another date
  711. A follow up Question
  712. Excel Programming
  713. =BOMONTH?
  714. Adding sum of coloured cells
  715. Copy Macro to a new workbook
  716. formatting
  717. find 2nd occurence
  718. number of pages will be printed
  719. Border, font, alingment setup etc. done in one worksheet how to gr
  720. vlookup of sub totals
  721. Plot Data with X, Y values on Chart
  722. Auto save???
  723. Create formula
  724. asign a number to a text string
  725. countif in multi sheet
  726. How to load .xla file automatically?
  727. Remove value from remote cell
  728. How do I search a worksheet for a custom "text" max and min value
  729. Excel 2007 questions
  730. How do I stop getting the "privacy warning" messagein Excel 2007?
  731. How to generate same event (has 2 possible outcomes) 200 times?
  732. Up,Down,Left,Right stopped working
  733. date to character
  734. Statistics
  735. Sorting data
  736. Mixed Text & Numbers
  737. XmlMaps "java_Map40"
  738. Text & Numbers
  739. lost formatting
  740. sumproduct with "OR" conditions
  741. Can't send email from excel through thunderbird
  742. How to use Today's date in a cell and make it stay the same date
  743. How do I scan a picture into a cell in excel?
  744. Refreshing a pivot table
  745. Identifying correct row
  746. ABS Function?
  747. How to insert a row and not update existing formulas?
  748. CHANGE MARCO PROBLEM
  749. Fuction: color change per value
  750. excel 2007 won't open anymore
  751. Copy info into empty cells below info, until finds cell with new d
  752. wrong number, no currency format
  753. Unmoveable Frame in Excel 2007
  754. Big problem
  755. I WANT TO MAKE A SHIFT ROSTER FOR 5 PEOPLE. HOW CAN I DO THAT?
  756. Where (menu) find "fill color" and define/add a new color?
  757. What is a bank stock?
  758. How do I copy formulas
  759. Hyperlinks in Excel
  760. Another sumif question
  761. HELP!
  762. How to use CONFIDENCE?
  763. Lookup Price based on two values
  764. sumif function
  765. break data into columns
  766. Free social world wide network pays for 10 generations! Free!
  767. How to get a blinking text in Excel 2007?
  768. Converting Time from Hours and Minutes Decimals in a formula
  769. vlookup?
  770. Parameter query troubleshooting: Empty cell issue
  771. Replace data into closed workbook
  772. Enabling Macros
  773. formula help
  774. Print all columns - Excel 2007- How?
  775. Randon selection of a value
  776. Help please with column headings
  777. Multiple lines of text within one cell
  778. Drop Down Lists
  779. Naming a group or outline
  780. Function of Ctrl + Shift + Enter
  781. equations on appropriate graph scales
  782. Problem with Excel closing and restarting for no reason
  783. matching school photo to student name
  784. Font color incorrect
  785. Multiple condtional formatting
  786. Autocomplete for Drop-Down?
  787. Number formatting
  788. Trouble connecting to the newsgroups
  789. Excel 2003 v Excel 2007
  790. THE MISSING LINK..
  791. Lookup Table
  792. Using an Excel macro to reset a drop down list
  793. no link for WINDOWS COMMUNITIES
  794. how do i combine data from multiple sheets into one sheet?
  795. Variations on referencing a cell in another workbook - continued
  796. auto locking of excell workbook (excell 2003)
  797. how do I merge two separate workbooks on windows vista?
  798. Count Bold - need to Recalculate?
  799. ComboBox Selection
  800. How do I add my data?
  801. wrap text
  802. Allow user to insert rows on protected worksheet
  803. Apostrophe in Numbers
  804. Vlookup Problem
  805. Can I do Excel formula that variably shifts columns right or left
  806. Cut cells take on color of unknown origin.
  807. Cell shading behavior not understood.
  808. IF cell is blank
  809. SUMIF - VLOOKUP
  810. IF VLOOKUP & CONCATENATE
  811. Overwritten Fil
  812. PAGE BREAK PREVIEW
  813. How to replace the background color of all cells from light green to light blue?
  814. variations on referencing a cell in another workbook
  815. Formula
  816. Combining a whole number and a % in one cell
  817. Advance Filter
  818. Dates in a Scatter Graph
  819. HOW DO I ADD ROWS WITH TWO TEXT VARIABLE
  820. Changing Border Colors
  821. Return the Row number
  822. Issue selecting other worksheets
  823. Check Spreadsheet entries against a list
  824. Extensive V-Lookup
  825. Date Display
  826. Password
  827. Worksheet change macro for paste special
  828. row height
  829. Text and Numeric lookup
  830. Cell View Add-In for Excel 2007
  831. formating
  832. Where is "open/tools/find/find files that match these criteria"?
  833. Validating solver solution
  834. saving in excel
  835. Random Data Generator
  836. Selecting and copying from a list
  837. Sorting Data
  838. I need to hide a formula
  839. Show "+" (plus) sign when comparing two values
  840. How to search in one column, and replace in the other column if fo
  841. counting cells that contain a date
  842. Corrupt file
  843. show the input message of a data validation list on a textbox and set editable
  844. Give a value to the color of a cell
  845. Conditional Sum
  846. Select multiple values
  847. Copy worksheet1 to worksheet2, keep cell format eg cell size
  848. Create/Edit Hyperlink - Unable to designate target frame
  849. How to use Indirect function?
  850. How to display the column name?
  851. Import Access query to Excel 2007
  852. empty cells in the drop down list
  853. How to determine the value?
  854. Text and Numbers
  855. sorting matched columns
  856. cells do not show results of calculations
  857. htm date & time format
  858. link few worksheets in one summary sheet
  859. Related drop down lists
  860. Vertical to Horizontal & Eliminate Duplication
  861. Macro auto inserting rows and formulas
  862. Looking for the word "WIN" in a cell
  863. Q) Referencing the last cell in a formula
  864. merging data sets using dates
  865. Text Field in a cell changes characters
  866. Pivot Table Subtotals
  867. Text to rows
  868. Changing a color in a cell based on the text in another cell
  869. Lists in Excel 2003
  870. Date issue-displaying as 0001-01-01
  871. Cell colours moving with a row
  872. Mail Merge In Word 2007
  873. downloading certain calendar months
  874. Multiple Matches
  875. Excel 2007 - highlighting a column
  876. How do I copy sub total data only onto a new worksheet?
  877. Removing HTML "checkbox" from Excel
  878. Offsetting the vlookup function
  879. how do i keep the color choice box visible in Excel?
  880. How to hide and show a grouped column via VBA code?
  881. function arguments
  882. Putting a title on each page
  883. function
  884. Bringing over text fields into pivot tables
  885. Worksheet Attachemnts
  886. MERGE AND REPLACE MATCHING CELLS
  887. Formating the same cells in multiple worksheet at the same time?
  888. merging/appending Excel documents using DOS ?
  889. Highlighted rows
  890. formula to look at current date and markdown date to give price
  891. Suggested Improvement to Excel Filter Drop-Down
  892. How do I change the default 'user' name in excel 2007
  893. want form to open without seeing worksheet
  894. Using "mailto" hyperlink to email the workbook as an attachment
  895. Hyperlink to hidden cells
  896. copy and paste problem in vb
  897. Adjusting chart info
  898. Ungrouping
  899. AutoSave in 2007
  900. ComboBox drop list when clicked on???????????
  901. Grouping Years in a Pivot table
  902. Excel 2003 keep trying to reintall it self
  903. PIVOT TABLE help
  904. array using contains
  905. VB code checkers?????????
  906. macro to delete rows
  907. Vlookup or Hlookup
  908. Error when sending mail with CDO
  909. Reverse VLOOKUP
  910. ignoring negative numbers
  911. cells blank despite having data in them?
  912. Using the Autofill, with filtered lists
  913. What is "--" used for in forumlae
  914. Why has excel changed cell formatting by itself?
  915. Updating link to external source without having it open
  916. lookup
  917. Validation list after adding a calendar
  918. COUNT OR COUNTIF for this?
  919. Datetime CSV format
  920. How to determine the value?
  921. Data Validation On A Cells With Data From A Different Spreadsheet
  922. sum visible
  923. Request for Learning Macros and their Programming for Begginners
  924. Need macro to consolidate all sheets in workbook
  925. Hide Formula
  926. Set up cells so they automatically finish from others above them
  927. getting address labels into Excel
  928. how do I create a preview image for templates I have created?
  929. Consolidate multiple sheets (latest entry only)
  930. Not Enough Resources
  931. Searching Excel Properties / Data in Windows
  932. How can I organize/transfer existing data into a new spreadsheet?
  933. IF Formula
  934. non-adjacent select display
  935. How do I begin value with the number zero?
  936. Club membership list / database
  937. Deleating All Selected Data Excel 2007
  938. Parsing part of an address
  939. Text rotation in Excel2007
  940. How do I hide cell outlines?
  941. Looping PoewrPoint Show linked to Excel
  942. 2007 file saved as .xls prints wrong on computer w 2003 software
  943. Using Paste Link
  944. =IF(AND(. . . ????
  945. Fill formula down using macro
  946. Excel misbehavior
  947. how can I auto refresh pivot table with sheet protection
  948. Transpose Feature Inop
  949. change mouse pointer in Excel 07
  950. Formula Query - Shazza
  951. how do i change the currency in a loan amortization?
  952. Vlookup
  953. Images move on its own
  954. Delete Repeated Data?
  955. If Statements
  956. Cell Value to look up a file name
  957. Applying Named Ranges to Existing Formulas
  958. Using a #Ref! in a column Sum
  959. opening newer version of excel program
  960. opening newer version of excel
  961. Still won't work
  962. how can i add $ to formulas with a click of a button to ?
  963. save as a .prn file
  964. Countif with mutiple criteria including text
  965. combining formulas
  966. remove named ranges from formulas??
  967. Pivot table - old items
  968. Excel hangs when copying sheet with charts to Powerpoint
  969. update cells in unopened workbooks
  970. date format
  971. Sort on column that uses countif function
  972. Converting
  973. Expanding Capabilities of Wrap Text in a cell
  974. Excel 03 VLOOKUP hyperlink referencing
  975. Excel Error - Too many different cell formats.
  976. Need help with Counting
  977. Why do my words cut off when I print my document?
  978. Need formula help
  979. Scrolling Through a Screadsheet
  980. Why am I unable to scroll with mouse in Excel 2007 worksheet?
  981. Excel Upgrade to 2007 Questions
  982. Linking of worksheets in a workbook
  983. Lookup and count
  984. Dates
  985. Conditional SUM of column values depending on the heading (month)
  986. Auto populate cell
  987. Default Windows Profile without default Office user info
  988. Excel-delete a column
  989. Sorting Info pulled from other worksheets
  990. Option Button code not working
  991. Excel paste ask user credentials
  992. Lookup criteria - digits and letter
  993. Is it possible to use SUMPRODUCT with labels
  994. Top 10 List
  995. dates of month
  996. Filtering by newest date
  997. excel generated xml doctype issues
  998. Excel generated xml doctype issues
  999. Pop up message for option Button
  1000. Extract dates