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