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. Form Creation in Excel 2007
  2. How can I copy filtered data to subsequent worksheets?
  3. VBA error
  4. Spreadsheet Column Formatting
  5. calendar control in 3 columns
  6. VBA: Make Excel the active application
  7. I have a sign up sheet and the Row line begins with the #3!!??
  8. hyperlinks
  9. how can I filter a worksheet to only show cells with certain terms in them?
  10. How to move charts in Excel 2007 by keyboard
  11. Code to find data validation in a cell
  12. Problem
  13. Excel 2003 Vista fax/print problems
  14. Making my list look better-want blank separator row
  15. Computing Quartiles with Excel 2007
  16. text to rows?
  17. when importing data from external database does not load into wor.
  18. MAX & MAXA returning 0 value
  19. Excel toolbar
  20. Excel 2007 add-in with file path showing
  21. Ctrl+C deletes cell value
  22. Workbook sharing
  23. why does this macro delete the value in A1?
  24. military time
  25. Variable names for named range
  26. macro recorder and formulas
  27. How do you Print "Forms" Buttons?
  28. File is too BIG
  29. Temporarily highlighting related cells
  30. Drop Down List
  31. how do i recognise full dates in a downloaded calendar
  32. how to extract only numbers
  33. update a Pivot Table with new data added to the base data
  34. Copying and using formulas including worksheet names
  35. Linked formatting across worksheets
  36. Auto covery won't work
  37. Exploding Views
  38. How to add ranking in pivot table?
  39. Daily send copy of Excel Spreadsheet Via Email
  40. SAP BI 7.0 BEx Analyzer in MS Office Excel 2007
  41. 98E25 changes to 9.8E+26 -Export
  42. Formulas
  43. Conditional format?
  44. Look Up More than one cell
  45. heavy file
  46. Does microsoft office 2003 work with windows vista?
  47. Another Excel file cannot be opened if linked from Excel
  48. Adds-ins/tools for publishing Excel data as web pages?
  49. Extracting changing row values
  50. Looking up Telephone Numbers
  51. Format Cell with Color
  52. Text Box value to hide a row in another worksheet
  53. Macro's and Graphical Objects
  54. Finding info of one column and removing it from another
  55. Converting UTC timestamp value to date and time
  56. Excel Spreadsheet
  57. matching formula
  58. FUNCTION ?
  59. filter
  60. finding and deleting cells from one excel sheet to another
  61. Excel 2003 -turn off the text speech
  62. FORMULA THAT CALCULATES HH:MM ON THIRD SHIFT(BETWEEN TWO DAYS)
  63. Excel 2002: How to split text into columns ?
  64. source document changes
  65. NOW() function that is un-changing
  66. Please! Hide workbook title bar when WindowState = xlNormal
  67. FUNCTION QUESTION
  68. formatting
  69. Different currencies
  70. Can I pull data from a spreadsheet to another spreadsheet
  71. Recognizing Repeating Data-Groups
  72. formatting
  73. Excel performance vs computer specs
  74. CALCULATE WITH AVERAGE ????
  75. Display kilograms in grams
  76. Date converts to numerical
  77. Office 2003&Vista
  78. "Column" / Bar Chart Fills
  79. Can I merge data in 2 sheets matching rows of data by last name?
  80. Social Security Annual Payroll Tax Formula
  81. Is there a way to get rid of "######"
  82. what is the shortcut for freezing ($) linked cells in excel?
  83. Excel Running Total
  84. convert to upper case - entire column ?
  85. Grouping Items by Arrays
  86. Merge vertically ?
  87. VBA to hide a row in different worksheet
  88. League position change trend chart, how?
  89. how to delete 1 item in colum
  90. Colours
  91. Workbook and Viruses
  92. Autofill Problem
  93. If Function - two conditions?
  94. How can I convert .txt and .xls to .qif ?
  95. If Function Value if true = Date +30days
  96. pull numbers from text string
  97. Hey Krystol
  98. M S V B A Next X Excel 2003
  99. Excel 2007...what is the main programing tool
  100. Help with drop down name to autofill address
  101. How do I calculate output gap using Hodrick-Prescott (HP) filter?
  102. Cricket World Cup Tracker
  103. Introduce Value in a cell with formula, option
  104. Using Excel/programming in Excel to plan meetings
  105. Remove filters
  106. How to add differnt font colors to Formula results
  107. Excel web queries using parameters
  108. Excel forms controls
  109. Vlookup blanks = zeros
  110. Complicated Function Question
  111. Excel 2007 export file size huge
  112. Filter Blanks option unavailable
  113. How may cells are on one excel spreadsheet?
  114. Worksheet display changes
  115. question about vba
  116. sort list range
  117. VBA code to save excel sheet
  118. Entering numbers into a cell
  119. Sorting Multiple Row Fields Separately
  120. using a vlookup command in a for next loop in a macro in excel
  121. Saving e-mail recipient list in Excel 2003
  122. Wrap Text
  123. Sumproduct if rank <=5 if not return 0
  124. VB macros issue with selecting cells on different page
  125. Formula Too Long Issue
  126. Finding similar data in a spreadsheet
  127. Creating a spreadsheet
  128. HELP WITH A SIMPLE FORMULA
  129. I open excel and when I touch a cell with the mouse it gets stuck
  130. saving data type into a form
  131. ON.DOUBLECLICK function
  132. Time calculation - Critical
  133. Week Day formula usage????
  134. Senarios
  135. "More Fill Colors" does not appear
  136. about the dot standing alone
  137. Odd Question: Data to Text
  138. Pivot Table - Is counting all rows
  139. Wow... Anyone ever seen this happen?
  140. formula help: IF a cell has any number in it.....
  141. Find last row
  142. Pivot table not gathering all data
  143. Creating a macro that will split data into different worksheets
  144. Reducing Formula functions
  145. Formula becoming text
  146. SUMProduct working most of the time...
  147. getting data for many files from one file
  148. difference between a private sub and a public function?
  149. Display cell contents in a second worksheet file
  150. validation list with no duplicates
  151. Term Sprocket and Widget
  152. How to proceed with consolidation
  153. More in a histogram
  154. Formula in excel using date criteria
  155. Set sheet to "Not Print Fill Color"
  156. Auto Filter Single Column
  157. Applying Percentages to a Pivot Table
  158. Excel Formula
  159. First Instance
  160. Protected Sheet doesn't update linked information
  161. splash screen
  162. Excel 97 - Comparison
  163. Add a column to a column reference
  164. Count if multiple variable exist
  165. How can I auto fill cells in excel for example 1 of 50, 2 of 50
  166. Link with Data
  167. Pivot Table Dates
  168. How do I make a letter giving thanks to a costumer,I need samples
  169. XL2007 - password protect workbook?
  170. Add page numbers to multiple worksheets without changing page setu
  171. Excel 2007 pivot table data is truncated
  172. Microsoft Query User's Guide
  173. Userform and variable
  174. Writing to csv
  175. Indian Currency add
  176. Data Validation and Input Mask
  177. Deficit Hours
  178. How to clear advanced filter in excel
  179. Summing values in a table
  180. Conditional formatting and counting.
  181. Problems with Variables
  182. Conditional formula
  183. worksheet on network
  184. How can I translate chinese text to english
  185. How can I open a MS Excel file over 12MB in Excel 2003?
  186. Linked Spreadsheets - Preventing Access to Source Sheet
  187. Office 2007 Professional
  188. Which historical year will offer the same weekday ... ?
  189. code line with two conditions
  190. Excel sheet column name change
  191. auto formula when insert new row
  192. Stop comment boxes moving to other areas on XLworksheet
  193. Conditional Formatting
  194. COLOURING CELL BACK GROUNDS
  195. How do I set up a page in excel that will be a list with rows and
  196. SumProduct
  197. Excel 2007
  198. COUNTIF based on Format...
  199. Delete a clipart from Excel which doesn't appear in a cell?
  200. Deleting Rows in Excel 2003
  201. Copy/Paste into a spreadsheet that is posted to a Sharepoint site
  202. Searching for a cell with specified values
  203. How can I get the row and column heading of my active cell highlig
  204. Add leading #'s to a value
  205. Cannot save the attachment.Can't create file:Book1.xls.
  206. Read lines from one worksheet, if value is true, write to new work
  207. Named Ranges
  208. how to make a Histogram Graph
  209. SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec
  210. why does 111111111111 X 111111111111 end in 0?
  211. Cancel Save as a Web Page auto republish
  212. How do I consolidate multiple worksheet files into one workbook
  213. Referenced Cell information
  214. Excel Link
  215. Downloading or copying
  216. Column Counts
  217. Rank if between 1 & 5
  218. How do I unlock arrow keys in excel?
  219. I type 'HTE', Excel changes it to 'THE' or 'HET'. Why?
  220. Transform csv to qif or ofx format?
  221. Peculiar date format behavior when replacing parts of date
  222. Formula Help
  223. File open in MS Office 2000
  224. Import Delimited File
  225. Excel Macros
  226. Opening CSV file in column A?
  227. Successive numbers
  228. How to TURN OFF "wrap text" for all new workbooks/sheets
  229. How do I do the same for this formula?
  230. HOW TO CHANGE THE ICON OF AN EXCEL WORKSHEET FILE?
  231. How can I do a count subtotal AND a sum subtotal on the same row?
  232. Constants In Formulae
  233. How do I replace A, B, C, Column names, with my own names?
  234. Excel AutoCorrect Formatting
  235. Removing List from Cells
  236. Format from 870914143 to 8-709-14143
  237. Macro to delete unwanted sheets
  238. Help - every cell starts with ' r ^ in the formula line!
  239. Sum multiple columns with Sumproduct
  240. Why does Excel 2007 always give pop-up "File in Use"?
  241. Template Wizard replacement in 2003
  242. how do i remove a portion of data from a column
  243. catalog external links and list all pivot table sources
  244. modify buttons on QAT
  245. office clipboard
  246. Password protect folder
  247. Macro Script
  248. HELP ME!
  249. Link to Network Drive
  250. ADDING CELLS
  251. Is it possible to format Excel 2000 worksheet tab color?
  252. Printing Hidden Cells
  253. How did I do this?
  254. how do i count everytime a spreadsheet is opened
  255. Helps: Type Mismatch Error
  256. using exact formula to compare cells
  257. how to delete "non-commercial use" from title bar
  258. Printing Problems in Excel due to a Macro in Word?!
  259. Excel Macro help
  260. Don't Want to Print Formated Blanked Out Cells
  261. What does it mean to record the macro
  262. Data validation don't work
  263. Outer Joins
  264. Excel colors have changed
  265. Each client to be identified into segment
  266. Excel Macros Help
  267. How can i copy data from a tabbed working sheet to a summary sheet
  268. Cell Formatting
  269. Moving to cell based on condition of another cell
  270. HeLp me
  271. reformat excel to letters in columns
  272. Basic sort question - maintain relationship across columns
  273. format cells in 30 different sheets
  274. HELP Sumif or Sumproduct
  275. Summing columns
  276. map network drive
  277. remove a name
  278. can i put a password on a folder rather than on each excel workboo
  279. How do I prevent excel from opening with a blank worksheet?
  280. loading
  281. Excel row header starting with row 4129
  282. cell color
  283. Conditional formatting from other worksheet
  284. Creating a separate cell entry for every individual line in a cell
  285. Number add-in warning comes up when opening files
  286. Percentages
  287. date system
  288. Re: Userform password to show "xxxxxx" in the text box
  289. How do I type in colour without having to change it every cell
  290. if text string
  291. Trouble with DGET & VLOOKUP formulas
  292. Formatting cells
  293. EXCEL CELL CONVERSION PROBLEM 2
  294. ... I need some help with a formula ...
  295. Sumproduct with conditions
  296. Excel cell conversion problem
  297. Fomula only half working
  298. Retrieve Data from Word Art data
  299. Autofilter only sorts the columns inlcluded (version 2007)
  300. data
  301. Hiding worksheets
  302. VLOOKUP
  303. WORD ART IN EXCEL
  304. Problems with HLOOKUP and VLOOKUP
  305. Using formulas to select cells (Ex: Select every nth cell in a col
  306. hyperlink some 10 sheets in a workbook
  307. Substitute
  308. Links Not saving?
  309. Select an item from dropdown list but return value from adjacent c
  310. multiple columns with like data
  311. Lock formulas in a cell
  312. Create Cell Comment based on text in a cell on another worksheet
  313. How do I stop the TAB from moving over multiple columns
  314. Format an entire row when an ID changes
  315. Excel 2003 BOM Cost roll-up Function
  316. Iteration inconsistancy
  317. can't quit excel
  318. excel 2000 and or 2007
  319. How to hide workbook "title bar"
  320. Can's work this out, probably easy for an expert!
  321. Excel Spreadsheet
  322. Autosum
  323. formatting cells with numbers as text
  324. Cursor moving across the spreadsheet and wiping out lines
  325. Macro Security--Does it restore the VBA project?
  326. Conflict with valid range reference error
  327. IF OR
  328. how do i add more to a formula without going into each cell?
  329. macro for same value in 2 different sheets
  330. Generate random numbers
  331. Decimal Places
  332. Histograms
  333. Long list, 2 criteria, find unique, paste
  334. Converting date formats
  335. flashing cell
  336. Palm OS & Blackberry
  337. Wierd VBA happenings...
  338. Mail Merge - file has duplicate data
  339. Change Default Font in Excel for Document Only?
  340. Data ascending and decending
  341. formula referencing a column -> autofilling in a row ???
  342. Monthly Budget Breakdown
  343. COUNT IF
  344. Identify Windows Profile
  345. Multiple drop down list box
  346. Excel Rows
  347. excel macro page break
  348. Saving Conditional Formatting in Excel 2007
  349. Cut and Paste Macro to new file
  350. How do I rename columns from letters to numbers
  351. PivotTable and summing/not summing
  352. Help Pivot Table Date Range
  353. How do I copy the contents of a cell into a footer
  354. Pivot Table Summary
  355. Automatic Population
  356. numbers
  357. how can i restore a file that was deleted 4 days ago?
  358. how can i restore a file that was deleted 4 days ago?
  359. When referencing other Sheets
  360. sum by conditional formatted color
  361. Function does not work unless I double click the cell and push ent
  362. Counting Names in a Column, Ignoring Duplicates
  363. Excel will not print in color
  364. Pasting #-# as text and not a date
  365. count if or sumproduct?
  366. Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null
  367. Colored numbers
  368. Creating Excel Worksheets from Access Database
  369. Form > CheckBox > font size / style
  370. Date plus 1 month
  371. opening excell
  372. data into cells
  373. display defined names in excel
  374. Returning contents of a cell in another sheet in same workbook
  375. VBA Gone!
  376. Why todays date shows up as #### in excel doc.
  377. format for comments
  378. entering data into cells
  379. Lookup/extraction help
  380. #value
  381. Formulas
  382. Characters contained in a cell
  383. need to hyperlink to 100 files in the excel sheet
  384. Simple MS Query with Data Parameters Not Auto-refreshing
  385. Lookup Multiple Worksheets/Workbooks
  386. Please help me on Color code
  387. turning off autofill tips
  388. Excel 2002: Can I default font color for every new file created ?
  389. Excel, Macro, Drop down list
  390. How do I get a file back that I have saved over. beside backup
  391. Will add, won't sum?
  392. Excel 2002, MS Query and MSSQL View with periods
  393. Custom grouping in Pivot Tables
  394. PLS HELP! Excel imbedded object in Word
  395. Auto Chg Tab Color vs Current Month
  396. Can not get function result
  397. Macro works for some users and not others
  398. Fill a column with a formula
  399. .XLS FILE
  400. Eliminate area ranges on a spreadsheet
  401. Re: Saving hyperlinks that connect multiple servers
  402. Microsoft Word Object Library in Excel
  403. Macro and custom Button
  404. Show Comments on Protected Sheet
  405. How can I insert the author name held in File/Properties in a cell
  406. Pivot table
  407. Vlookup
  408. Convert to number problem
  409. How to change the default text color in Excel 2000?
  410. Sort dates by month
  411. filtering Hyperlinks in Excel
  412. taking percentages
  413. Dependent (linked) combo boxes
  414. Can you call a Web Service from Excel 2007 without writing code?
  415. Using VBA enter cell contents into headers
  416. Excel 2007 fill a series using keyboard commands
  417. spellcheck automatically?
  418. Macro for Moving rows
  419. Labeled Coordinate Plots
  420. Converting multiple numbers saved as text in excel
  421. Excel Decimal Point
  422. Spelling comparison
  423. Excel Runs Slow
  424. Macro to insert a object in excel
  425. Control Toolbox Textbox and Linked Cells
  426. Prevent saving and allow only through Macro
  427. See/work with multiple sheets at the same time
  428. formatting comments
  429. Problems with using symbols in excel
  430. download to save excel file from IE7
  431. Sumproduct with wildcard characters?
  432. Copy rows of data (eliminating blank rows) from fixed layout
  433. Top 5 records by month
  434. extracting data
  435. Renaming Data...
  436. Excel 2007 pasting creates too many cells
  437. pivot table conditional formatting
  438. pivot table - trying to find A OR B instead of A AND B
  439. Last Saved by Field not populating with Windows XP Service Pack 2
  440. help needed
  441. Tabbing through merged cells
  442. Sum specific cells only not entire column
  443. TROUBLE WITH A SIMPLE FORMULA
  444. REMOVE ZERO FILL
  445. Real Estate Development Proforma Templates?
  446. Need formula - Any ideas****
  447. VLOOKUP or another???
  448. pivot table formulas - running total
  449. Need help - Complicated formula using multiple worksheets
  450. Exclude Individual Cells While Printing
  451. Re: How to make a table with only one cell to be selected?
  452. Populate text box for graphs
  453. Cell Cursor color
  454. Can I export dates from Excel into a calendar, perhaps in Publishe
  455. Leaving a cell blank when there is an error message - HELP
  456. NEED HELP! Commission calculation
  457. Date Formatting
  458. Re: Baisic formula
  459. How do I keep colums hidden when pasting
  460. Changing Formula
  461. Maximum amount allowed
  462. IF THEN statement - Formula
  463. Excel 2007
  464. Changing text to date format
  465. Organization of Macros and Memory Usage
  466. Look Up
  467. Excel 2007 Wrap lost when pasting into cell
  468. Help: Need Excel formula to return correct price from price history table
  469. formatting tool bar that pops up when right clicking a cell
  470. Using Multiple Choices to Select a Value in a Cell
  471. Re: How to make a table with only one cell to be selected?
  472. Conditional Formatting Help
  473. Protect sheet but hide rows?
  474. If then statements
  475. Email/Mail Merge document lines to specific multiple recipients
  476. Print Views
  477. Transfer .xls file to Ipaq
  478. Compare several columns of data and display unique ones
  479. checking for a value in a list
  480. AutoComplete only includes recently typed entries?
  481. how do i select a column when using "exact" formula?
  482. Split month in half
  483. fixed length file
  484. CLosing Excel 2007 with personal macro workbook
  485. Negative Numbers
  486. How to add a percentage column in a Pivot Table
  487. What does the @ symbol do?
  488. Compare different columns and put unique data in the next available column
  489. cell displays ##### in cell with more than 255 characters
  490. Entering Variable in a Pivot Table
  491. Why am I blocked from copying a file to CD?
  492. Excel crashes on opening exported file; formatting weird afterwards
  493. Custom format
  494. Adding a macro to a toolbar
  495. Show data in columns
  496. how do I get an apostrophe deleted from in front of all entries
  497. How do I format cell as longitude/latitude (ex: 45-30-10.65)?
  498. Comments or something similar
  499. Why?
  500. I need to use more than 7 formulas inside each other
  501. domains
  502. Third left part of the screen is frozen
  503. Excel 2002: Can Vlookup formula search for data with two reference
  504. Subtotal
  505. Need Notes on Excel Macros.
  506. Why won't th unhide function work??
  507. Automatic Hide group of a columns based on cel value
  508. Excel Filters
  509. Increasing the number calculated by for same column
  510. Split by half month
  511. Example:
  512. Farmula wrong result
  513. Hide multiple worksheets
  514. Save Excel file with certain columns with fixed width
  515. Car cost of ownership Excel template
  516. "." on numeric keypad displays ","
  517. .exe files run on excel
  518. Calculation
  519. How to compute coupon amount for bond?
  520. Auto delete cell content
  521. Split by half month
  522. invoice toolbar for invoice calcuation and assign number
  523. How to compute coupon amount for bond?
  524. Solver Update Issue
  525. Column conditions
  526. Formula in excel to change - to +
  527. Skip columns and copy formulas
  528. The document is corrupt
  529. Insert Time Stamp when macro is run
  530. Countifs equiv in 2003
  531. Skip column cells and copy formulas
  532. Microsoft Excel 1997. How do I sort a protected worksheet?
  533. How do I add subscript/superscript font to the Excel toolbar??
  534. Combo box questions
  535. outlook shut off, Is all info lost forever
  536. validate alternate day date
  537. Test
  538. Macro to create a custom header/footer...
  539. Count of Dates
  540. How do I replace negative values by a character
  541. summing issue
  542. drop down cells
  543. changing color of font to words in a list
  544. Excel 2007
  545. Please Help
  546. Is there a way of pausing a macro
  547. Calculating totals from COUNTA function
  548. Naming convention for workbook names
  549. excel and acrobat
  550. UK versus United States English
  551. how do i change headers on all workbook sheets globally?
  552. Excel Question
  553. How to Set Range to 50 Random nonsequencial rows?
  554. Formula Question
  555. Userform sizing problems
  556. custom format - month as uppercase
  557. Sub-Totals not consistent
  558. Not-printing cells/formulas
  559. Lookup function problems with True/False
  560. Excel to xml- ###### signs
  561. Pivot Table Date Range
  562. Record a macro to use in any workbook--give it to others.
  563. Pivot Table Sum vs Count
  564. Math Formula
  565. Hide row(s) based on drop down selection
  566. Macro to gather comments
  567. Need help with a formula pulling data from mutilple sheets
  568. Plotting two data points as one
  569. Count from ATTENDANCE to ANNUAL
  570. Changing several cells text color
  571. VB Controls with Macros embedded in Excel Document
  572. Prorated vacation formula required
  573. Importing data into Excel 2003 from a Web site
  574. If/then and Vlookup formula
  575. If statements in Vlookup - can it be done?
  576. Lotus .wks file support Excel 2007
  577. Forming a binary column from a more complicated column of diagnostic codes
  578. Sum data range containing NA()
  579. NCAA 2007 NCAA Bracket and Tracker
  580. macro
  581. VBA Editor opens automatically after unlocking machine
  582. Undo List
  583. How to clear validation lists based on other validation lists
  584. Pivot table and formula help??STUDENT NEED HELP....
  585. using a formula inside a sting of text
  586. How do I change "Windows User" in Comments box to my own name?
  587. cannot activate smart tags - tried all the obvious
  588. validate a date range
  589. Dixon Test
  590. excel horizontol scroll bar
  591. Comparing Data
  592. March Madness and Conditional Formatting (Excel2007)
  593. person name smart tag
  594. Increase whole column by same percentage
  595. Laon amortization table
  596. sumif + indirect
  597. Hide blank cells in either of 2 columns
  598. How do I choose shrink to fit when it is greyed outl?
  599. Embedded Excel Object Stops Working
  600. if(and(isnumber(match(... vs if(and(match(...
  601. Copying Data
  602. Sheet number change
  603. how to increase the max number of rows in Excel spreadshee above 6
  604. Pivot Table Help
  605. Excel chart
  606. Excel Options not displaying - some tabs only
  607. Theme Colors are horrible!
  608. Excel 2007 Color Palette
  609. Personal.xls not opening at startup
  610. Using Closed Workbook as Data Book
  611. Time Question
  612. Pivot Table - only show dates greater than =today()
  613. if function
  614. How to Shuffle the data at ROW level.
  615. Last Modified date on cell or column
  616. SUMPRODUCT Not Working
  617. Spreadsheet size...
  618. use cell value in a fomaula
  619. Pictures pasted as bitmap don't appear in Excel 2002
  620. How do I change numeric column designations to alpha?
  621. Date and time
  622. Create a Pivottable in a macro
  623. Delete all zero values
  624. key board short cut keys list
  625. How do i get a line of best fit on my graph in excel
  626. Updating the contents of a cell
  627. Need a macro to include file names in a folder to excel sheet
  628. Microsoft Excel
  629. Copy a folder in VB
  630. to mail a list of mail ids with same matter
  631. When I wrap text, excel hides the text display
  632. Copy a folder by macro
  633. VLOOKUP not working due different formats in lookup data & table?
  634. edit the url for a web query
  635. Dynamic formating a pivot
  636. change scaling % but font size didnt change porportionally, pls he
  637. data validation lists
  638. quandary 11 - 3 -07
  639. How do I make a form/chart for farm expenses for income tax?
  640. euro symbol
  641. Want to calculate 3 business days from a certain existing date
  642. How do I create a tracking log
  643. Have afirst name and last name and want to seperate them.
  644. How to reverse the order of bars in Bar Clustered chart?
  645. Change another cell's contents from current cell???
  646. convert date to day of week in excel 2003
  647. How to get rid of print preview restriction?!
  648. Charts
  649. request for time interval worksheet function
  650. 30 decimal digits
  651. unzip/zip xlsx files
  652. Find feature - Fill cells with color
  653. Excel 2007 Starts in Ready Mode
  654. Special Lookup Formula
  655. how to colour a cell green if another cell is filled with text
  656. Insert row not coping all forumlas
  657. Save Workbook but without Formulas (just values)
  658. I need help setting up date and time in various cells
  659. Where can I purchase MS Small Business Accounting UK Version?
  660. Time calculations - help please
  661. Time > 24:00:00 in macro
  662. planilha
  663. ARROWS ON KEYBOARD
  664. Number of columns available in a worksheet
  665. linking individual macros on the same sheet
  666. Custom formatting
  667. HELP .. Need Time Formula
  668. Have a question on a homework thing I have using excell
  669. Excel formats on the Web
  670. how do I return tthe location (cell) when using the max function
  671. gallery tab there is not enough memory to complete this operation
  672. Timesheets
  673. Reading Material: Excel VBA
  674. Hyperlink Help
  675. How can I display status bar value in Excel 2007
  676. How to change all numbers to x's?
  677. How can I control the full screen display width ?
  678. vista & XP editing web files
  679. Move Macro Button on Sheet to a toolbar
  680. 2007 EC Excel - Access User Conference
  681. Mkae Mode function return "" instead of #N/A when there is no Mode
  682. Mkae Mode function return "" instead of #N/A when there is no Mode
  683. CountIF..
  684. Extracting date
  685. Import Excel data into new Excel spreadsheet
  686. Display rows meeting criteria on another sheet & summarize them
  687. Exporting Lotus 123 into Excel Work Book?
  688. DROPDOWN/DROPUP?
  689. Counting cells with a particular type formatting
  690. Summary SUM
  691. time calculation
  692. Restore Lost Color Pallet from Tool Bar
  693. Pivot table row field order
  694. update Totals using current date
  695. How do I allow insert picture in sheet when it is protected
  696. ALLOCATION OF ORDERS - Pivot table
  697. imported images in Excel 2007
  698. Why is Excel 07 only showing gridlines on part of the sheet?
  699. Custom format
  700. copy excel
  701. carry down total
  702. how do I sort a column mixed with odd and even numbers .. ?
  703. Create a toolbar menu with Hyperlinks that access pages within the
  704. I get "Access Denied" trying to open network files.
  705. Excel Collaboration
  706. Filtering Data
  707. How to recover excel link in XP program list
  708. changing maximum characters allowed in excel cells
  709. My Excel spreadsheet will not allow me to use my Drawing Tools
  710. Transferring data to excel spreadsheet 2003
  711. Excel formula to change page # when data entered in other page
  712. Bill Tracking Templet
  713. Reference Sheetname in Formula
  714. Lock Row after Data Entry
  715. Array Formula returns error but only for specific columns
  716. Locking/Unlocking cells upon condition
  717. Comparing Data
  718. lost query definition
  719. Microsoft Word bookmark content into an Excel cell using VBA
  720. RowLiner
  721. Capitalizing text from the left limited by a comma
  722. charts and cells black out when selected
  723. Calculating days between two dates
  724. =SUMPRODUCT(--($D$5:$D$57=$D121),--(G$5:G$57))
  725. list from another workbook
  726. open excel in a separate instance
  727. Possible to set "match destination format" as default in paste?
  728. If value delete row
  729. time sheets giving a minus
  730. Excel files suddenly "read only" or encrypted and cannot be opened
  731. Drop-down lists
  732. Computer Help
  733. No multiple worksheets when opening with Excel 2007.
  734. countif-multiple conditions
  735. Macros - error run
  736. If function
  737. CountIf formula question
  738. Default cell position on file open
  739. Changing location of comment when hovering over cell
  740. How do you add to auto fill in excell?
  741. Microsoft Query & Pivot table?
  742. Replace Function Removes Text Formats In Cell
  743. Cleaning forms
  744. XL 2007 Display Question
  745. duplication of information in cells
  746. Input Box Question
  747. Row Height
  748. sumproduct sumif and what else needed?
  749. Conditional Fornmatting Text and numbers
  750. Excel,TextBox,ColrFill,3D
  751. Conditional Formatting for Shared Workspaces
  752. print with comment in worksheet
  753. Eliminating the page number from first page of document
  754. Index and match?
  755. Is there a formula...........
  756. Click one of the cells
  757. Protecting parts of a workbook
  758. Invalid Name Range
  759. macro starting when color is changed?
  760. Subtotals with extra detail???
  761. Wider bar charts
  762. Show pages without using pivot table
  763. Sort Routine
  764. sumif with text?
  765. Difference in date and time
  766. changes in cell not crossing to another worksheet, why?
  767. Minimum function
  768. Edit/Find feature in Access 2003
  769. Key Generation
  770. Copying a graph with IPA symbolos to Word
  771. exporting from quickbooks
  772. Capturing Rows of Data
  773. 5 or more Conditonal formats
  774. Approval Process for a Spreadsheet?
  775. Wildcards with Conditional Formatting?
  776. Happy Daylight Savings
  777. Protecting worksheets
  778. Removeing the Grand Total Line when subtotals are removed
  779. Sheet references
  780. hyperlinking to hidden work sheets
  781. Copying data across lines
  782. How do I resize a watermargin?
  783. How can i remove spaces?
  784. Ho to remove spaces before values?
  785. Excel & Security
  786. Refresh XML
  787. Run-Time error '1004' : Select method of Range class failed
  788. CountIf and Search
  789. Use two different value to run a querry
  790. Chart goes to zero
  791. coefficients of polynomial
  792. Prevent sheet deletion
  793. Conditonal formatting
  794. Lost all my work in Excel 2007
  795. Extracting number from Text and ()
  796. error messages fixed object will move
  797. Sorting Merged Cells
  798. Parameterise OLE DB query
  799. Sorting trouble
  800. Change cell color if date exceeds formula
  801. Copy Files with Links
  802. Breaking a string of text
  803. Set measurement units has changed?
  804. Complex sum
  805. Can you Force a Response for Questionnaire
  806. Printing to PDF with specified filename
  807. VLOOKUP FUNCTION AND NA
  808. Form Checkboxes are not maintaining cell link
  809. Complex sum
  810. Complex sum
  811. Counting
  812. Can I format numbers using engineering notation in excel?
  813. vlookup, match, index: all some or one?
  814. Integrating pictures in an excel document
  815. printing selected pages in one worksheet while working in another
  816. hiding
  817. Cannot COPY then PASTE
  818. Macro error
  819. vlookup comments
  820. Copy from Word to Excel, and retain indent, plus word wrap
  821. Can you make an Excel Worksheet unprintable
  822. Unable To
  823. how can I globally change minus numbers to positive ones?
  824. Do you want to save the changes you made to 'ABC.xls'?
  825. Help about If
  826. Data menu and how it works
  827. "Not a valid win32 application"
  828. Dragging Formulas
  829. Inserting a column
  830. MsgBox with timeout
  831. Automatic links message when opening a workbook
  832. error message fixed objects may move
  833. How do I put in a page break after every selected row.
  834. Excel mailing list in wrong format for mail merge
  835. How do I save 2 linked spreadsheets and update links in formulae
  836. RE: How do I save 2 linked spreadsheets and update links in formulae
  837. formula?
  838. need to change system administrator settings
  839. lost work without saving it. can I get it back?
  840. Change Cell to Red
  841. lost work that wasn't saved. Can I retrieve it? How?
  842. Excel Hangs when working with a large list
  843. inserting new column
  844. Date format in Excel 07
  845. Creating a Report in Excel
  846. How to gt Top N records/Top N Groups
  847. Breaking a string of letters
  848. Big Cell Contents - I don't want them to display
  849. Keeping Formulas the same when inserting columns
  850. sum of my formula is 0
  851. XL 2007 w/XP
  852. Copy same cell formula in many rows...
  853. Cannot open excel attachments
  854. Histogram
  855. how do i remove a cell name in Excel 2007?
  856. Auto Hide-Unhide Columns with a macro
  857. gathering information from many worksheets
  858. Sorting Combined Data
  859. Excel installs components
  860. Combining two spread sheets
  861. Formatting shapes with excel 2007
  862. Formatting cells
  863. RE: How to gt Top N records/Top N Groups
  864. locking formulas
  865. Can you use icons OTHER than the one availabel to modify the QAT
  866. RE: locking formulas
  867. RE: Breaking a string of letters
  868. Needing help sort sermons in order of books of the Bible-not alpha
  869. RE: Copy same cell formula in many rows...
  870. RE: Formatting cells
  871. Sumif/lookup ? Array
  872. Importing Data problem
  873. Cacatenation and SUMPRODUCT
  874. Automatic cell referencing
  875. fill handle
  876. Automatic Cell Referencing
  877. RE: locking formulas
  878. How to get pivot table to list duplicate entries in column fields?
  879. Searching/Counting an array
  880. Worksheet Prints in Duplicate
  881. RE: Combining two spread sheets
  882. Highlighting
  883. Change Date format
  884. RE: Auto Hide-Unhide Columns with a macro
  885. RE: Copy same cell formula in many rows...
  886. Excel data upload to Oracle
  887. RE: Needing help sort sermons in order of books of the Bible-not alpha
  888. Defining cell name / giving multiple cells a name
  889. column width
  890. Auto filter columns while keeping groups of verticle cells togethe
  891. RE: Highlighting
  892. RE: sum of my formula is 0
  893. Ranking Subgroups that are above 750
  894. How to embed a text file into excel spreadsheet?
  895. RE: Needing help sort sermons in order of books of the Bible-not a
  896. RE: Excel data upload to Oracle
  897. Why does text in a cell appear as a line of '#' symbols?
  898. Making a form visible
  899. Can a macro be run on opening the file?
  900. Can a macro be run on opening the file?
  901. Lookup by row and column
  902. Customize Toolbar
  903. linking one worksheet to another
  904. Date and time stamp, control button
  905. Cannot Right Click a Cell
  906. Page numbers - not starting from the first page
  907. Can I paste in only absolute value of a measure (no units)?
  908. Cell Fill colours
  909. Changing Excell Sheet Tabs to Different Colors
  910. Formula for columns
  911. Pivot table report filter problem
  912. scientific notation in pivot table
  913. Time Stamping Cells
  914. How to choose if I use a parameter or not in a parameter query
  915. Can't copy and move a worksheet
  916. When Excel incorrectly Calculates
  917. multiple screens for excel
  918. Interactivity
  919. Lock row in place
  920. If in a formula .. or a better way?
  921. display months (in date format) in capital letters
  922. macros available in ALL spreadsheets
  923. How do you exclude outlayers in Excel?
  924. Interpolate data
  925. Security Issue: Data Connections Disabled
  926. how to enter 01 in a cell
  927. user forms and pivot tables question
  928. macro and deleting or hiding columns
  929. Subtotal in "Data" menu
  930. Group Time
  931. short definition on inserting drop caps in word
  932. Rank question
  933. Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting
  934. How do I make macros run smoothly? (without the flickering)
  935. CONDITIONAL FORMATING!!!!!
  936. Excel的函數*,有無*國農曆 的運算
  937. Forms Toolbar - Scroll bar control
  938. how do I format a cell to display its contents in Upper case?
  939. Column mailing list needs to be converted to rows
  940. Suddenly unable to open Excel
  941. Unable to open excel spreadsheet
  942. Replace Funtion: To replace "?"
  943. Extremely slow subtotals in Excel 2003
  944. Subtotals in Excel 2003
  945. Last in a series
  946. can you wrap formula results via a formula eg. Alt Enter
  947. check for repeated data
  948. RECREATING THE PROBLEM !!!!!!!
  949. numbers are changes when input
  950. Changing colors of a formula total.
  951. XL2007 Copy As Picture
  952. Subtotals in Excel 2003
  953. Subtotals in Excel 2003
  954. Combining Data: 2 Different Cells, Doing the Whole Column @ Same T
  955. Formula to Enter Dates
  956. Text does not display in "Text boxs" and when wrapping text in a c
  957. Formatting of values
  958. autosave save all open worksheets
  959. Text Being Seen as Partial Cell Address
  960. Which Formula to use
  961. Instead of NOW()
  962. Remove hyphens from SSN
  963. Recalculation
  964. need help with formula
  965. importing and updating list based on criteria
  966. Excel Chart Data Table Format
  967. Need to average division of two columns based on criteria
  968. Internet on startup
  969. {=COUNT(--ISNUMBER(G95:G98))}
  970. Hide/Unhide columns using button on top over relevant columns
  971. Sub totals and Totals
  972. Array Formula Minimum Excluding Text
  973. Compounded Rate
  974. Combo box corrupting VLookup function
  975. Moving a pie chart in excel blacking everything out
  976. How do I display white space characters in excel?
  977. Code using A sheet to find a number
  978. helps with count under multiple condition
  979. Data Validation
  980. Insert the "Tab Name" into cell contents
  981. Pivot Table - Grouping Dates Error
  982. Format Date in Pivot Table
  983. 2007 Calendar with hours
  984. formular to value 1900 prices today
  985. Whole Number and Decimals
  986. HOW TO? Per choice in a list, certain cells become blacked out.
  987. EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL
  988. Cell references auto update when sorting
  989. Comparing similar data on different sheet tabs
  990. Automated graph problem
  991. opening excel docs in a new window
  992. Count Auto-filter results
  993. how can I know formula of protected sheet
  994. shortcut
  995. count number of text in a column
  996. Excel 2003 can you change the header date format?
  997. Code to change column height of arrays?
  998. my own dedicated mvp
  999. Control key Issue Excel 03
  1000. Saving Custom Table Formats in Excel 2007