- disable copy & paste
- ODBC Driver question
- Excel 2000 exit button disables
- IMPORTING/READING A MATRIX OF COMPLEX NUMBERS...
- quatro pro formula conversion
- Help w formula
- Re: Excel Sorting
- Re: Excel Sorting
- Re: How do I convert negative numbers to zero?
- Re: How do I convert negative numbers to zero?
- Re: groupng sheets
- Creating List boxes
- Re: CONCATENATE Formulas
- complex: non-contiguous array formula - need syntax help!
- linking workbooks
- more conditions than I know what to do with
- counting qualitative variables
- linking excel 2000 to word 2000
- Re: Watermarks
- VLOOKUP difficulties
- Conditional Formatting
- Re: whats the solution?
- Re: groupng sheets
- Linking workbooks
- Re: Need a formula
- VLOOKUP type function to pull data from multiple sheets
- Re: inverting a matrix
- Re: Macros hate me
- Re: inverting a matrix
- Re: whats the solution?
- Re: Need Date and Time, Normal workday Formula
- changing text to numbers
- Excel file properties-statistics creation date
- lowest 10 cells of last 20 greater than 0
- counting cells
- Referencing Content of Other Files
- Book Suggestions
- Working with Excel and Visual Studio!
- 2 Field Comparison & Sum
- Nested IF with VLookup
- Re: References as part of a filename
- Size Limitation in Excel 2000
- Random Number Generation Question
- more efficent solution to 3-pass Vlookup
- Macros - Filling out a form
- what could a pull-down list be?
- counting colored cells
- Re: Macros - automated numbers
- Re: Macros - automated numbers
- Re: Between two dates
- Top three lines on every page.
- Re: Macros - automated numbers
- Re: conditional formatting
- Vlookup challenge
- Re: Entering Referece Cell Each Time?
- Counting w/ Multiple Criteria (Dates&Text)
- CountIF bas
- Conditional Formatting
- ???
- Leasing advance payments
- Walkenbach RipOff Books
- INDEX, OFFSET,..??
- Excel XP to Excel 97
- 希望Excel 2000中的记录单工具中有打印功能
- Re: Worksheet names in cell as text
- Selective charting
- Conditional Formatting
- Pivot Table Data used in an Equation
- Toolbar option
- Re: IF statement to check the formula in a cell
- IF statement to check the formula in a cell
- Summary by value
- Re: Worksheet names in cell as text
- Worksheet names in cell as text
- Summing of time Values Greater Than??
- copying multiple cells
- averages in a range of sheets
- Auto Update remote references
- formula that puts result in seperate worksheet
- Help with Forecasting Sales
- Re: Validation Frustration
- Toolbar Macros
- INDIRECT reference
- Re: Ranking into %
- Upgrade For Excel
- Re: Ranking into %
- Re: Ranking into %
- Paper size
- COUNTIF Function question
- Convert all formulas to values
- Freeze Buttons
- Re: custom number formatting
- Re: Excel 97
- Thanks and countif !
- Double lookup
- Hiding rows question. HELP!!!
- Formula repeats only in one sheet
- Re: custom number formatting
- Decimal place and rounding off issue
- Re: custom number formatting
- You guys are great newsgroups are great
- Re: A mistake in Office 2000
- Re: A mistake in Office 2000
- Re: A mistake in Office 2000
- Counting with conditions in Excel
- How to set up Return on Investment spreadsheet
- Pivot Table Access 2002
- Printing Column Headers in Excel
- Identifying Identical Cells
- Thanks! Success with Converting Scores to Grades
- Re: Excel 97
- Re: Validation Frustration
- Re: Validation Frustration
- Re: can Escel make labels in sequence?
- need help/importing to auto responder
- avergaing formulas
- auto-deleting a value
- Last non-empty cell in a column?
- Batch process a large number of values
- Find a specific value in a cell
- Conditional Formating Question
- Absolute references
- Help! Formula for AVG when group size varies
- Automatic Function Name
- CLEAN
- Autoincrements
- Hiding rows question
- sum by color condition
- help
- Re: Subtract time which cross 24 hrs in a single formula
- Re: Subtract time which cross 24 hrs in a single formula
- eliminate blank rows and columns after saving a worksheet
- Cell Display: Formula vs Result
- Re: Drop Down Menu's
- Re: naming sheet tabs
- #n/a - in vlookup
- merge cells
- function calling cell
- Hyperlink capabilities and limitations
- end of month date function
- compairing 2 lists
- Sorting Columns
- Data Forms
- Re: Absolute references
- Convert numbers to text
- Pivot Table - Summing
- Symbols
- Re: Automatic repeat
- "no more new fonts may be applied in this workbook"
- Re: Automatic repeat
- Re: Automatic repeat
- Re: NORMDIST NORMSDIST
- Time Variable (elasped time) calculations
- drop-down list
- validate data from list on other wrksht.
- Cannot sum imported numbers even when using paste special add or multiply.
- using dates and lookup functions
- Named ranges set by search return
- Named Ranges set by search returns?
- stepping through a range
- Named Ranges created by search returns
- protecting a worksheet
- Linking Information
- Re: Excel column headers
- pdf to excel
- Searching for duplicate numbers
- complicated Date function
- VLookup not working...Help ASAP
- Run-time error '1005'
- Get Row Number
- Colored cells based on dates
- Re: NORMDIST NORMSDIST
- Re: FORMULA RECALCULATION
- Template Wizard with Database Tracking
- merge workbooks
- Re: IF AND nested help?
- Cell Format - Date Options
- summing many arrays
- DataValdation from list
- Coloring worksheet tabs
- Re: Coloring worksheet tabs
- Pivot Table - Count wNo Duplicates
- Convert Visio 2000 file to Excel 2000 file
- fill in a series of date without holidays and weekends
- Adding a row
- Summary of values on a sheet
- Nested IF formula
- Re: Drop Down Menu's
- Drop Down Menu's
- Re: Drop Down Menu's
- exporting info to workbook
- Undo Actions Office 2000
- Lookup functions not working
- Maximize/Minimize/Close File Buttons Not Visible
- complex date affected conditional cell referencing
- trouble converting a 123 funtion into excel
- FORMULA HELP NEEDED
- DATA LOCKUP
- Accessing/Using Sum, Max, Etc on Status Bar
- Source cells highlighting
- Macro for my specific need
- Validation?
- SUMIF function doesn't work with "date less than" cell reference
- Re: check box verification
- Re: Paste from Excel to PowerPoint loses quality
- Convert to decimal time?
- Percent in Time formula
- Multiple cell concatenation based on lookup value
- Repeat
- Re: Can we delete the values in cell
- Re: Macro
- ScreenTip on scroll box movement
- Amortization / Loan Payment Schedule
- Re: Networkdays function
- Formulas DO NOT calculate by themselves
- Re: Networkdays function
- How to copy formula to a different workbook so it uses the new workbook's data?
- Baffled with a function
- Can I switch axes in a Worksheet?
- Sum with multiple criterias
- Re: Pivot tables
- sum values that are not errors
- Re: rounding
- Re: formulas for conditional formats
- Re: formulas for conditional formats
- Re: formulas for conditional formats
- Re: rounding
- Re: formulas for conditional formats
- formulas with a drop down menu
- Re: IF AND nested help?
- Re: rounding
- Error Message on simple formula
- Re: Negative Numbers
- Re: Array formula
- Re: Compare
- Re: Stripping data out of a cell
- Re: Stripping data out of a cell
- Re: Formula to input File Path & Name into Excel cell.
- Re: Formula to input File Path & Name into Excel cell.
- How to get rid of #N/A?
- Re: Compare "=OR(EXACT(TestValue, CompareRange))" Invalid Results
- Re: Compare "=OR(EXACT(TestValue, CompareRange))" Invalid Results
- Concatenate Function
- CONCATENATE
- Re: VLOOKUP and mutiple rows of data
- Re: Matrix multiplication
- calculating counts of dollar denominations
- summing with multiple criteria
- Re: Matrix multiplication
- Calculating dates based on Quarters.
- Excel Question
- Simple but tricky question.
- Re: Need help on match formula
- problem (excel bug?) using =HYPERLINK function in database query column?
- Excel Functions
- create macro when creating file
- formatting negative numbers
- Re: Negative Numbers
- Re: VLOOKUP do a "double" look?
- Receiving errors
- Re: VLOOPUP Causing Damsel Distress
- Grouping data based on cell input
- Worksheet function
- entering data
- Excel Query
- Protected Worksheet
- CHIINV - Degree of freedom error
- Re: UNHIDE "Very Hidden Sheet"!
- Formulas stop working
- Re: add rows to protected worksheet
- Re: add rows to protected worksheet
- hard hard hard to solve..............
- Cell references in sumproduct formulas
- Using cell references in sumproduct formula
- Re: Function help-Attn: Ron Rosenfeld in particular, please...
- Randbetween without duplicates?
- Change of file path
- "sampling - input range must be a contiguous reference"
- Can you nest a CONCATENATE within a VLOOKUP
- Help with Macro
- Marcos in Personal Workbook
- Re: unable to insert columns
- Hyperlink Problem
- Excel Questionaires
- Finding out the formula of cell.
- Dates and file conversions
- Re: Numbers change to dates suddenly
- Help with maps
- Protection options in XP compared to 97
- hyperlinks
- Re: Numbers change to dates suddenly
- Re: Help! I've Lost A1
- Re: can Escel make labels in sequence?
- Re: Employee Time Card
- Re: trouble with "<>" operator
- How can I do this using MS Excel ?
- pop up reminder
- trouble with "<>" operator
- autofill
- Round Function
- WEEKNUM for financial year
- Analysis toolpak
- Re: Help! I've Lost A1
- VLOOKUP with multple row returns
- Another if formula question
- Re: Help! I've Lost A1
- formulas don't work
- Re: Using the today command
- formula question
- Data Validation
- Re: Can we delete the values in cell
- finding the sum of filtered columns
- workbook protection
- workbook protection
- Re: COUNT Formulas addn.
- Re: COUNT Formulas
- Re: Error codes
- Re: Using the today command
- Function
- Re: generating random numbers
- Help counting dates
- help. needed with comparing 2 cells see message
- Help
- Help me! Adding number/text combos
- Rounding time
- Multiple Criteria
- IF problems
- Re: Folders instead of tabs
- Ignore a 0, or formula
- Omitting blanks in column data
- If format Question
- Replacement in excel... (or is it substitute)
- INDIRECT() FUNCTION
- INDIRECT() FUNCTION
- Change Colour Of Tabs??
- temp (perm?) solution...suggestions?
- MERGING TEXT FROM TWO CELLS INTO ONE
- Require a cell to be completed based on another cell's value
- Combining cell info
- columns
- Excel 2002 - Can this be done?
- Autofill A Non Contiguous Formula/Series From Another Sheet??
- Getting data from list
- Shortening Formula
- Updating cells in a lot of Excel files
- Macros
- Conditional Formatting
- date format with st nd rd
- Timesheet cost code grouping
- help with hyperlinks
- population age distribution
- How do I search for a wildcard character?
- Macro (assigned to button) doens't work when sheet is protected
- Help with formula
- split time format
- Re: Find with multiple worksheets
- Selection too large
- Error - Formula too long
- Re: can Escel make labels in sequence?
- Excel Formulas and Imported Text Files
- Re: Auto calc producing intermittent 0s and real values
- URLs
- Is this possible to do?
- Macros
- Need code check
- Can this be done??
- Check code
- Re: Help please: Saving an excel file
- Re: shared workbooks
- Re: Find Nth occurance of a substring in a string
- Re: Find Nth occurance of a substring in a string
- Using excel to schedule
- Rearranging Data
- Re: generating random numbers
- Re: Find Nth occurance of a substring in a string
- Re: Find Nth occurance of a substring in a string
- Re: Find Nth occurance of a substring in a string
- Rounding up causing abnormal/inconsistent results
- Re: Find Nth occurance of a substring in a string
- data validation
- Using variables in cell numbers--ACK!
- Macro Icon
- Re: Auto Sort
- Median function not working
- CF
- Register.ID
- empty cell find and put in 0
- Re: Simple (?) Question
- Calculating Working Days
- Changing a Name in a cell
- cell protection
- Re: Covert Text date to date
- how to keep a sum above 0 and below 6000
- Read Only
- hyperlinks!
- Re: Data Validation
- calculating productivity
- Finding duplicates
- Re: how to keep a sum above 0 and below 6000
- Calculations with text
- Excel calculation engine
- Making the Drop down box move with the cell
- Sum the values in a Column depending on values in two other col.
- Help with formula
- worksheet protection
- Filtering downloaded data
- Re: Copying the Sum listed in the status bar
- excel crashing for no apparent reason
- Re: Word numbered outline import into Excel
- Split text into 2 separate columns
- Converting Numbers to Time
- SumIF Function.
- Auto-SUM Not adding correctly
- Unable to Read Files
- Re: Data Validation - Non-Blank Cells
- Switching Excel Links from Windows 2000 to Windows XP
- Re: Covert Text date to date
- Cannot set cell format
- Linking to another worksheet
- Re: How to tell whether a cell contains a formula in a Macro?
- Formatting
- Combining text in excel cells to create a formula
- auto link to cells on different workbooks
- How to hide the function cell when there is no value in the referenced cell
- Exporting to Outlook
- Hyperlinks
- Re: formulas
- Re: Sum of digits within a cell
- Cell referencing from sheet to sheet in a workbook
- Cells Don't Update
- Formula related
- read only
- What-if Tables
- Re: formulas
- Max number of rows and columns
- Re: count function
- cell protection
- If Statement
- Data validation Drop Down Box not showing
- comparing data in 2 columns
- Count Unique reocrds in a pivot table
- count function
- How to group TIME (seconds, minutes)?
- Vlookup
- copy worksheet
- hide
- Re: highlight the whole row
- Re: highlight the whole row
- Appending Col automaticaly
- how do i insert a tick
- StartDate < 20th Dec. StartDate + offset > 20th Dec.
- Cell Fill Colors between Worksheets
- Re: Pulling values from multiple sheets - very slow
- formula problem
- Amounts double
- Re: Protect/Unprotect Multiple Sheets
- Values between Work Sheets
- Can I automatically tab to next cell?
- Copying filtered, merged cells
- AND errors
- average if
- Exclude Null Field in Formula
- Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
- PRINTING LABELS
- Re: Average IF problem
- Round number in a range
- Re: check data for valid entry
- Hyphenated zip codes in merges
- Named Formulas
- Re: Date Calculation
- Re: Date Calculation
- Re: Date Calculation
- Re: MINVERSE function
- Format date
- Re: depreciation
- display date
- VLOOUP error
- Count Using Nested "COUNTIF" Statements
- Problems installing and uninstalling windows xp.
- LOOKUP function help
- Retaining individual character colors when parsing
- pivot table
- Re: MINVERSE function
- GETPIVOTDATA
- Determining an equation from a dataset
- Need formula
- multi-conditional If Statements
- Re: count function
- Displaying the Saved date and time
- Searching values from table
- Can Excel count cells with formatting like colour fill?
- Re: How to import more than one text file into Excel ?
- Define Macro
- Custom Views
- Re: Conditional formatting using an array
- Breaks
- Importing into Excel
- Another problem....
- Re: Database functions
- generating random numbers
- Automatic Update of Several worksheets - Link?
- Re: If value in T use it, otherwise, use R ...
- Re: If value in T use it, otherwise, use R ...
- Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
- Re: generating random numbers
- Excel formula
- Re: Sorting Odds & Evens
- Re: Needed Counting Function
- Re: How to import more than one text file into Excel ?
- lookup,index-match,or-and-if type issue
- Re: Needed Counting Function
- How does one find and delete a link?
- Need to work out an average
- Returning values based on "if"?
- Re: Needed Counting Function
- Re: Sorting Odds & Evens
- Re: Needed Counting Function
- Re: Needed Counting Function
- Re: addition of time
- problem
- Re: Sorting Odds & Evens
- Last Entry
- tally by clicking cell
- Pulling info from one worksheet over to another by date range
- Lookup
- Name Box
- troubleshooting
- Re: Last Entry
- Need to recapture previous Excel File
- Lines-styles
- Range Names Help
- Gradebook: Score = Grade
- lookup or vlookup
- SMALL HELP WITH SERIES
- Re: Status Bar quick arithmetic feature
- Input editing and summing greater than space
- Numbers & Mathematical Calculations
- Formula to Label Cells
- Re: Time Distance & Speed
- Solver does not start secone time
- Header Format
- Re: Weird cell numbers
- SUBTOTAL, INDIRECT and ADDRESS functions
- Re: center and merge
- Re: Time Distance & Speed
- Column/cell protection
- pagenumbers
- excel spresdsheet
- Date affected cell referencing
- Re: Still NEED Help PLEASE! Finding Cells with the same Data
- DATEDIF
- Datedif
- Moving e-mail addresses from columns to rows
- MyTimeCols
- Re: script help!!--conditional formatting
- Re: finding last value in range of cells
- Re: Macros
- Currency Formatting
- Re: Can EXCEL remove duplicates and separate by color coded items ?
- Re: power fit
- Any Given Monday (counting them)
- Time Stamping a cell in Excel 2000
- Re: function to paste two cells into one
- How to select an amount of a given period ?
- Re: function to paste two cells into one
- VLOOKUP - Function vs. VBA??
- Re: re-organizing data
- date validation
- Convert date from YYYY/MM/DD to MM/DD/YY
- enter data to specific cell
- Re: Identify/Highlight duplicate items
- protect formulas within a cell
- text to column with embedded special character
- Separating e-mail addresses from one cell
- Re: protect formulas within a cell
- Protecting Cells in Excell
- Please HELP w formula (posted earlier)
- age formula calc
- short character limit when creating database
- how to include formula
- Re: Solving for Variables
- Re: Excel
- lock one cell if data entered in another
- pivot tables
- How to identify and convert a yyyy/mm/dd date to mm/dd/yy
- need help on "lookup" formular
- Loss of Autofilter
- Identify info that is duplicated in a column
- Converting the #N/A value with an IF STATEMENT
- Sum Columns with #N/A
- Remove Characters
- Need a way of retuning a fixed value from an adjacent calculated value column
- Re: Changing Row Color
- Re: finding last value in range of cells
- Re: Changing Row Color
- Changing column/row heading color when a cell in that column/row is selected
- List
- Re: Anyone know about putting pdf's behind a cell in excel?
- Indexing across tabs
- additional note
- Re: HELP - Pivot Table question
- Re: Formula that returns the smallest non-zero number
- Re: Copying function result to a new sheet..
- Re: Please HELP with formula
- Rounding to a multiple of a decimal
- rounding to nearest 5 or 0?
- Display Variance in Pivot Table
- Formula's
- can't find cell containing link to external worksheet
- Formatting cells
- Re: Solving for Variables
- Re: Excel Exact function error
- Re: Function Question: Excel,Month, count
- Re: Solving for Variables
- OLAP Cubes
- Re: Please HELP with formula
- Excel - Calculating total based on different font color of the cell
- Re: convert multi columns to two columns
- Please HELP with formula total S/B $113.58
- Re: Formula that returns the smallest non-zero number
- SUM Function returns Zero in Error
- Column of Dates with ( ) - delete ( )?
- automatic solver in realtime
- count rows by font color
- Re: opportunity
- IS THERE ANY WAY TO ROTATE A TABLE (which has applied formulae to the cells)?
- Re: max number of worksheets in a workbook
- Re: Will VLOOKUP match text w/ non-text values?
- Re: Will VLOOKUP match text w/ non-text values?
- Change h:mm to Chargeable units
- Re: HOW TO CONVERT WORKS SPREADSHEETS TO EXCEL
- Re: convert multi columns to two columns
- how to keep text from moving when typing
- proteced sheet can be edited
- Question about Arrays
- Macros to create a number of charts
- VLOOKUP Challenge
- Help w/ spreadsheet
- formula doesn't display result
- Using a between function
- Dates in Query
- SQL.REQUEST on SQL Server
- How to add the 4(say) largest numbers in a column
- Probably a stupid newbie question that's been asked bizillion times about summary subtotals
- Duplicate records
- Substraction error in Excel
- absolute addressing
- If is not null, shade red
- SUMIF
- Re: Determine calendar quarters
- Re: Custom Menu Bars
- Compare two values if there are gaps in the data series
- Re: Average Annual Percentage Rate (AAPR) formula
- Re: Arrays in Excel Functions: Practical and Theoretical Question
- Re: Newsgroup message retrieval
- Re: Status Bar quick arithmetic feature
- Numbers formatted as text
- How can I get this to work
- script help
- Conditional Formatting based on 2 cells
- Re: Arrays in Excel Functions: Practical and Theoretical Question
- Re: Determine calendar quarters
- Can't see all cells XP
- Script help!!
- Re: Arrays in Excel Functions: Practical and Theoretical Question
- SaveDate function?
- Re: Arrays in Excel Functions: Practical and Theoretical Question
- Re: Changing a cell to 0 if another cell is null
- Re: Add several years to a date
- pictures in excel
- Trying to get a blank cell.
- Drop-down menu button doesn't appear for data validation
- Scoring cells in a column of text
- Highlighting same text within a spreadsheet
- Re: adding cells
- dual axis chart
- Re: using conditional functions to change backgrounds
- Passwork to look at code for Invoice1,xls work sheet
- Re: MEDIAN of only positive numbers
- Re: Add several years to a date
- Changing a group of neg #'s to positive #
- Re: Add several years to a date
- Need the total count of a value in a column
- create and print a blank spreadsheet with gridlines
- linking workbook cells
- when pasting row I am prompted to save as...
- Re: MEDIAN of only positive numbers
- run time error '9' - subscript out of range
- VLOOKUP problem
- Comments For Buttons
- Re: Auto numbering in Excel
- Is there a way of searching in Excel for cells which are "Bold"?
- Array problem
- Function Help,????
- If Statement to change the cell shading,
- Excel 2000
- Setting up math formula to solve for variable in Excel
- Excel Question
- Linking sheets
- Re: Newsgroup message retrieval
- Re: Import Data Containing Carriage Return
- #div/0
- Hiding Menu Bar
- PivotCache Question
- Re: Newsgroup message retrieval
- Social Security Formatting
- Fill in Excel...
- Column width formatting
- Re: whole numbers/absolute values
- Need the total count of a value in a column
- Re: Need the total count of a value in a column
- Implimenting a shift in a power trendline graph
- Excel 2000
- Re: Determine calendar quarters
- Re: Determine calendar quarters
- Global numeric change
- Re: Determine calendar quarters
- whole numbers/absolute values
- Conditional Formating
- Worksheet Functions
- Re: Excel 2000
- Delete Sheet Menu Item
- Re: Excel 2000
- Re: DATES: HOW DO I ADD ONE DAY ONTO A DATE?
- Re: Conditional Formating
- Formula help, Please....
- Pivot table calculated item across records
- Referencing a pivot table
- Re: Switching cells
- Re: whole numbers/absolute values
- Re: VLOOKUP
- Re: Tim Otero
- How to get the value in the last filled cell of a column
- Re: Worksheet Functions
- Re: search and replace function
- Counting Number of Worksheets in Workbook
- Re: how to refer to an article? where are they ?
- Need Percentage of P, F, N in a column
- Inserting filepath and filename
- Simple conditional formula
- Re: how to refer to an article? where are they ?
- RE: How can make a table
- Re: How can make a table
- Re: Lost an Excel function
- Needing Formula
- Re: Average Annual Percentage Rate (AAPR) formula
- Re: Lost an Excel function
- Original question
- Need Help With Lookup & Indirect Function!
- Calculating average of range of cells which keeps moving