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