- REPOST - Detecting missing values in a sequential list of numbers
- Dropdown menus in Excel
- Re: Calculating Time & A Half On A Time Card
- Averaging a range
- Re: reducing data using a formula and not a macro
- Row/Column Heading Name
- List Selection
- conditional format &VB
- Adding ROUND formula to a selection of cells
- Two-variable chart look-up
- Compare values in two columns
- Re: Front_End
- MATCH
- Help using INDIRECT or something like it
- Re: Conditional formating
- Re: Resource for using Goalseek function
- SUM Function with Multiple Conditions
- Re: Two-variable look-up revisited
- Countif Command
- Re: Two-variable look-up revisited
- Two-variable look-up revisited
- Re: Searching
- Re: How to Determine Number of Monday's in 2004
- Re: CALCULATION PROBLEM
- option buttons
- Re: Excel XP - Password Problems - French Language Setup
- Conditional SumIf
- Excel 2000 Worksheet Columns
- Excel 2000 Worksheet Columns
- Function to find a number
- Maintaing Cell References when using Sort Function
- Re: work with if function
- work with if function
- Re: Concatenating date fields into text
- Ignore original message
- "Pick From List"
- Links
- Re: Dynamic file reference?
- Re: Dynamic file reference?
- formating
- Re: return local row number?
- Copying data between worksheets
- Returning and list Value(s) - Vlookup? Index? Match? Miracle?
- counting occurences of a substring
- Front End Sheet
- Hiding Columns
- sum from table with criteria
- SUM Function with Multiple Conditions II
- dynamic arrays
- Re: Date Calculations
- Average Fucntion
- formatting dynamic chart titles
- Requiring cell to be completed before saving
- Re: extract word searches in excel ?
- Re: Open sheet in Full Screen View
- DDE (Dynamic Data Exchange)
- Re: #N/A in VLOOKUP
- Re: #N/A in VLOOKUP
- #N/A in VLOOKUP
- #N/A in VLOOKUP
- Re: Divide one field into two
- Re: Divide one field into two
- Re: Divide one field into two
- Re: Cross matching data across two columns
- Re: CREATING A MAIL LIST from a WORKSHEET
- Re: #N/A in VLOOKUP
- Recently used files
- Re: Validation list includes blanks at the end
- Re: Date Calculations
- counting how many cells meet a given criteria
- Pivot Table data protection
- Re: #N/A in VLOOKUP
- rounding
- A shortened version of NOT(IsNumber) & NOT(IsBlank)?
- Re: Using wildcard characters in an IF statement
- Creating Pricing Database
- How do I do this in Excel?
- Re: Using wildcard characters in an IF statement
- Referencing a range name as part of a formula\
- Cell Select sequence
- Turn off those clipboard windows
- Filtering
- Re: How to Determine Number of Monday's in 2004
- Functions
- How do I convert ...?
- How do I convert OS 9 macros?
- Active (running) cell attached to Internet value
- Re: FInd the unknow
- Re: convert numbers in figures to number in words
- Re: sumif-possibly a conversion problem?
- Re: Wraping Text
- Re: Read-only
- Linking Formated cells
- Customizing a template to link fields to a database
- Re: Before Close Function Error
- Re: Calculate rate based on total sales
- Re: Countif formula to count multiple letters in range
- Sum Function on reference cell
- excel formula
- Re: Can I auto produce a figure *IF* a cell is......
- Re: rounding to nearest thousand?
- Re: rounding to nearest thousand?
- Re: Totals and Sub-Totals
- Re: IIR calculation
- times calculation
- Re: Calculate rate based on total sales
- Pocket Excel colection of data
- Re: Un Linking a worksheet
- Help with set-up of worksheet menu
- Re: extract the cell reference for a maximum value
- formula problem
- Re: IIR calculation
- Re: worksheet name excel 2002
- Re: worksheet name excel 2002
- Re: convert numbers in figures to number in words
- Re: English XIRR Function / German INTZINSFUSS function
- Avoiding "proper" format in cells
- Matching and indexing
- Re: GETPIVOTDATA & VLOOKUP?
- Re: Formula?
- worksheet name excel 2002
- Extract data from sheet - PLEASE HELP
- Re: IF Function
- Re: Saving Worksheet
- Re: drop down lists
- Re: Formula?
- Conditional Formatting
- Re: Conditional Formatting
- adding a hyphen
- Re: Chang orientation of current cell
- Re: Frequency Count
- Re: date stamping a cell once a value is entered
- microsoft works or excel time formula
- Function for Lookup
- Re: Formulas - Naming Cells
- count number of month function not working
- How to retain subscripting/superscripting with CONCATENATE
- Re: Excel formula needed
- add time
- Re: formula question for range of cells
- Re: Adding a "Print" button within the worksheet...
- Re: PASTE SPECIAL: Linking SPREADSHEETS to ONE
- Get values
- Simple addition formula
- Re: Conditional Sheet Naming
- Re: XP office values
- Re: XP office values
- Re: Background color Macro
- Finding the first empty cell in a list
- Formula Help
- Re: hyperlink
- Re: Custom Views behaviour while protecting sheet
- Re: Basic array
- Formula References
- cant creat a data analys. "sheet is protected" error
- Re: Basic array
- Hyperlinks & filename
- Re: Moving between worksheets
- hyperlink
- Cell security
- Importing External Data
- IF() function on Date Format
- Re: euro converting
- Re: euro converting
- Equivalent of Lotus 123 PVAmount
- labels
- hyperlink
- How do I refresh a sheet to show its content?
- excel
- Adding numbers in same cell
- links
- Linear regression errors
- Data Validation
- date calculation
- formatting a cell that already contains data
- QUARTILE
- Percentile or PercentileRank??
- Re: formula not showing...?
- What's wrong?
- Re: calculating dates
- Re: Excel keeps 'calculating cells'
- Re: Conditional formating
- Re: Dynamic ranges in macros
- inbedded functions in functions
- Calculating 6 month average from dataset
- PERCENTRANK function help...
- Re: Dynamic ranges in macros
- Query Link Question.
- Text Formula Challenge
- Rounding Errors
- Re: Payroll calculation
- Export cell contents to Word
- Re: Basic array
- Text Boxes
- Make a cell Name a sheet/ vice versa
- Re: Count number of prints.
- Page Numbers
- Re: Prevent Dupicates
- Calculating Time
- Re: Can I auto produce a figure *IF* a cell is......
- Re: Reject duplicate data entries
- Re: Does cell contain number?
- CONTROL END
- Re: Does cell contain number?
- Pull value out of list
- Index of worksheet tabs
- Clearing all cell names, easily.
- Wrap text on Merged cells
- Networkdays function problem
- concatenate function (Excel 97)
- How do you combine multiple csv files into one file?
- Re: cell value vs screen display
- link Lotus notes
- link lotus notes
- Re: sumproduct I think??
- Re: Row Shading
- ISNA help
- hyperlinks and filenames
- Worksheet validation
- Prevent Dupicates
- Conditional Sheet unhiding / hiding / renaming
- Excel 2000 DSum Function
- Excel 2000 DSum Function
- merging columns
- finding links in a worksheet
- DataValidation
- Re: Filtering in a pivot table
- Excel like Powerpoint
- Return Unique Values from Table
- Conditional Sum Error
- Got A Question or 2
- Text length?
- Formula for IF = THEN
- SUMPRODUCT Adding Flexibility
- Re: function in pivottables
- Re: Copy/Paste Formulas
- RE: Return Unique Values from Table
- Worksheet Function & Syntax Question
- Re: Row Shading
- Please explane
- SUMPRODUCT
- preventing worksheet-wide data duplication
- Re: Creating a report in Excel
- Re: SUMPRODUCT
- Re: Cell background color: Help needed
- Re: Vlookup with partial text string?
- Multiple criteria for a "sumif" function
- conditional sum wizard
- Building a Cell Reference
- Excel Query not returning numeric values
- Matching Values From Two Columns
- Excel mm:ss strings and rounding up
- Customizing Subtotals
- microsoft excel invoicing
- Lookup more than one column?
- Keeping Column Functions consistent with new rows...
- "autofilter"
- Re: SUMIF
- Help inserting page breaks
- Subtotals at change of more than one field
- Attention Ken Wright!!!!!
- $ in toolbar not working
- page setup feature
- Populating date between sheets
- Re: Items in Pivot Table Drop Downs
- Re: Finding a Median Record in a Filtered Worksheet
- check boxes
- Age from birthday
- Re: Extracting text from formulas
- Defining a Moving Printing Range using Defined Cells
- Moving Data
- CUMIPMT
- choose right price list by quantity ordered
- Deleting certain days in a long string
- if function help
- sheet tabs changes
- decimals & show totals
- Help Please
- Re: Birthday Age
- VLOOKUP/MATCH with Ranges
- From Numbers to Text
- Formula Help Needed
- Equation not working
- auto update between sheets?
- volatile file name
- nested if function problem
- making cells show worksheet names in workbook. is it possible?
- VLookUp
- Dynamic Data Source in Excel 97
- Setting Cell Vaules Without Overwriting the Formula?
- Help with duplicate worksheet
- Excel calendar function !!??
- Trace Precedents
- #REF problem
- Conditional sheet unhiding
- CONVERT Hours:Minutes to Minutes
- Re: Equation to transfer data from one tab to another
- create List from unordered line of data
- Re: return all true from worksheet
- Re: LOOKUP values
- Re: LOOKUP?
- Excel Named Range Removal
- Have you used arrays in Excel?
- Excel 2000 - Formula Question
- Formula for the DATE of every Monday in 2003
- Lost hard returns somehow
- Data validation (drop down list)
- Re: Counting dates that are greater or less than the current date
- Splitting a space delimited cell
- date help!
- finding/viewing links
- Advanced filter
- Hide/Unhide Group Box LINES
- Re: Leading Zero
- Get External Data imports wrong format
- anova formula???
- Re: spreadsheet losing the formula
- Automatic totalling of autofiltered lists
- check boxes and too much data!
- Re: formula will not copy correctly
- Re: printing options
- Re: formula will not copy correctly
- Deselect conditional format
- Re: COUNTA on cells containing formulas
- Animated gif Images
- Rank formula using 2 columns in Excel 97
- 360days function
- I need to determine a cell range based on a blank cell
- Finding Results between two numbers
- I don't understand why not...
- Conditional Formatting - More Than 3?
- Subtotals
- Footer Info
- Sorting Columns
- Sorting Columns?
- Finding discrete/unique values
- Linking problem
- Indirect? reference to external spreadsheet
- The RATE worksheet function
- Changing text case
- Finding a value if you enter a percentage
- worksheet.name
- Displaying function results
- Cannot view formulas in address bar
- swap column and row headers
- Entering data to a worksheet using a form
- Re: I need a formulae
- Re: Combining two worksheets into one
- Created a Form for data entry - Need an "Add New Record" function
- Entering data as time into cells
- ReFormat Text in Fields
- TIME INTO HOURS WORKED
- need a function to report last value in a column
- Help ! Linking worksheets
- Re: Skipping unused lines when printing
- Re: Error message when doing format cell function
- Re: Unlinking Worksheets
- Excel 2000 "Animated Text Efects"
- copying cells using formulars
- Need help with a problem.
- drop down list data
- Re: Sorting by highlighted colors - HELP!
- Re: Split times for race
- Sorting formulas incorrectly
- Excel Zero Values
- Between Function
- Operations Across Sheets
- Re: Text Formula Challenge
- Workday Func and conditional formatting
- Re: cell functions
- maximum number rows Excel 2000
- Re: maximum number rows Excel 2000
- VBA Color.Index=
- Worksheet expiry
- minutes to time formula
- filename and function
- Format all cells
- Re: Run On Event
- Re: INDIRECT FORMULA
- Re: INDIRECT FORMULA
- Re: INDIRECT FORMULA
- Help with menus
- Accessing hyperlinks from Excel minimizes Excel
- Excel & Pocket PC
- Re: Filling Down from a certain row.
- Inserting IFERR Condition...
- Workday function and Conditional formatting.. Can you solve this?
- find linked cells in a large worksheet
- Re: cell functions
- Excel97 printing space markers on hp 5si
- Re: Sorting by column
- How do I ....
- Alt keyboard method to insert rows?
- Text can't be paste into Excel automatically
- TRIM - Excel97
- special features
- Shared Workbook - file disappears on LAN
- Re: Conditional Format; formula
- Using TIME(), TIMEVALUE(), and IF() functions
- Re: Blank Cells
- Re: Copy contents of a Column to Rows on another Sheet?
- How Do I?
- Projecting a particular day weeks in advance
- Converting low level entries to a higher category
- Object not printing but shows in print preview
- Running Total for days/dates
- Formula to return the range of certain cells
- Re: Library not found error received
- Re: Macro Issue
- fill cells
- Cannot empty the Clipboard
- AutoSum sometimes doesn't work?
- Re: Display one message based on the contents of another cell
- Re: Display one message based on the contents of another cell
- Re: COUNTIF query for cells containing text
- Delete duplicate data in SAME CELL
- Varying values
- Help with template wizard.
- Re: Export/import macro
- Re: printing colored cells
- Help on linking and copying cells
- TIME Solution Needed
- function index & match
- Macros........work...................automatically
- Excel97-VLOOKUP: #N/A error: Auto change rtn as Value?
- reverse vlookup
- command line excel to run macros
- Making changes to existing excell documents
- coloring rows based on criteria
- Sheet Names In Macro
- Copy Button Image (standard buttons)
- Copying worksheet name onto a cell
- Adding time
- calculating coloured cells only
- mid/instr/fin
- Re: Excel - Range Selection
- Re: Hyperlinking between excel files
- Follow up on: "Change cell background color after executing macro"
- multiple split box's or freeze panes
- Re: Change cell background color after executing macro
- Re: Excel - Range Selection
- Writing data to Specific Cells???
- Re: test
- How do you calculate formulas with time as the format?
- Re: Stableford system
- combo box
- Expand/Collapse columns?
- Re: unable to open file
- How do I delete rows? I have 65,000 of them
- Re: Time measurement
- Re: Time measurement
- Convert Numbers
- Re: Loan Amortization Schedule
- Advanced Filter
- adding times, again!
- Conditional Formatting
- Need help with C. Pearson's Functions
- Re: Row Shading
- Re: Chart views
- Re: working with minutes and seconds
- Re: working with minutes and seconds
- print to file from an xcel97
- Re: Loan Amortization Schedule
- Color codings of data
- Protected Worksheet
- Conditional Sheet Unhiding
- Pivot Table Field Setting Problems
- Microsoft Comma Separated values
- Microsoft Comma Separated Values
- Autopopulate TextBox1
- combobox1 values
- COUNTIF/SUMPRODUCT in two columns again (esp Harlan Grove)
- Conditional Sheet Unhiding
- UDF IF() Function??
- Total Page Numbers in Workbook
- Advanced Filter
- Re: Count number of prints.
- Re: help with writing a formula
- Re: help with function
- Re: help with writing a formula
- Re: help with function
- Conditional Formatting
- Conditional Formatting
- Conditional Formatting
- transfering varying values between worksheets
- Sheets in a Workbook
- Re: Copying a sheet2 to last sheet in workbook
- Re: Automatic Selection of cells
- Re: Conditional Formatting
- Private Groups Userid/Password??
- Problems with * in a criteria range
- Help with Advanced Find
- Re: Updating pivot tables
- Re: Copying a sheet2 to last sheet in workbook
- Re: Mertic Conversion
- Transferring files between computers
- count if 2 different cells meets 2 different criteria
- Cumulative values across different pages
- Re: Excel HElp
- hours worked
- LOOKUP FUNCTIONS
- Re: calculating total weekly hours for payroll
- Re: calculating total weekly hours for payroll
- calculating total weekly hours for payroll
- Re: I need a formulae
- Sort function
- The Top Ten Reasons to Keep Smoking :)
- IF Forumla/Hyperlink
- Time input
- Conditional Formating
- Hyperlink function in Excel 2000
- Filtering All
- Re: Calculating Filters
- Excel help please
- importing and filtering data
- Re: Mertic Conversion
- Re: IPMT Limitation ??!
- Re: I need to do this for my job........please help !
- Cheque template formulars
- Find Cells with Links
- Re: counting cells in a range
- Re: counting cells in a range
- Re: counting cells in a range
- Updating Links
- Number not recognized...
- Re: reverse order of columns
- Formula for annunity payout
- Sort across two or more sheets
- Import MS Word into MS Excel
- Re: bank holidays
- Re: bank holidays
- Tab settings
- ODDFPRICE problem
- How do you save to WMF format
- Trailing spaces~delete
- Intergrate a cell
- Filters
- interpolation of numbers
- Matching any 2 cells in different columns
- Numbering series
- Freezing a NOW() date...
- Break Function
- Hyperlinks in Shared Workbooks
- Is this possible ?
- how do I?
- print column titles
- Multiple worksheet viewing Windows CE
- Re: Date Calc
- Re: Date Calc
- Data Group Error Message - Cannot Shift Objects Off Sheet
- Excel 2002 Data Sort Function
- Re: Yen
- checkboxes
- Creating a month series
- Re: Date Calc
- I need a funtion for this products
- zero in formula problem
- page orientation
- Re: I need a formula
- Re: I need a formula
- interfacing Excel with Access
- calculating hours worked function PLEASE! beg beg
- Re: I need a formula
- Re: Problem in using Excel 2000
- Re: logical function based on font color of another column?
- Using Formulas on an imported worksheet
- Re: Macros
- COUNTA on cells containing formulas
- Conditional Formatting
- Re: Macros
- Editing Input
- Concatenating incorrectly...
- Sum Visible Cells
- Re: need a formula
- Changing cell format based on cell content
- Re: Changing cell format based on cell content
- CSV format on non English OS
- Conditional Formatting
- Highest value in a list
- Excel root function
- Cells not adding totals, Excel 2000
- Re: Hyperlink on network broke?
- Return Name of Sheet in a formula???
- Re: Relative Worksheet Reference
- Date problem
- Need formula to auto-fill in web-page information! Help!
- Can I increase 1024 max in a cell
- Re: ISERROR Function
- Excel text
- Re: Conditional Formula's
- Capitalize Cell Contents
- Re: Missing Data When I Use Filters (ALL)
- DEC2BIN Function for numbers to 80,000??
- Determining Dates in a Timeline
- Re: Missing Data When I Use Filters (ALL)
- ACCRINT problem
- How to compare between 2 columns ?
- Referencing every nth cell in another sheet
- Index function
- Sorting by the first number?
- Sum Product - AND or OR
- Re: Sorting by the first number?
- Re: Geometric mean
- autofilter-subtotal-problem
- Better way to find column heading value?
- Comparing columns in different worksheets
- Sumif and Left/Mid formula
- two identical values aren't equal according to xl 2000
- Re: Geometric mean
- Locate Hidden Files, remove read-only
- Multiple data per cell
- Refenced cells are not displaying correctly from another sheet
- Re: Data Validation Problem
- Trouble with dividing and multiplying cells
- Re: Adding quotes around text in a cell.
- sum formula returns zero value
- reference to a specific cell
- Date field
- macros written excel 4
- AND vs. OR
- RE: Excel problem
- Re: Sorting by the first number?
- Re: multiple criteria in countif function
- Getting footer to display full file pathway
- Win XP Excel
- Random Number Function...
- Sorting Problem
- Input statements in a macro
- A function that determines the color of a cell?
- Min Function
- Concatenate Text to create Formula
- Excel XP Unprotect Workbook
- Replace "#DIV/0!" with ""
- Finding duplicate e-mails
- Re: What do I have to do?
- Running outlook from Excel
- Encryption
- Function to find "Invalid" in a string
- Re: Linking
- center and merge
- Problem with formula
- How do I Delete a Work Sheet in Excel
- Re: Multiple "if" statements, coordinates & value ranges
- autofill
- Re: Multiple "if" statements, coordinates & value ranges
- What's Wrong With This?
- Re: Numeric keypad (w/laptop)& Excel
- NETWORKDAYS - rounding required.
- Remove alphabet from a string
- Sorting problems
- Re: Printing Formulars
- frequency
- formula not calculating
- frequency
- Re: Relative Worksheet Reference
- AutoSave Function missing or changed in Excel 2002 SP2 ?
- Re: Pivot Table Text Values
- Re: Function question
- Re: Printing Formulars
- Re: Function question
- NETWORKDAYS
- Date functions
- Re: center and merge
- frequency
- Date minus one working day
- Sorting problems
- More than one formula in a cell
- Re: More than one formula in a cell
- formula works for numb, but need "x"
- Error when finding the last non-empty cell in a column
- Re: Extracting last name from cell
- Extracting last name from cell
- A function question
- Test equations with empty cells
- Array Functions - how big?
- replace "#DIV/0!" error with blanks
- Cursor Placement
- Finding where a date falls
- Hitchhikers guide to the Galaxy...?????
- Re: Requireing/Prompting data input when adjacent cell is specific text
- Find largest value and return placement
- Data Manipulation
- The $ Shortcut Button
- Changing Cell color based on "not ="
- Re: Number formating
- Arrow Keys not responding... the move the page view!
- Re: Date stamp or Date modified
- Re: Date stamp or Date modified
- Sticky Keys
- Re: Convert elapsed time to decimal notation
- Protection
- hyperlink to worksheet/s
- Menu Options being held in different workbook?
- Repeating the same row on each page
- Excel - Copy - Date
- Re: numbers are changing as I enter them
- transfering files to excel
- Re: Cell Protection
- Re: Cell Protection
- Re: numbers are changing as I enter them
- Re: Extracting last name from cell
- Re: Cell Protection
- Excel sheet tabs
- YIELDDISC
- linking data to several worksheets
- Custom Number formats
- need help filtering entries
- Problem with Formula
- any solver resources out there?
- Qs related to time/date functions
- Replace a character with a newline chr(10)
- MROUND Function
- Re: Envelops
- Re: Envelops
- text limits
- Re: Envelops
- Unicode and *.xls Files
- locking cells
- Re: Moving to the begining of the next line
- Circular Reference ?
- Re: Moving to the begining of the next line
- Converting various phone number formats
- Need formula help - IF/OR Array??
- Re: linking objects
- compound rate of return
- Comparing cells
- entering times efficiently
- IF Statement Limitations
- Re: Header using a row
- FrontPage - Saving Form Results to Excel?
- grouping and ungrouping a protected sheet
- Textbox in a cell
- user defined name for function with relative reference to tabsheet
- Indirect function with files closed.
- Month returns
- Indirect Function with Closed files
- number with decimal
- Calculating average of range of cells which keeps moving
- Need Help With Lookup & Indirect Function!
- Original question
- Re: Lost an Excel function
- Re: Average Annual Percentage Rate (AAPR) formula
- Needing Formula
- Re: Lost an Excel function
- Re: How can make a table
- RE: How can make a table
- Re: how to refer to an article? where are they ?
- Simple conditional formula
- Inserting filepath and filename
- Need Percentage of P, F, N in a column