Archive of microsoft.public.excel for September 2009

The following articles have been archived for September 2009 from microsoft.public.excel:

• Running MS Query on an Excel Spreadsheet posted on Wed, 30 Sep 2009
• Select name from drop down and return associated value posted on Wed, 30 Sep 2009
• Add SUMPRODUCTS with Multiple Criteria posted on Wed, 30 Sep 2009
• protecting cells posted on Wed, 30 Sep 2009
• 2007 cell character limit posted on Wed, 30 Sep 2009
• Rounding Numbers into Retail Amounts posted on Wed, 30 Sep 2009
• What does the Header Footer add to filesize? posted on Wed, 30 Sep 2009
• (how) Can I do this graph? posted on Tue, 29 Sep 2009
• list data without blank rows posted on Tue, 29 Sep 2009
• Green ball multiple times on QAT posted on Tue, 29 Sep 2009
• Pivot Table default Value Field Settings posted on Tue, 29 Sep 2009
• entering special characters posted on Tue, 29 Sep 2009
• Minus Percentage.. posted on Tue, 29 Sep 2009
• calculated field for percentage in pivot table posted on Tue, 29 Sep 2009
• Calendar posted on Tue, 29 Sep 2009
• Dynamic date range posted on Tue, 29 Sep 2009
• Calculating Combinations posted on Tue, 29 Sep 2009
• Text or Number??? posted on Tue, 29 Sep 2009
• Colour change depending on result posted on Tue, 29 Sep 2009
• Possible to use pivot table on non-mumeric fact data without calculating? posted on Tue, 29 Sep 2009
• Embedding <CR>'s in formulas eases eye strain. posted on Mon, 28 Sep 2009
• how to populate a range with another range of data ? posted on Mon, 28 Sep 2009
• Change colur of single column in chart posted on Mon, 28 Sep 2009
• If Statement Error posted on Mon, 28 Sep 2009
• subtract one hour from time posted on Mon, 28 Sep 2009
• Multi-Concatenate posted on Mon, 28 Sep 2009
• Forcing output to 1 decimal place posted on Mon, 28 Sep 2009
• Local cube path to database posted on Mon, 28 Sep 2009
• Not so simpel copying of a simple formula posted on Mon, 28 Sep 2009
• Using cell contents in a formula to refer to another file posted on Mon, 28 Sep 2009
• Data Organized posted on Sun, 27 Sep 2009
• Protect workbook and hide formulaes posted on Sun, 27 Sep 2009
• Why is my empty Excel workbook 2/3 MB in size? posted on Sun, 27 Sep 2009
• corrct this formula posted on Sun, 27 Sep 2009
• Excel 2007 Saving Cell types in XLS format posted on Sat, 26 Sep 2009
• delete row if given cell = 'X' posted on Sat, 26 Sep 2009
• Conditional Formatting Excel 2003 posted on Sat, 26 Sep 2009
• List with Hyperlinks - XL2003 & 2007 posted on Sat, 26 Sep 2009
• Chart Problem 2 posted on Sat, 26 Sep 2009
• Map co-ordinates conversion posted on Sat, 26 Sep 2009
• Icon Sets Conditional Formatting in Excel 2007 posted on Fri, 25 Sep 2009
• Can't find the link posted on Fri, 25 Sep 2009
• Returning the first part of a workbook name posted on Fri, 25 Sep 2009
• Validation based on the value in another cell posted on Fri, 25 Sep 2009
• Edit the rule description-how can u see a long formula in its enti posted on Fri, 25 Sep 2009
• Do not copy and paste from Excel 2003 to 2002 posted on Thu, 24 Sep 2009
• if value entered, then do this posted on Thu, 24 Sep 2009
• xldynamic is back posted on Thu, 24 Sep 2009
• Extracting numbers posted on Thu, 24 Sep 2009
• Repeating rows dont repeat fully when columns also repeat posted on Thu, 24 Sep 2009
• Types of cell references? posted on Thu, 24 Sep 2009
• reflecting values in a column into a row posted on Thu, 24 Sep 2009
• Error messages on templates posted on Thu, 24 Sep 2009
• Conversion Of Unix Time posted on Thu, 24 Sep 2009
• compare two cells with non-numeric data posted on Wed, 23 Sep 2009
• Sorting: XL2007 posted on Wed, 23 Sep 2009
• Pivot table on local cube posted on Wed, 23 Sep 2009
• Copy and Paste problems posted on Wed, 23 Sep 2009
• freeze panes in "save as web page" posted on Tue, 22 Sep 2009
• Keep my leading zeros posted on Tue, 22 Sep 2009
• creating a csv spreadsheet and formatting it via another program posted on Tue, 22 Sep 2009
• print data by row posted on Mon, 21 Sep 2009
• Sorting cells that contain functions posted on Mon, 21 Sep 2009
• sumifs using dynamic criteria posted on Mon, 21 Sep 2009
• Functions in Excel Comments posted on Mon, 21 Sep 2009
• Max Value in a cell posted on Mon, 21 Sep 2009
• Summing data referencing incremental cells posted on Mon, 21 Sep 2009
• Putting list items under appropriate date? posted on Mon, 21 Sep 2009
• Excel question posted on Mon, 21 Sep 2009
• Replacing Text with a Number posted on Mon, 21 Sep 2009
• Using the IF Command posted on Mon, 21 Sep 2009
• Top 5 vs Bottom 5 posted on Sun, 20 Sep 2009
• viewing CSV file in Excel-2000 posted on Sun, 20 Sep 2009
• Meeting Goal? posted on Sun, 20 Sep 2009
• Windows can not find my spreadsheet posted on Sun, 20 Sep 2009
• TEXT = text posted on Sat, 19 Sep 2009
• Fancy Lookup posted on Sat, 19 Sep 2009
• Saving a XLS file posted on Sat, 19 Sep 2009
• DATA IN SHEET 1 ON THE BASE OF SHEET 2 posted on Sat, 19 Sep 2009
• Excel 2007 Hangs up frequently posted on Fri, 18 Sep 2009
• protect borders on a data entry cell posted on Fri, 18 Sep 2009
• Sumproduct of 3 separate column ranges posted on Fri, 18 Sep 2009
• PasteSpecial method of Range class failed posted on Fri, 18 Sep 2009
• Comparing two rows posted on Fri, 18 Sep 2009
• Printing Individual Tabs to .pdf posted on Fri, 18 Sep 2009
• Changing Find settings posted on Fri, 18 Sep 2009
• Open a wb3 file with excel 2007 posted on Fri, 18 Sep 2009
• Lookup in more groups posted on Fri, 18 Sep 2009
• How can I reference a cell using a variable? posted on Fri, 18 Sep 2009
• Importing a csv file into an Excel posted on Fri, 18 Sep 2009
• Vlookup not working where lookup value contains an apostrophe posted on Thu, 17 Sep 2009
• sorting by last char posted on Thu, 17 Sep 2009
• Reset Sheet Count -Second Request Any Help Appreciated posted on Thu, 17 Sep 2009
• match & combine 2 zip code lists and dollar amounts posted on Thu, 17 Sep 2009
• PLEASE ALWAYS INDICATE WHAT VERSION OF EXCEL YOU'RE USING -- posted on Wed, 16 Sep 2009
• Hiding/Expanding rows in Excel? posted on Wed, 16 Sep 2009
• Simple Date/Time Macro posted on Wed, 16 Sep 2009
• Green cell corners posted on Wed, 16 Sep 2009
• Average for the last n values of a list that changes everyday posted on Wed, 16 Sep 2009
• Need Formula To Find Blank and NonBlank Cells posted on Wed, 16 Sep 2009
• Filling in blank rows in a Table of data posted on Wed, 16 Sep 2009
• prevent the users from making changes to the excel report posted on Wed, 16 Sep 2009
• Add a decimal to each number on a list of whole numbers posted on Wed, 16 Sep 2009
• delete row depending on the value of a cell posted on Wed, 16 Sep 2009
• newbie question posted on Wed, 16 Sep 2009
• Reset Sheet Count posted on Wed, 16 Sep 2009
• Charts in Excel posted on Wed, 16 Sep 2009
• Match 2 different zip code lists posted on Tue, 15 Sep 2009
• Access "filters" posted on Tue, 15 Sep 2009
• Extract text posted on Tue, 15 Sep 2009
• Find records that meet this criteria posted on Tue, 15 Sep 2009
• Drag woorkbooks to Excel Icon posted on Mon, 14 Sep 2009
• Printing options for all sheets in a workbook? posted on Mon, 14 Sep 2009
• Counting specific test in a column in another worksheet that fall between entered dates posted on Mon, 14 Sep 2009
• Conditional Formatting posted on Mon, 14 Sep 2009
• autofill series posted on Mon, 14 Sep 2009
• Very slow opening excel files in Outlook posted on Mon, 14 Sep 2009
• activesheet posted on Mon, 14 Sep 2009
• Stacked bar charts side by side posted on Mon, 14 Sep 2009
• Shortcuts to MS Excel files don't work posted on Sun, 13 Sep 2009
• Capitalize the 1st letter of text entered in a cell posted on Sun, 13 Sep 2009
• Invoice Numbers posted on Sun, 13 Sep 2009
• Array formula difficulty posted on Sat, 12 Sep 2009
• Question about Excel 2010 posted on Sat, 12 Sep 2009
• Formulas to (a) pull month, year and (b) sum within date range? posted on Fri, 11 Sep 2009
• Hope you can help posted on Fri, 11 Sep 2009
• Sorting/filtering by Color posted on Fri, 11 Sep 2009
• Command button counter posted on Fri, 11 Sep 2009
• Command Button Count reset posted on Fri, 11 Sep 2009
• Finding characters within a text posted on Fri, 11 Sep 2009
• Modify pivot table report posted on Fri, 11 Sep 2009
• clustered 3d column chart posted on Fri, 11 Sep 2009
• how to sort tabs in Excel 2007 posted on Fri, 11 Sep 2009
• Macro to delete all (and only) rows with cell value "" (blank) in column A posted on Fri, 11 Sep 2009
• count formula posted on Thu, 10 Sep 2009
• Counting Soecific dates in a range posted on Thu, 10 Sep 2009
• Disable Autocomplete in cell posted on Thu, 10 Sep 2009
• Skip if empty posted on Thu, 10 Sep 2009
• =SUMPRODUCT question posted on Thu, 10 Sep 2009
• Running a macro from another workbook posted on Thu, 10 Sep 2009
• increase cell by 1 posted on Thu, 10 Sep 2009
• excel won't launch posted on Thu, 10 Sep 2009
• Add row between current rows in a way to long sheet.... posted on Thu, 10 Sep 2009
• Margins, footers etc posted on Thu, 10 Sep 2009
• Macro executing (copy data) from at sett of sheets in the workbook posted on Thu, 10 Sep 2009
• nested "if" formula problem. posted on Wed, 9 Sep 2009
• format "focus" characteristics posted on Wed, 9 Sep 2009
• Formula to round based on thousandths place posted on Wed, 9 Sep 2009
• Columns - autofit posted on Wed, 9 Sep 2009
• Copy sheet to a new book, but remove any macros associated with that sheet posted on Wed, 9 Sep 2009
• Macro takes forever - didn't used to posted on Wed, 9 Sep 2009
• hide/unhide command button posted on Wed, 9 Sep 2009
• New spreadsheet only prints the first page posted on Wed, 9 Sep 2009
• Find the rightmost value posted on Wed, 9 Sep 2009
• SUMIF where the IF is a variable date from data in a column HOW? posted on Wed, 9 Sep 2009
• Printing footnotes in Excel - active printed area posted on Wed, 9 Sep 2009
• Way to have a formula that combines the text of two different cell posted on Tue, 8 Sep 2009
• error in numbers posted on Tue, 8 Sep 2009
• Offset works for numbers, not for text posted on Tue, 08 Sep 2009
• Remove Leading Zeros from dates, need 4 Digit year posted on Tue, 8 Sep 2009
• Workbook_Beforeclose posted on Tue, 8 Sep 2009
• Circular reference, Indirect, and Sum posted on Tue, 8 Sep 2009
• Remvoe conditional formating but not the effect posted on Tue, 8 Sep 2009
• Conditional Formatting posted on Tue, 8 Sep 2009
• matching and finding data posted on Tue, 8 Sep 2009
• How to get domain from e-mail posted on Mon, 7 Sep 2009
• If Condition posted on Mon, 7 Sep 2009
• Pasting posted on Mon, 7 Sep 2009
• Filter or highlight the last 10 entries posted on Sun, 6 Sep 2009
• Help with Formula posted on Sun, 06 Sep 2009
• Need help adjusting time posted on Sun, 6 Sep 2009
• Weirdly slow office programs posted on Sat, 5 Sep 2009
• XBRL posted on Sat, 05 Sep 2009
• Getting sheetname that calls a macro. posted on Sat, 5 Sep 2009
• importing a table in powerpoint to excel posted on Sat, 5 Sep 2009
• rota template posted on Sat, 5 Sep 2009
• Application Quit does not work posted on Fri, 4 Sep 2009
• exit from nested macro posted on Fri, 4 Sep 2009
• Text Boxes Hidden posted on Fri, 4 Sep 2009
• Invoice numbers posted on Fri, 4 Sep 2009
• What have I done? posted on Thu, 3 Sep 2009
• Excel 2007: Matching Year & Month without regard to Day posted on Thu, 3 Sep 2009
• Lookup table with click-and-select? posted on Thu, 03 Sep 2009
• Various data in a row for dulicate fields in column posted on Thu, 3 Sep 2009
• mail merge problem posted on Thu, 3 Sep 2009
• Excel 2007: Formula to count unique values in a range posted on Thu, 3 Sep 2009
• Resizing cells to fit text returned by VLOOKUP posted on Thu, 3 Sep 2009
• Quick SUMIF() query - criteria relating to cell posted on Thu, 3 Sep 2009
• Populating cell by color format-IF statement? posted on Thu, 3 Sep 2009
• How to easily crash Excel 2002. posted on Wed, 2 Sep 2009
• Page x of y in WorkBook posted on Wed, 2 Sep 2009
• Excel file freezing computer posted on Wed, 2 Sep 2009
• Printing problem posted on Wed, 2 Sep 2009
• Checking how a macro is called posted on Wed, 2 Sep 2009
• Copying Sheet2 data To Sheet1 Thru VLOOKUP posted on Wed, 2 Sep 2009
• Block a sheet from being unhidden posted on Wed, 2 Sep 2009
• Sum of data on a per month basis posted on Wed, 2 Sep 2009
• Count Distinct Values posted on Wed, 2 Sep 2009
• #REF error with Vlookup posted on Wed, 2 Sep 2009
• #REF with vlookup posted on Wed, 2 Sep 2009
• #REF with vlookup posted on Wed, 2 Sep 2009
• condition formatting not working posted on Wed, 2 Sep 2009
• How was this done? posted on Tue, 1 Sep 2009
• odd condition posted on Tue, 1 Sep 2009
• lost right-click posted on Tue, 1 Sep 2009
• compare cell data posted on Tue, 1 Sep 2009
• Question about SUMIFS(A:A,...) posted on Tue, 1 Sep 2009
• SUMIFS help page online? posted on Tue, 1 Sep 2009
• How to arrange alphabet and numbers in a cell posted on Tue, 1 Sep 2009
• Ranking data based on data in other cells posted on Tue, 1 Sep 2009