- weeknum function
- absolute reference while copying data from the pivot table
- Re: Convert inches to ft, ins & fractiions
- Re: Networkdays
- Re: date display on a New Year
- naming worksheets
- Re: minimum formula
- Integrated phase noise
- Re: Convert inches to ft, ins & fractiions
- Re: Open Excel in a Default Worksheet
- Countif function over more than one column
- Formatting columns with csv files
- Re: Excel Date Format
- Re: Open Excel in a Default Worksheet
- Saving Info.
- Text Question
- week number for financial year
- Excel Templates
- Using SUMIF across several spreadsheets
- office xp rounding of the 16th number
- linking worksheets and copying formulas in cells
- How to copy formula?
- Pivot Table - filtering column information
- adding two fields if one is blank.
- variable cell reference
- Re: Finding duplicate entries
- sum function; 0 vs. 0.00 vs. (0.00)
- Re: Day stamp
- VLookups
- Re: cell marker
- Re: FUNKY Array formula
- Re: Linking Multiple Worksheets in Excel 2002
- Sumproduct
- Cursor highlighting
- PERSONAL XLS Macro will not load
- Subtotal function
- Macros will not run in Office XP
- marker for cells containing a formula?
- Re: Auto-Filters
- Re: expanding graph
- How to capitalize all words in a spreadsheet
- Re: How to capitalize all words in a spreadsheet
- Sort
- Re: Referecing Pivot Tables
- Re: Trouble with Vlookup
- #VALUE
- Calculating Time Differences
- Importing Data
- More than 256 columns
- Openning the same document twice in Word and Excel
- One column list
- Re: ALL CAPS
- Re: ALL CAPS
- Re: ALL CAPS
- Re: ALL CAPS
- External driver
- Conditional sum with multiple criteria
- time card
- e mailing seperate parts of a sheet
- making sure empty cellsa are empty?
- Cells will not always recaculate with Auto Calculation turned on.
- Re: Creating a summation formula that excludes the high and low
- Calculations
- copying pages.
- Re: Lookup Function with Multiple Choices
- Re: Lookup Function with Multiple Choices
- Need Date to NOT advance the day after entry.
- Re: Lookup Function with Multiple Choices
- Re: Creating a summation formula that excludes the high and low
- CELLS linked to another workbook, cannot edit - HELP!!
- Finding named ranges
- setting up worksheet to open at the top
- Many Thanks
- Categorize a list of values?
- Excel Problem
- Rank using VLookup?
- Re.MultiLookUp
- Function correspondence table
- How to save excel file when pc hang or illegal operation?
- IF Function
- create tag sheet for time and volume of customer service requests
- SubTotal Function
- Re: IF Function
- edate will not resolve
- SubTotal Function - Too complicated
- Help with a formula
- Re: excel cells
- Formula help
- day of week
- Re: Version Number
- Re: Version Number
- formulas not calculating
- Text Wrapping in Excel
- code to increment a cell!
- reference other cell in criteria
- Re: Feet, inch, fraction to Decimal conversion
- Conditional format based on format of another cell
- function help
- Finding and replacing multiple entries
- Re: Need to multiply B by C into D for 284 rows
- Need to multiply B by C into D for 284 rows
- Re: Feet, inch, fraction to Decimal conversion
- Re: add some cells and not others
- Re: add some cells and not others
- text wrapping
- Re: Copying pages
- Calculations over multiple cells
- Spreadsheets not functioning well on WinXP OS
- Rounding minutes to nearest hour
- copy formulas down non- adjacent columns?
- Adding Commas to Existing text
- abolute value between worksheets
- Re: Adding Commas to Existing text
- changing positive to negative numbers
- Error in formula
- Capturing realtime data off the internet
- Networkdays functions - holiday
- Re: Networkdays functions - holiday
- "IF" function returns error when using arrays
- Entering Dates in Cells
- Re: absolute reference
- a limit on sum calculation?
- Re: absolute reference
- Re: Conditional Sum missing { }
- Re: Transfer data between sheets
- consolidating
- ignore worksheet name?
- Re: Problem in formula concatenate
- countif cell is shaded
- Conditional Sum
- formula
- How do I insert a function on a subtotal row?
- Play a sound or open a WAV file
- Lookup Help
- index match problems
- Re: Networkdays functions - holiday
- Re: Counting Value
- Re: Newsgroups search function does not work, why?
- Re: Counting Value
- multiposting and crossposting
- Re: Computing an average that excludes error message
- TIME / HOUR formatting & calculating
- IF STATEMENT
- Re: Copying pages
- if statementd and ignor ing formulas returning ""
- Re: Lotus formula conversion
- Re: Problem with dragging a formula to cell in the next adjacent column...
- Date Last Saved Function?
- Text limitation within a cell
- Re: alphabetizing
- running macro in a cell
- Re: Drop down categories
- text function
- add a digit
- Excel paste disabled
- formatting before concatenation
- Changing Default settings for Opening CSV
- raw data formating
- sorting 3 criteria
- text display
- Timeclock: rounding hours up and down
- Re: Merge and Center icon is grayed out
- Re: "If" function
- Trim Function
- "If" function
- Re: Formula is too long
- Formula is too long
- keeping text superscripted when merging it with text
- Re: Problem in formula concatenate
- Macro to search for matching columns
- Re: Start up procedures- HELP!
- Re: Formulas that included checkboxes
- Rank Question
- Popup messages when different scenarios are selected
- changing numbers in a formula
- Cell Formatting
- Lookup with 2 variables
- Re: Specific data tranfer within a large worksheet
- Inserting copied cells
- Pivot tables
- Time Stamp
- Excel 2002 SP-1 date formatting
- CALCULATING MINUTES AND HOURS
- Re: Start up procedures- HELP!
- Shortcut Keys
- Search this newsgroup
- Formatting a cell using a logical function/test
- Reports
- Calculating Ratios
- unique values only
- Sending Excel worksheets in the body of Outlook 2003 email
- replicate a character
- XIRR Function
- updating access link in excel query
- Re: Sum Function
- Re: Create a dropdown for a column
- Removing Text from numbers
- Setting Tabs in Excel
- Re: Words from Numbers
- VLOOKUP
- NESTED IF's too many
- Re: Trend Lines
- Converting files to Excel Spreadsheet format
- changing cell value
- Please help
- RAND function
- grouping in pivot tables
- AdvancedFilter VBA Adjustment
- Vertical Lookup data not sticking
- Text Delete Macro
- Lock Formulas
- reference cell
- Re: alphabetizing
- Keeping Formulas Results
- retaining font format after text merge
- Updatings Links to Data nad Formulas
- Vertical Lookup data not sticking
- personal views & sharing workbooks
- Re: Create a dropdown for a column
- Replace number in formula by position?
- Re: Words from Numbers
- Re: Find and Replace command.
- Match formula?
- Re: protected worksheet
- working with XX:XX entries
- Inserting rows
- Drop down dissapears
- Re: Multiplying values only if cell contains data
- Excel - Date/Number
- incorrect multiplication by excel
- open text function in VB macro after double click
- Sequencial Numbers
- Percentage Change
- Simple formulas
- Return combos of #s located in col which add up to given #
- watermark
- Deleting Blank Rows in Excel
- Max with criteria
- Re: Internal Rate of Return
- Re: Internal Rate of Return
- Changing Text to Number Format
- Summing
- Excel DSUM problems
- Re: replacing digits
- Re: replacing digits
- Excel 2002,Cell format, General in Category list.
- Excel Pattern Formula
- Re: saving
- Subtotals
- How to save excel file when pc hang or illegal operation?
- Turn OFF the Collate printing
- Products and subtotals
- Re: Vertical Lookup data not sticking
- Re: importing csv file
- Tab sheets
- Re: Data Validation
- The fx button
- Re: New Macro-function
- Re: comment boxes
- Before I get started
- Symbol Hyperlink
- Spanish --> English functions correspondence
- Conditional Formatting
- Display day of a date
- Having problems, please ignore this test
- Conditional Formatting
- Calculating VAT at different rates
- Excel - Consolidation of several sheets in a workbook
- Excel - Consolidation of several sheets in a workbook
- tertiary Y-axis?
- tertiary Y-axis?...oops...wrong newsgroup
- shading cells as the output of an if statment
- Using >CELL in SUMIF Criteria
- Re: INDEX or something like it??
- How to do things in Excel
- Disable Menu Items
- return larger # w/vlookup
- Countif
- Adding a decimal
- Vlookup error when exact match is represented
- Re: List checking
- List checking
- Macros
- Excel 97 and XP
- Pivot table grand totaling
- Re: Time and Date Calculations
- Re: Time and Date Calculations
- Pivot counting
- Macro Editor
- Re: Time and Date Calculations
- Creating an Editing Macro
- Need Resource for creating a worksheet for data entry / pull-downs/radio buttons
- How to enable a macro
- Pivot table format
- Character Count
- Re: keyboard shortcut for autofill
- Validating a date
- protection & macros
- Re: Compound Interest
- protection & macros
- Re: INDEX or something like it??
- Date Format Problem
- Another macro question
- IF function
- Re: Excel format numbering
- Re: INDEX or something like it??
- Re: List checking
- Clipboard
- sum formulas returning ""
- Automatic Data Sort?
- Creating a running total - using "x" to populate field
- VLookUp question
- Is there any way to go beyond column "IV"?
- Creating an Editing Macro (Still Searching for Help)
- Multiple Optimal Solution using Excel Solver
- Re: different footers on pages
- Re: Worksheets
- sum formulas not returning correct value
- Re: List checking
- How to do record in Excel
- Re: different footers on pages
- Use cell content as cell address
- Rounding numbers then doing a sum of those numbers produces incorrect result.
- Calculation of distance
- Removing trailing spaces.
- Formula
- Hide rows
- sun function
- Subtotals
- Hide Objects With Hide Rows Feature
- Limit Scrolling
- Re: Calculate Figs Proportionately
- Re: Validation function question ?
- Re: Formula Palette???
- Excel TRIM function
- Help with sort and subtotal
- Validation list
- Printing gridlines
- Time Conversion
- INDIRECT Function
- Comparing Columns of Text
- Re: Comparing Columns of Text
- Re: Worksheet Passwords
- Unprotect my Spreadsheet
- Re: subtotal formats
- Re: MEMORY
- Re: Worksheet Passwords
- SMALL function in EXCEL
- Formula that returns the smallest non-zero number
- Re: Subtotals
- urgent help needed for database function!!
- Re: Nb of a cell updates
- Splitting data
- Reference to another workbook
- worksheet in xp home version 7.0
- Auto-fill last empty cell in column
- lottery: Excel formulae required
- Count matching cells
- TRIM toolbar icon
- instead of forula result I see formula
- Cell Formatting
- Name throwing up address etc...
- Re: Running average
- Re: Running average
- Running average
- Re: Running average
- searching comboboxes
- Absulute Value
- Sum If functions for alpha results, Using "fill" multiple worksheets
- assigning variable value
- Rounding
- Extract unique values with criteria, and sort them
- access denied on excel file
- Auto copy info from a cell to another worksheet
- Print Question & Overtime Question
- Re: convert seconds into minutes
- Re: convert seconds into minutes
- Re: convert seconds into minutes
- Re: convert seconds into minutes
- Re: convert seconds into minutes
- Re: Printing Question
- Time Question
- Re: scanning spread sheets
- Re: Auto increment.
- Re: Printing Question
- Re: how make zero default for every cell in column?
- Re: Syntax for a 3-D Reference with dynamic cell selection
- Q: How to make "whole" numbers?
- Re: Syntax for a 3-D Reference with dynamic cell selection
- Excel help with a bowling score sheet formula
- DATEIF function
- Re: Worksheet Passwords
- Re: Make all numbers positive?
- Re: Make all numbers positive?
- Q: How different colum-widths?
- Count worksheet with specific value in a cell
- Annoying Format Cells Problem HELP!
- excel 2000
- event macro
- If I write numbers in C4 sheet1 I want to copy
- Re: Excel Functions
- Re: "If" function
- function using cells from multiple worksheets
- Hard Line feeds characters within a formula
- Re: Microsoft Excel 2000 software
- Re: random time
- Re: random time
- Removing Macro Icon and Menu List Iten
- Worksheet Tools Option failure
- Help with Macros
- Use INDIRECT to calculate a sheetname
- Re: Adding worksheet using macro
- decimal roundoff function on worksheet tool options
- Re: Q: Make all numbers positive?
- Conditional formatting
- wildcard search within formulae
- Count data
- Re: Counting networkdays between two dates
- Column Division
- counting coloured cells
- If function and counta
- Re: Adding worksheet using macro
- Comparing data between worksheets
- Frequency Function
- Compare, match and fill
- Re: Frequency Function
- Re: Frequency Function
- Macro Security
- Subtotals
- Renaming files in excel
- Re: different footers on pages
- Selecting Multiple Values from a List
- adding sheets to workbooks
- Running total of single cell.
- formulas in excel
- tabulating similar data
- Sheet layout problem using existing data
- Re: Counting networkdays between two dates
- Data manipulation
- Re: problem with division on Excel
- Hyperlink problem in Excel 2000
- Re: problem with division on Excel
- Re: problem with division on Excel
- Pick from list
- creating a drop-down list in a cell (NOT a combo or list box)
- How can I ignore "" in a formula?
- calculating time
- worksheet tabs
- Controlling the refresh of imported (linked) data
- Pivot Table - Don't want sums
- Conditional formulas?
- Re: sum formula not adding
- Formatting is lost when linking worksheets
- Merged Cell not showing all data
- XIRR Function please help me
- Excel 2002 BUG
- Solving a problem in excel
- Too many different format cells
- Compare columns
- Test for blanks in range
- 30 Day Summary
- Opening Excel file from Outlook
- How to remove the formula but leave the value
- Re: Sheet reference using text name
- SUMIF
- Help with SUMIF formula
- Sorting worksheets in workbook
- Re: MEMORY
- combining/compiling multiple worksheets into a master
- calculating from combined worksheets
- Re: Q: Make all numbers positive?
- Sharing Macros (PERSONAL.XLS)
- need help with a formula
- Re: Search for line feeds
- Comment Boxes on Cells in Grouped Lines
- Text Function ?
- checking if text matches entries in a custom dictionary
- Re: hide formula
- Re: hide formula
- hide formula
- Re: hide formula
- find Line feeds
- Re: Conditional Formatting
- Re: Conditional Formatting
- Re: Sheet reference using text name
- rounding to 5 cents
- SUMIF not summing
- time total and shell blank
- Wrapping text
- different footers macro
- ODBC Drivers error #-2147217900
- Help me with Dates in Excel
- Multiplying values only if cell contains data
- Maximum characters per cell.
- Pivot table sub totals
- Converting Lotus .WK4 files to Excel format
- Re: duplicate numbers
- hidden rows
- Problems with Combobox
- Help for User Defined Functions in Excel 2003 Beta
- Delete repetious rows
- Showing data either side of '/'
- Fiscal Calendar Week
- Dialog Box Buttons
- Conditional formatting
- LOOKUP function copy as ABSOLUTE
- Graphing - Trendlines Help
- Apologies to all
- Re: question about newsgroup "timeliness"
- Re: question about newsgroup "timeliness"
- inpur problem
- skip a data
- Re: Search for line feeds
- Pivot Table Help
- Array Formula problem
- Sampling
- Fiscal Calendar Week
- Looking for an Excel function
- How to input the angle data
- Chart ponits
- "Help" with Macro's
- Data Analysis Pack - Correlation
- Self Assessment tests...
- Re: Creating Circular References
- Creating a list
- Re: Creating Circular References
- RE: Conditional Formatting
- Column to Row
- Fiscal Calendar Weeks
- Re: I Cannot Count
- Summing Vlookups together
- Lookup and Sum
- conditional data entry
- Setting an alert of warning for duplicate date entered
- Number to text
- Column subtotals
- excel97 subtract two dates to find number of days
- How to Open Excel to a specific tab via the IE browser
- Populate blank cell with "0"
- Moving columns in multiple worksheets
- Inserting floating boxes complete with formula/cell referencing
- Re: I Cannot Count
- Trim Hard Returns from String
- Need a function to add the sheet name to a cell.
- Keeping a Date in Excel
- Selecting a combination of values, who's sum equals a specific value
- setting a cell to Blank or Nontext or Null
- adjusting a recorded macro in edit mode
- 3D array
- Re: OFFSET and MATCH Functions
- Sum Arrays
- adjusting the range of cells in macro
- Sum Arrays
- Worksheet function
- VB checkbox fore and backcolor
- function help
- Re: not equal to
- Re: not equal to
- Tallies
- Re: Counting yeses and nos
- Protect cells between versions?
- Adding last three entries
- Re: Linking two sheets (with formulas)
- Re: Adding more colors to the Excel "cell fill" options
- Cross reference from one workbook to another
- time total and subtraction
- Nested IF function
- Re: LOOKUP HELP
- Re: countif from two columns
- Division by decimal
- documantation control file
- Re: Adding last three entries
- Re: Matching a cell in a non-ordered table
- Function to reduce date by 3 months
- Matching a cell in a non-ordered table
- Re: Matching a cell in a non-ordered table
- Re: collect previous value
- Pivot Table Help
- Pivot Table Help
- time total
- time total
- time total
- time total
- time total
- hint on worksheet tab name
- Time conversation
- Countif function
- Can I formulaically set a cell to blank (non-Text, no value)?
- Re: Rand() w/o repeats
- Dates
- LOOKUP function copy as ABSOLUTE?
- Rounding in Excel
- List Question
- Filling Cells
- Re: copy formula to different worksheet
- Combo Box
- Re: duplicate numbers
- Tough Sumproduct Question
- Re: Rand() w/o repeats
- excel97 True False formula not reading cell value correctly
- Counting the results of a filtered list
- Excell Spreadsheet Problem
- Forgotten Password on a worksheet
- counting cell based on font color
- Hyphens
- Solve Order in Pivot Tables
- Drag function
- Formatting Excel Workbook via external application
- Re: macro to color cells
- Formatting Text In Combo Box
- Moving between worksheets
- Double-clicking a formula
- Programmatically Email one Sheet from a Workbook
- Sheet tab name on two lines
- Need a formula for counting highlighted row colors
- Calculate Invoices Based on Dates
- Referencing a function from a different cell.
- RETURN FORMULA
- Calculating Time & A Half On A Time Card
- Re: Enable spell-check on a protected worksheet
- conditional formatting & countif
- Custom number format: decimals
- sum formula that includes zero?
- Time Stamp
- Re: Using "SUM"?
- Match Formula
- Re: Using "SUM"?
- Re: Using "SUM"?
- Re: Using "SUM"?
- help with functions between sheets....
- Insert Function
- This is a toughey guys.
- Autofilter Does Nothing
- Use value in a function
- vlookup returning #n/a
- Re: I make the leaf of report with a macro?
- Macro Help
- disable removal of leading zeroes
- GETPIVOTDATA - Date
- Please Help!
- DSUM and External Data
- separate data from one column into two
- sum with vlookup
- Forecast Function
- excel
- using alt+tab in one cell
- Can't use formulas within formulas?
- E-Mail use in Excel
- renumbering rows in excel
- making a combo selection in a cell
- Distinguishing between upper & lower case characters for vlookup .....
- Sheetname = Cell content............ is it possible?
- Print Titles
- Creating a form
- Formatting phone numbers in Excel
- Re: TEXT WORKSHEET FUNCTION
- making changes to copied cell appear in original cell/
- Re: Ignoring other functions
- Re: Ignoring other functions
- Re: User-defined function with ABC.XYZ name format
- References in formulas
- Adding Two columns
- Removing key strokes
- FileSearch in Excel 2002 in WinXP
- Re: AUTOMATIC FORMATTING
- Re: Customing formatting to do fixed decimals
- Reference to a tab
- Formula's and dates
- Finding Their Age from Date
- Using workday and networkdays to return project start date
- keeping a cell a constant
- Sumif between two date ranges
- If Function
- Re: FileSearch in Excel2002 on WinXP
- Sheet protection
- Re: Date Chip Pearson?
- Data Validation
- Solver and Integers.
- protecting formulae
- Busy week of the month
- worksheet
- Re: Vlookup Reference Cell
- Break apart data of one cell into two cells
- Re: Vlookup Reference Cell
- Workbook Password
- Re: Matrix Inverse (MINVERSE)
- Formula not adjusting to correct cells
- Re: Matrix Inverse (MINVERSE)
- Use Arrray or else to find unknow
- Re: Vlookup Reference Cell
- Visual Basic
- Cell Editing Macro
- Re: Conditional Formatting ?
- comparing columns
- Re: Need some magic here...
- need to test existence of a value in a cell
- countif function
- Add the number of people in a certain age group
- Intercept
- Being prompted to refresh linked data
- Very Critical....Pls respond
- Matching fields in worksheet
- Re: IF statement and blank cells
- Data Validation and COUNTIF
- convert all dates
- Re: FIX indicator
- Pipe Delimited Importing Text Files
- and/or statement?
- Re: Quad combinations
- sum if string is a certain length?
- Deleting Rows in Protected Worksheet
- Annualized Growth Rate Formula (Rate Function Plus)
- Re: Help! Formula to select data between 2 dates.
- ?? About Pivot Table
- Converting all caps to regular case
- If problem????
- Copy of protected document unprotected in 97, but protected in 2002
- Viewing two worsheets from the same workbook at the same time
- CONDITIONAL FORMATTING (COLOR)
- Re: Data Validation: List Formatting
- Re: Error message when adding a worksheet to a workbook.
- Change Button Color
- Re: Passwords in excel
- Re: COUNTA excluding cells with a formula
- calculating a compound annual growth rate
- Re: Create Combo Box
- Macro
- finding duplicate entries?
- Sumproduct and/or summing array with multiple conditions
- convert matrix to a string
- convert matrix to a string
- Re: Comparing spreadsheets
- fixing problem
- Value of ""
- No Horizontal Scroll Bar To Access Worksheet Tabs
- Re: Date Entry - XL97 on XP
- Re: Date Entry - XL97 on XP
- disable read-only on a protected worksheet
- AUTOMATIC FORMATTING
- Autoformat
- NETWORKDAYS
- Excel '02 doesn't use previously saved data when link fails
- HELP: flipping up/down or left/right
- Re: Passwords in excel
- Auto-save
- date
- Data from Word form to Excel?
- Conditional Formatting
- Forecasting Functions
- adding a function for multiple cells