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. Using Excel with automation
  2. how do i find horizontal, vertical and cascade options
  3. Error while using SUMPRODUCT function
  4. Formula to assist with counting dates
  5. Formula to help with Date funtion
  6. Updating of External Sources
  7. user access
  8. Calendar again
  9. Problem with Sumproduct...
  10. Change cell fill color options
  11. RE: 3rd and last Revised WorkBook
  12. Excel Character Path Limit for Asian Characters
  13. MACRO TO LOAD AN ADDIN
  14. adding diff value
  15. EMBED VLOOKUP AND SIMPLE IF FORMULA IN A WORKBOOK
  16. Excel Formula
  17. Re: URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AN
  18. Using Text string in Sum formula
  19. Trying to calculate results in one cell, based on data of another
  20. removing a single space in a cell
  21. Add-Ins - Go To Product - Part Duo
  22. Add-Ins Ribbon - Go To Product
  23. Why has Office Download KB967642 defaulted cells to Accounting
  24. #DIV/0! error
  25. Textbox validation
  26. "advanced level" in excel?
  27. error 1311, cannot find SKU111.CAB
  28. How to return an array of values that are not zero/Null
  29. How to return an array of values that are not zero/Null
  30. How to create an automatic generated number for a spreadsheet
  31. Excel 2007: Conditional formating of multiband colors
  32. Search group of cells for several sets of character strings
  33. Use array for lookup value, to return array of lookups
  34. Conditional format of range
  35. weird things showing up on menu bar
  36. Cross reference
  37. How do I get old rows to auto delete when new are added?
  38. Excel data will not appear, but print preview works
  39. Pivot table setup
  40. file format or file extension is not valid...error message
  41. Subtotal and IF Formula
  42. Worksheet Protection & Sorting
  43. Adding values from 1 workbook based on criteria & putting in anoth
  44. Populate year, month and quarter from entered date
  45. Numbering a Table that does not match page number
  46. conditional labelling
  47. Fonts and Cells
  48. Saving Spreadsheets in a Standard Format / Name
  49. Protect Worksheet Code Areas
  50. How do I stop my formulas from updating?
  51. how to convert an xlsx file to an csv file.
  52. how can I randomize a set of 496 numbers?
  53. Lookup and Copy a Range
  54. Margins
  55. Keep Losing My Cell Format
  56. Loop Until LDate > Column Date
  57. Working with Dates
  58. Excel 2007 SP2 Addition of Negative Numbers Error
  59. Printing
  60. Excel 2007 - Validation
  61. Excel 2002: Conditional format multiband colors
  62. Help with a Formula
  63. Column and row advance
  64. Adding values from different workbook
  65. Rename imported MS Access field names
  66. Temp variables within formulas?
  67. Sum spending and group for each month/category
  68. Edit/Fill/Series on Protected Sheet
  69. Index(Match) question
  70. Formula Adjustment
  71. Transposing Sums & autofill
  72. 2007 to 2003 chart conversions just nor cutting it
  73. if less than greater than
  74. when do use the & symbol in a text formula, how does it work
  75. Sharing a workbook
  76. Copy/Paste Row Height
  77. File Bloat
  78. How do I hyperlink to a name from excel same name in access?
  79. auto numbering of data with columns in between?
  80. range name does not appear name box?
  81. to spread figures with equal interval but different starting column
  82. If / Or Values
  83. Variable name question
  84. IF statements
  85. Can Two Sheets Be viewed at Sametime in One EXCEL File?
  86. VBA for SELECTING ONLY BOLD CELL
  87. cell
  88. Range of values
  89. Dates in a pivot table
  90. Locking Cells in an Automated SpreadSheet
  91. Pivot tables - Questions on formatting, sorting
  92. Check multiple cells for a match
  93. How can I speed up excel 2007
  94. Finding all elements in a database
  95. Sum Exported data automatically from Access database
  96. dates
  97. Replace worksheet without affecting the referencing formula
  98. anyone have a basic sales tracker
  99. How can I remove extra space when using autofit in Excel 2003?
  100. =ABS
  101. Excel 2007 - Validation
  102. Merge Data into Excel
  103. How can I type 2 rows in one cell in Excel 2003?
  104. Publish Pivot to web - Column Area issue
  105. Comparing common values in either different worksheets or columns
  106. Excel 2007 Animated Text
  107. Large excel file problem when moved from 2003 to 2007
  108. Value if an if statement is false
  109. How do you convert a full excel file into a pdf?
  110. filters
  111. 2007, compatibility, formatting and help, help
  112. Count Number of Days after a Start Date
  113. repeating text
  114. How do I change the chart sizing measurement from cms to inches?
  115. How do I choose the last nonblank cell in a ROW?
  116. Unhide function not working
  117. Return 0.00 if Neg.
  118. If Formula (visible cells only)
  119. Unhide function not working
  120. Remove a line
  121. Double Entries in Excel
  122. vlookup
  123. new values
  124. absolute cells when linking to an external file
  125. Curser will not stop selecting cells
  126. Increasing columns
  127. Double Entries in Excel
  128. not printing grouped columns
  129. Excel 2003 Feature?
  130. Excel 2007: How do I replace the default color table?
  131. Re: Double Entries in Excel
  132. OLAP Pivot Table 2003-2007 Conflict
  133. Lookup? Index? or something else?
  134. Need help on Automating a common function
  135. Date formatting
  136. Excel horizontal scroll bar not working
  137. IF STATEMENT including BLANK RESULT
  138. From a Data Range > DoubleClick on a cell to populate elsewhere
  139. Formulas with no results
  140. Code to long - needs help on "if" statements
  141. How to delete multiple files?
  142. How to delete multiple files?
  143. Cell Formats
  144. Conditional formatting and userform
  145. Subtotalling in Excel 2007
  146. change the color of yellow tip box on data validation
  147. Prevent value being deleted
  148. Max Formula
  149. "Find" function question - No code required
  150. Data subtotals with Text
  151. Query automatically being removed
  152. Able to select multiple values in a drop-down list in Excel 2007?
  153. Date Time formatting problem
  154. Auto/conditional format
  155. VLOOKUP 00-Jan-00
  156. How to enable to click a checkbox?
  157. Excel 2007: Suggestion for Multi-level Sub Total Table
  158. If formula problems
  159. How to change the font size for check box?
  160. negitive and possitive numbers
  161. Lost excel file
  162. Unwanted Prompt When Saving a Protected Sheet in 2007
  163. spreadsheet with negitive numbers
  164. Filter Groups
  165. How to get -ve from +ve calculation?
  166. How to get -ve from +ve calculation?
  167. Show max and min on a graph
  168. Make custom buttons point to local macros always
  169. Splitting text using an HTML tage as the identifying place to brea
  170. Help..Need formula
  171. IF OR LEN Formula Question
  172. How can I lock a linked cell formula??
  173. vb help !
  174. open new file
  175. How do I copy formulas down a sheet using increments?
  176. Merge Cell Cut & Paste
  177. Lookup formula
  178. Conditional Formattting
  179. Detect open-state of xls from outside Excel
  180. macro
  181. lock button after click
  182. To summaryze information from many workbooks without open it
  183. Pivot Tables - Top 10 hide negatives values
  184. How do I distribute cost among group of employees based on salary
  185. Excel in a Web page
  186. Can I embed a pdf doc like a link?
  187. Conditional Formatting of rows on a calendar
  188. Forms Positioning
  189. How to use two drop-down list to fill data
  190. #VALUE Error should be simple fix
  191. How do I print formula text in Excel 2007?
  192. splitting long columns
  193. subtotal filter with growing range
  194. Link cell from Wkbk1 to a cell in a specific Worksht in Wkbk2
  195. Lookup with multiple returns
  196. Paste chart from Excel into Word
  197. Using Track Changes to protect just part of a document
  198. Linking cell format across worksheets
  199. Splitting rows in a worksheet
  200. Conditional Formatting: Databar
  201. counting rows when filtering data
  202. Importing and merging Excel files by using a macro
  203. find a year in a string of dates
  204. Export Error, Excel to SharePoint
  205. Cutoff Time for Changes
  206. Wordwarp
  207. OBDC Addins for Excel 2003
  208. How do I enable macro use in excel 2007
  209. Inserting page break
  210. formula help
  211. Paste not working in Excel 07
  212. Auto sort function for a list
  213. Rows not being displayed
  214. Generate reports on separate tabs from data in file
  215. FileMaker Pro Excel 2004 or 2008
  216. Sorting blank cells with a formula in them
  217. Excel 2007 spreadsheet references older office spreadsheets
  218. Lists for multiple files.
  219. how do i highlight the ten highest numbers in a range?
  220. Nested IF statements
  221. format to a specific number of spaces
  222. Consolidated array
  223. format phone numbers with an 800
  224. Conditional Formatting?
  225. Building a table from a list on another worksheet
  226. Sum If - I think
  227. counting cells within certain time frames - 24 hour clock
  228. Pivot tabl, hidden columns
  229. Price Ranking
  230. Counting Data
  231. Problem is displaying formula
  232. Lookup Y&X show Z but only in A & B are correct
  233. how do i turn on the tab over function
  234. Conditional Formatting
  235. Excel 2003 keeps on changing the date that i entered. HELP PLEASE
  236. require a change in formula
  237. Pivot table - Problem with % - part 2
  238. Excel 2007 Insert Check Boxes to an Entire Column
  239. count
  240. Cell Formating- Why won't my data center
  241. Excel - using the control key
  242. Conditional Formatting - Greyed Out
  243. PivotTabel Templates in Excel 2003
  244. borders
  245. conditional visibility of check box
  246. how do i circle a number?
  247. Sum of row and column entries (database)
  248. How can I custom autofiller with VBA
  249. if function and another cell value
  250. Impacting a cell
  251. Delay in formula
  252. Counter button
  253. Problems with consolidation
  254. why dose microsoft excel only read 10 didgets when doing inventor
  255. How to create "stop lights" as drop down box options?
  256. How do I save date format: dd mmm yyyy as a csv file?
  257. Macro runtime 1004 error on opening worksheet
  258. update links to password protected workbooks.
  259. How to change the font size for text within check box?
  260. how do i track staff absences
  261. non-responding chart
  262. change hyperlinks from relative to absolute
  263. A simple inputbox & responding msgbox coding
  264. How to create a checkk box?
  265. Scroll Bar Missing
  266. Help required to set up data management in excel
  267. =average - eliminate the top and bottom number
  268. vlookup to txt file or database
  269. MS Word like formatting in Excel
  270. large function result as reference for offset function
  271. Highlighting the differences between lists 2
  272. Sorting Chart
  273. Works to Excel Conversion
  274. Date format in cell
  275. Identifying the every nth document in a column
  276. Sumproduct using NOT equal to
  277. The Dates change when sheet copied to a new workbook
  278. default highlight color in excel 2007
  279. excel 2007 differences to 2003 questions
  280. Automatically filling additional cells with formula
  281. help with formula
  282. Column Comparition/Lookup Problem
  283. Fill column adjacent to external query (Excel 2007)
  284. Selecting objects for deletion in 2007
  285. repeat number multiple times
  286. Attn: Golfers! Need Help Calculating Hole-by-Hole Net Handicaps
  287. SUMPRODUCT not returning TEXT value
  288. how do I add coloured text cell contents ?
  289. Removing Duplicates Help
  290. Open XML File with Excel
  291. Page break
  292. cannot shift objects off sheet
  293. Using MS Query with Excel and Access 2007
  294. remove lowest 2 values in a row?
  295. How can I keep 2 rows of column headings out of sort data?
  296. Inserting blank rows in Excell
  297. Using Excel as data for mail merge...
  298. autofit text when resizing text box in Excel 2007
  299. Chart filtered pivot
  300. Find 3 numbers +/- 26 rows from each other
  301. Excel 2007-send Word Art text to back
  302. excel problem ?????
  303. Test if file exists
  304. Excel 2002: Need to increase capacity of selecting / deleting blan
  305. Stacked Charts Comparing 2 Years On 2 Different Sheets
  306. How do i transfer information from one excel file to another excel
  307. Worksheet duplicates
  308. pivot chart (change reference)
  309. Selectable layout for part of a worksheet
  310. Pivot table - Problem with %
  311. Conditional format or what else
  312. How to compress rows and lock rows
  313. Pulling data from one cell to another
  314. Merge 2 database
  315. Showing colors in Excel
  316. FORMATTING/CONVERTING TO ZULU TIME
  317. Formula Auditing
  318. how can I count checkboxes that have been checked?
  319. display range of values
  320. Calculating When Somebody Reaches a Certain Age
  321. TypeGuessRows
  322. Use index function to return formula
  323. Save file as todays date
  324. 2 decimal cell
  325. opening a window via VBA
  326. Meaning of On Error Goto 0
  327. TEXT issues
  328. Pivot Table Sort Order
  329. Reference & Duplicate Data Help
  330. Quatro pro converter for excel 2007
  331. attach an Excel 2007 template
  332. How do I get rid of the link cell showing the linking formula
  333. Modify Keyboard Shortcuts? Excel 2007
  334. Identifying duplicate values in a range
  335. Time Calculation
  336. Can't open xls file
  337. Can't turn off visual basic debugger in Excel 2003
  338. Fill Series in 2007
  339. Saving Excel data in tab delimited format to Notepad
  340. Copy Excel Tab delimited to Notepad
  341. Expanding a formula from a cell to a range
  342. Time schedule
  343. Overlapping Cells
  344. Data in cells disappear temporarily
  345. Default PivotTable category assignations
  346. Excel 2002: Request to speed up deleting blank cells
  347. no of days to go count to decrease automatically
  348. PivotChart resizing problem
  349. transpose
  350. to append the word file with pdf file
  351. How to paste values in a spreadsheet with a VBA function
  352. counting groups of blank cells
  353. If then on drop down
  354. Help with randomly displaying values from a list.
  355. a formula that return the cell location in a range
  356. Cataloging help
  357. Problem with time formula
  358. Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening the xls file which creates a Temp Folder inside Temp
  359. premium solver education
  360. Treasury Bond Pricing conversion
  361. Excel 2002: Why I could not sort month/year text now ?
  362. How to combine the content from eg. 3 cells into a new cell
  363. I need cell formula help
  364. Creating macro to use on different workbooks
  365. how do i change exel date to farsi date
  366. Adding Up Time Calcs
  367. Upload an Excel file?
  368. I need a template to calculate / simulate Salesmen incentive plan
  369. how to get left side zeros to show i.e. 00045
  370. getting information from sheet 1 into sheet 2
  371. excel instability - screen scrolls to end of sheet on right hand side
  372. Autofit to contents
  373. Problems with Array Formula - 2 data criteria
  374. How do I reduce the amount of columns in a sheet?
  375. lost tabs for Sheet1, Sheet2....
  376. How to kill the zipped files in C:\Document and Settings\LogginName\Temp\ using code for this strange Problem
  377. Creating uniform time format from multiple formats
  378. If Range not equal to zero in Visual Basic If/Then statement
  379. Finding duplicates within several worksheets
  380. Space-bar -- "recurring" instead of <space>
  381. a conditional formula
  382. Adding Time in Excel - Frustating experience!!
  383. complex linking data and files
  384. Excel Add-ins - File opening
  385. Cell blank when printing
  386. Help fixing a formula
  387. Saving Excel as Text (Tab delmited)
  388. Print Preview Error
  389. Break out of a loop in Excel2007?
  390. How do I view Excel data in Internet Explorer?
  391. Change General format to Date format
  392. Formula help
  393. Highlighting the differences between lists.
  394. Expanding a spread sheet to new cells.
  395. expanding a formula
  396. Matching Columns - very complex
  397. Excel 2007 shortcut keys
  398. opening an excel file differences - time
  399. Sort/Reference formula help needed.
  400. Excel 2003 -??
  401. Formatting - Opening a spreadsheet
  402. copy from worksheet in macro
  403. copying & incrementing formulae across open worksheets
  404. Find/Replace within links in cells
  405. Data Label in a PivotTable
  406. Saving Excel spreadsheet in txt format
  407. DISPLAYING RESULTS OF A FORMULA
  408. Problem with a Sumproduct formula
  409. Create a list of files with their thumbnail images?
  410. Excel 2003 Formula not responding
  411. #VALUE problem
  412. formula for totals in column C if they are words rather than numbe
  413. Pivot Table Page Field Issue (Not sorting)
  414. How do I remove the Header from the first page in Excel?
  415. E+14 error
  416. vlookup to a word in a cell
  417. Supress Rows Before Printing - Toolbar Icons become disable
  418. Changing Database links?
  419. Excel 2007 printing 2 copies of everything - need to stop this
  420. Keeping Conditional Formats 'Constant' when copy & paste
  421. Function to move data
  422. date format problem
  423. Frequent workbooks
  424. macro-add text
  425. Moving data to another file - help needed
  426. What is the VBA to put the password in the prompted box
  427. Conditional format, using current and other cell, searching blanks
  428. Remove Page Breaks
  429. Validation list with non blanks from different column
  430. Excel covered in light blue wash and freezing menus
  431. GetOpen filename to open files(Workbooks)
  432. how to write formula for countif (range,"<2" &">3")
  433. Which one to use:Macros/formula/Lookup
  434. embedded documents - label text reverts to a default
  435. Sort/Reference formula help needed.
  436. Count text
  437. sum and count text and numbers same column
  438. Creating data cell from other table from diff. Workbook
  439. Creating Data series from a table from diff. Workbook
  440. Creating Data series from a table from diff. Workbook
  441. Lookup on worksheet
  442. SUMIFS error
  443. Unable to scroll in unlocked worksheet
  444. need column to reflect year 2008 dates
  445. Replace "dash" with "space"
  446. Replacing carriage returns with a comma
  447. Concatenate() help
  448. Count number of values
  449. Fitting columns on one page
  450. Calc Field not showing on New Sum Row in Pivot table
  451. Shortcut needed
  452. forget password in excel 2007, how to recover the doc?
  453. Join non-contiguous ranges into one range via named range?
  454. due dates on excel
  455. Copy and Pasting Dates
  456. Clear page
  457. copying one sheet to another workbook
  458. Subtotals
  459. How do I report to User A vs User B from shared data table?
  460. Custom filter limit removed in 2007?
  461. Wrapping Text in Merged Cells - Excel 2002
  462. Round up this formula
  463. Highlight cells based on conditions
  464. saved Excel as .txt then reopened - now I have squares
  465. Wrapping Text in Merged Cells - Excel 2002
  466. change the data validation to 'any value if 'other' is selected
  467. Save as dialogue box, changing font size/color
  468. Word File Objects in Excel
  469. Breaking out of a loop in Excel 2007?
  470. flowchart printing problems
  471. problem importing text into excel 2007
  472. Date format in header
  473. copy to new cells if populated
  474. Growing Degree Days Formula
  475. count specific subtotal values only
  476. Excel Worksheet
  477. Automatic Data Sort?
  478. how do i get descending,top 25 to work? #s dont seem to change
  479. Date entry
  480. web query url returns data, but not showing
  481. How do I make a specific cell mandatory?
  482. Protecting the Print Range.
  483. How do I embed a .lnk file in an Excel form?
  484. data turned in date format when copied
  485. e mail address appears & prints blue instead of black
  486. custom format
  487. compare dates
  488. Why can't I call a range of cells 'c'?
  489. Can I add a number to the contents of a cell to indicate a note ..
  490. XY Scatter Chart - Drag individual data points on graph
  491. Force excel to start new instance when I double-click a workbook
  492. All email addresses in one cell, how to seperate them?
  493. Adding Multiple Pages(Tabs)
  494. Pivot Table - Hidden Data
  495. Can I change the appearance of Selected active cells in Excel 2007
  496. Can multiple formulas be inserted in a single cell?
  497. which one to use: Macros / Formula's / Lookup
  498. Default Border Colour
  499. Count the number of items received in a certain month
  500. mathmatical equation symbols
  501. Conditional Formatting
  502. Sum a filtered range
  503. How to make Weighted Average
  504. Zoom with Scroll wheel
  505. Why won't all the pages of my spreadsheet print?
  506. how can i get in contact with a template provider??
  507. sum unique entries only
  508. offset() function #VALUE!
  509. is it possible to print an excel adress list on envelopes?
  510. How to retain table column titles in 2007
  511. I press "enter" but it doesn't move to next row down.
  512. Data Analysis
  513. How to optimize? large non-contig cell range for data validation l
  514. Merge Docunent
  515. Input box and filters
  516. Reference Formula Help
  517. Insert a row and keep the conditional formatting
  518. Working with hex in Excel
  519. Excel - making changes in one workbook so they affect other workbo
  520. Multiple cells or columns are selected instead of selected cell or
  521. How do you set the "Print what" option
  522. Creating a list
  523. Shared Workbook
  524. imported data has weird columns on left
  525. Can you create a dynamic footer in Excel?
  526. cell is not outlined when clicked on
  527. can you filter so that you only see cells that contain comments?
  528. Matching 2 columns
  529. Conditional Formatting - Row colour
  530. Macro buttons opening saved macro
  531. Adding a negative number instead of substracting it
  532. deferred revenue
  533. Unable to print excel sheets
  534. Mysterious Double Deckered Cells
  535. How to track business contracts
  536. Function that can differentiate between text & numbers???
  537. Find 3 largest numbers in a column that are at least 26 cells apar
  538. devide by 1000
  539. Macro for cells that are less than 1 and conditioned on another ce
  540. Auto format blank rows using code
  541. Concatenation based on conditions
  542. Working with multiple worksheets at the same time.
  543. Repeat copy for indifinate number of worksheets
  544. Data Validation with linked File
  545. Delete object code
  546. Getpivotdata with a lookup functions
  547. SUMPRODUCT column criteria
  548. Formula Help - Urgent
  549. Case Sensitive v-lookup needed
  550. If Formula confusion
  551. Formula/Comparison/Match Question
  552. formula for conditional formating
  553. Filter question
  554. SharePoint and Shared Workbooks
  555. Excel 2007 countifs function problem
  556. Previewing Totals in highlighted cells
  557. Thumbnail preview for Windows 7 taskbar
  558. Delete blank rows
  559. Needing Help with Data Transfer/Automatic Link
  560. My clock
  561. can i get numbers changed in words(english) in excel sheet?
  562. Clearing Print Area Outline
  563. Getting rid of the Print Area
  564. How to create 2 dependent drop down lists from 1 original drop dow
  565. Removing the print area dost from the screen
  566. Track Changes - Increase View
  567. Next without For..?
  568. Help with looking up information
  569. Value Sum
  570. How do I display a "+" in front on positive numbers
  571. IF STATEMENT WITH OR
  572. why am i encountering result N#A when doing the VLOOKUP function
  573. COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS
  574. Fix size and position of comment
  575. how to view font color in excel 2007
  576. Error using DataObject to get clipboard data
  577. Formulas
  578. Analyzing foreign exchange rates
  579. Macro Problem
  580. SUMIF function and cell /sheet reference
  581. Smallest positive value
  582. Word Table to Excel
  583. #value error
  584. How do I get a formula in a cell to read from another cell
  585. envelope mail merge
  586. Pasting Excel file for .html table
  587. Vlookup function macro
  588. how can one get a gradient from a line graph
  589. "Print what" default
  590. Import Access data into Excel 2007
  591. Combo box formatting
  592. Combine 2 formulas
  593. Summarize data
  594. Users periodically get 0 byte size files on initial save to networ
  595. Back up all Excel files
  596. Counter in macro
  597. convert number into a decimal
  598. how to copy a value from another cell by using a one key entry
  599. Printing multiple copies in Excel 2003
  600. How to tell how much credit line I would need to give........
  601. Check Boxes
  602. Error when closing file
  603. rename excel file name
  604. iserror to eliminate #N/A
  605. Pivot tables in Excel 2007
  606. Mortgage Refinance Comparison
  607. change spreadsheet name change
  608. Which formula?
  609. Using conditional formatting
  610. Counting calendar Days - not including Sundays
  611. Find funtion in macro
  612. average
  613. Cannot find . which has been assigned to run each time . is close
  614. Macro for Costing
  615. RE: UNABLE TO CHANGE SHARED FILE
  616. Excel 2003 - right click clears selected cells
  617. Excel 2007 autofit row height
  618. Lookup value and return column offset value
  619. Sorting Datain a Shared Workbook
  620. transfer datas into different sheet using macro?
  621. exel spread sheet
  622. automatically adding formula to added cells
  623. projecting dates
  624. Urgent Pls, how to convert an addin xlam file to xls worksheet in
  625. Q for Dana DeLouis
  626. resizing copied chart makes text unreadable
  627. Create a form in Excel
  628. Drop Down Shading
  629. How do I email the document I am currently working in?
  630. VBA script
  631. CountA question
  632. track use of cell
  633. Macro to automatically sellect 'No' in dialog box
  634. Dynamic database extraction for reporting
  635. Maximum value from a pivot table - formula
  636. Formula to get the maximum hours
  637. Author name edit
  638. Financial rear date ranges in a single cell
  639. Trend Data From an updated column
  640. Active x control box display order
  641. Autofilter - 1000 Selection Limitation?
  642. How to delete a 'Select Box'
  643. Need Template: Profit and Loss statement for Small Business
  644. Time Sheet
  645. EOMONTH as test criteria
  646. enter named range as opposed to cell ref.
  647. Text specific using conditional formatting
  648. List sort - filter macro based on check box
  649. Validation with formulas
  650. Pop Up Calendar - Excel 2002
  651. % of total
  652. Ctrl Home disabled in protected worksheets
  653. Cell Update only at a specific time.
  654. Lookup Values
  655. Why can't I sort a 2003 file in 2007? 2007 freezes.
  656. New issue with cell formatting
  657. Macro
  658. Corrupt Excel Worksheet
  659. Dates formula
  660. Printing Macro for Excel 97
  661. Blank Worksheet does not open on Excel Launch
  662. Imported Data Not Replacing Existing Data - Excel 2007
  663. fill cell with colour if preceding cell is a negative value
  664. Help with Average Formula
  665. Check Box
  666. Excel 2007 Pivot Table from a Paradox File
  667. Modifying format for multiple comments in a workbook
  668. Simulate Check Box
  669. creating formulas
  670. links
  671. Open XL - A Powerful Excel Addin
  672. travel expense calculator for 2003
  673. Excel Pivot Tables
  674. Transfer data between files
  675. Import data
  676. using formula or similar to paste maximum value in cell in excel 2
  677. Conditiona format
  678. Excel - cursor not visible in drawing objects
  679. batch edit cells
  680. Automatically enter cell text
  681. disregarding zeroes
  682. No Menu functions/options when right clicking mouse
  683. Formula to fetch the date of first weekend of a month
  684. Counting a Specific Character
  685. Creating a Summary Sheet
  686. Formulae Ref Different Worksheets
  687. Add a number '1' next to highest number in column
  688. How to create function to look up the value
  689. Corrupted Excel Program File?
  690. Result displays "FALSE" instead of "FAIL"
  691. Two tables?
  692. connecting to .csv files in variable locations
  693. Excel 2003 Protecting a worksheet.
  694. Compare & sum previous month production by workday.
  695. insert row when sum of values equals 100
  696. How do I determine the last cell in a Column
  697. Membership list
  698. Change month name in workbook
  699. Stop cell showing zero when returning a blank cell
  700. vlookup, hlookup and return value of intersecting cell
  701. spresad sheet
  702. why is answer rounded up?
  703. #N/A Conditional Formating
  704. #N/A Conditional Formating
  705. Need help with IF(AND / OR
  706. How many way to represent the blank space?
  707. Sort
  708. Sum with multiple conditions
  709. averageif for a range of values in another column
  710. Printing Macro
  711. Disable cell focus
  712. I select 1 cell and excel selects 2,3 or 4 cells ? Why ?
  713. How do you calculate an interest only loan
  714. vlookup: data same in 2 tabs yet get #N/A when shouldn't
  715. Export Excel spreadsheet
  716. Return cell reference rather than value
  717. Copying an incoming e-mail message to two or more folders.
  718. Running Total
  719. sheet tabs disappear
  720. Showing all rows in a pivot table
  721. one of two criteria
  722. Filling a cell with "-"
  723. IN EXCEL, TO CENTER & UNDERLINE A YEAR (ie: 2009), NOT "2,009"?
  724. sort and break a worksheet to new Ecxel's folders?
  725. Avoiding error on Input Box - if no value is entered
  726. launch from explorer in Vista - multiple instances of Excel
  727. Protect/Unprotect workbook
  728. How do I pull data from one sheet and place it in another?
  729. discounted percentage price
  730. Defined name value error
  731. Web queries crash excel
  732. Lookup text in array & return cell reference
  733. calculating water bill base on the following rules
  734. Create logic functions like a flip-flop in excel?
  735. Shift - Alt - D shortcut
  736. How do I get rid of the left upper corner boxes with numbers
  737. Calculating Non-working Dates and Times
  738. cropping
  739. How do I format a column to be half the size of the one above it?
  740. How do keep row height from changing? Excel 2003
  741. repeat list 5 times
  742. Setting multiple conditions to return a figure from multiple cells
  743. Can I specify the order...
  744. Compatibility mode & colors
  745. Change day of week to day of month
  746. open file with code
  747. Hyperlinks on protected sheet don't work
  748. Microsoft Excel has encountered a problem...
  749. Printing sheets in a Workbook
  750. text format question
  751. Leading Zero & Apostrophe - Help
  752. Excel changes file extension on embedded object upon save
  753. Formula setup
  754. Excel and Vista
  755. Add check box to cell in excel 2007
  756. Macro for forward and back button
  757. Vlookup with duplicate unique items
  758. Passing several parameters to OnAction property.
  759. IF Statement
  760. Loop with variable name?
  761. Short-cuts
  762. A CAP?
  763. Looking for help with If statement
  764. Copying conditional format across columns
  765. Number Format
  766. Macro to create new sheet
  767. Trying to get Vertical Lookup to return more then one value...how?
  768. Copy and replace xlsm files, but retain the values in selected cells...
  769. Recent File List Empty
  770. Large Formula Help
  771. cross referencing data
  772. Formula not working
  773. Data Match up
  774. maintain data from drop down menus
  775. SUMIF w/multiple conditions
  776. Maths
  777. conditional formatting if ANd
  778. conditional formatting if and And
  779. How to consolidate all worksheets data into 1 worksheets?
  780. Sorting data bust ignoring numbers
  781. If Statement re-post
  782. Excel 2007 says a workbook is corrupted when it isn't
  783. How to create an if statement to get a multiple result
  784. Update source in VBA
  785. How can I show the outline of my print area
  786. add up winning teams
  787. how do i stop excel 2007 from creating .tmp files
  788. Convert formula result to string
  789. How to make cells collor unchange if data source change in format
  790. in need of a formula
  791. Conditional formatting
  792. Shared worked very slow to open
  793. Number Format
  794. Count No of Engagements
  795. Multiple Selection Combo Box
  796. Count of Non-Zero pivot table entries
  797. Conditional Formatting Questions
  798. Fill in a series of numbers
  799. Hiding rows in Excel 2007
  800. Lost Column Letters
  801. WebControl and Drop-down Lists!
  802. vlookup instructions,, or help making a formula
  803. Change Font Color on Dates
  804. If Formula
  805. multiple users in 2007 Excel document at one time
  806. Using an IF stmt then copying/pasting into new spreadsheet
  807. SUMIF formula works in Excel 2003, does not work in Excel 2007
  808. Removind diagonal lines created on sheet
  809. Newbie question
  810. Referencing every other line
  811. Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors.
  812. VlookUp Help Please!
  813. Update Date, Time Only Upon Save
  814. Font Colors
  815. Alphabetical sort with formulas
  816. Conditional formating problem. Please help.
  817. Copy from one worksheet to another
  818. entering footnotes in worksheet
  819. print differs from spreadsheet
  820. Text OTU
  821. Automatic sort of a list.
  822. Cell Reference on a different sheet
  823. Combining worksheets
  824. How do I get rid of a blank row at bottom of Excel spreadsheet?
  825. text to columns
  826. Downloading quickbooks files to Excel 2007
  827. auto recovery
  828. values v formulas with conditional formats
  829. Check Box Size
  830. drop down list
  831. Sorting Prospects by street name
  832. Pulling data from other wb based on data to populate dropdown list
  833. Column width indicator missing?
  834. formatting embedded object
  835. Pivot Table Charts - Help Required
  836. Count unique with criteria
  837. filling down to the end of a data set automatically
  838. Office Excel 2003 Macro error with .xls files
  839. Excel 2003 Regarding Cell Protection
  840. Staff Levels
  841. Need help with Count, Counta, Countif
  842. Calculation of workdates
  843. show balance
  844. Formula
  845. Pulling non-zero data from table
  846. Arranging row titles in a Pivot Table
  847. Fill down visible cells only
  848. Creating a macro from an email attachment
  849. Sheet Data Filters
  850. Sort Macro
  851. Conditional formatting, If cell
  852. Multiple criteria
  853. Link in worksheet
  854. How to I do a simple template for a timesheet
  855. Sumproduct or Sumif formula
  856. Hide cell unless value entered into any cell on a row
  857. setting more than one condition and multiple ranges
  858. Round down if decimal 0.33 or below up if 0.34 or above
  859. External Data Refresh all just for one worksheet
  860. Formula/Visual Response
  861. Insert a text in column A and calculoate the average for every gro
  862. Conditional formatting
  863. create formula using table
  864. Opening in 2003
  865. insert row when sum of values equals 100
  866. nameing a worksheet
  867. SUBSTITUTING TEXT FROM A LIST
  868. Excel 2003 file opening incorrect in 2007
  869. How to get an Excel file to save without the VB
  870. Transfer Works 2000 .wks files to Excel 2007
  871. Combing 2 lists of data
  872. Any tools to view Excel on my Nokia?
  873. conditional sumproduct? no idea.
  874. Linked cells (?)
  875. i am in need of a chcek stub template?
  876. Combine Data
  877. Numbering Excel template
  878. Excel 2007 - Y Axis
  879. Attachments in recent files list
  880. Double Click within Cell
  881. Chart - size change with hide rows
  882. Conditional - empty cell
  883. Can you open 2 windows of excel with duel screens?
  884. Grouping Dates by Month
  885. Need to count repeates in a very large list of cells with text
  886. how to access deleted or lost excel files on xp?
  887. Excel 2003 Data Validation
  888. convert decimal inches into feet and inches
  889. In Excel how do I update cells in multiple sheets simultaneously?
  890. A formula to identify tab names in a worksheet
  891. Work Loss
  892. Import file information
  893. Combination IF, VLOOKUP
  894. VBA check if date is in future
  895. SUMPRODUCT & TEXT
  896. extract date if count formula
  897. calendar
  898. Data Validation - V-Lookup -
  899. How do I add a trenline to a selected potion of a line
  900. divide by zero
  901. worksheet code area
  902. keyboard shortcut to pull up sheet menu(copy,delete,rename,etc)?
  903. Can vlookup do a multi-column match...if not then what
  904. formula help
  905. Formula
  906. Indexing
  907. Random Function
  908. Sending Email from within Excel 2003 using Outlook 2003
  909. Display ToolTip for User Defined Function
  910. Excel cell contents to query criteria
  911. Cell programming question
  912. Rounding and dropping digits
  913. How to count lower case alphabet?
  914. Excel Startup
  915. Protecting Worksheet Beyond Column Z
  916. How to show % increase when accuracy decreases?
  917. underscore in email address covered by hyperlink underscore
  918. How to use conditional formatting for rows, based on info in cells
  919. VBA Vlookup using high & low date comparison
  920. Rounding a Formula Result Up or Down by the 100s
  921. Can I insert references (citations from RefMan) into Excel?
  922. Merging Excel Cells
  923. Looking Up Part Cell Contents
  924. Unlocking a protected sheet
  925. Count if
  926. display results 2 of 2
  927. TRIM
  928. Date Format Not Responding to MM/DD/YY
  929. INDIRECT and CONCATENATE in Defined Name
  930. enter page number in body of worksheet
  931. Conditional Date Alert
  932. Worksheet frozen after using Compare side by side
  933. Automatically change ranges when copying formula
  934. coding error I don't know how to debug?
  935. Forgot to close XL compare side by side
  936. Tracking Changes in Excel 2007
  937. AutoFilter sort
  938. Swapping Columns
  939. Last 4 digit
  940. Is There A "Name Worksheet" Ability in EXCEL?
  941. Excel 2007 calculate time between 2 date/time columns
  942. lookup on values between ranges
  943. Counting a text value between dates
  944. Printing selected cells only
  945. All my text box disappear.
  946. IF Statements - to include calculation?
  947. Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct"
  948. alt+enter is not working in excel 2007
  949. alt+enter is not working in excel 2003.
  950. Import Data from Access query
  951. no minimize or close button
  952. SUMIF using cells with commas in
  953. how to Extract the date or text from the whole column
  954. Index / match combination
  955. Two arrays same?
  956. if statements using words
  957. How do i retrieve a replaced existing file?
  958. AGING
  959. loan calculator with residual balance
  960. Emailing a selection from Excel spreadsheet
  961. sumproduct text and numbers same column
  962. Command Button to show/hide a different worksheet
  963. delete on right click menu disabled
  964. How do I use excel to countdown to a future date?
  965. Unwanted spaces in merged cells
  966. Calorie Counting Chart
  967. Conditional Formatting Times
  968. filters
  969. Saving Group Information
  970. Cashflow Postive Lookup
  971. Excel 2007
  972. Excel 2000 & .xlsx
  973. compare column
  974. Macro or Formula to merge data
  975. Little question marks on page pop up note about AIM4WIN.XLA
  976. Excel 2007- Adding data in multiple cells at the same time
  977. Group/Sort records in Excel
  978. Digital signatures in workflow constantly get invalidated!
  979. Digital signatures constantly getting invalidated
  980. Highlighting Like Names in a Column
  981. TRIM Help !
  982. Picture in Header Causing Empty Square to print on Spreadsheet
  983. Sub total vs Pivot Table
  984. Excel File Converting to a .pdf
  985. Data validation - 2 items
  986. Row Scrolling with a Page
  987. Name appears twice in 15 days
  988. Insert Leading Characters If String Is Only 7 Characters
  989. I need VLOOKUP For Dummies
  990. Automatic Cut & Paste - Possible?
  991. Changing the name of a sheet
  992. print selected cells in Excel
  993. How to place a legend inside a legend
  994. Spellcheck doesn't work in Excel 2007
  995. How 2 Question
  996. Printing Issue in Excel 2007
  997. Excel Slow To Open
  998. Sorting Worksheet Tabs
  999. excel doing some weired stuff
  1000. Inserting part of a Spreadsheet into the Current Spreadsheet