- dropdown list boxes
- Cell Formatting
- logic
- Numbers
- Hyperlink To a Specific Access Report
- Re: AutoCorrect in a different cell?
- Re: AutoCorrect in a different cell?
- corrupt excel files
- Experienced Exceler Needed
- Re: Time
- Inserting data
- Inserting data
- printing question
- Deleting list of files under "Open a Workbook"
- Calling a VBA procedure from an excel cell function
- Summarising date-based data
- FACT function
- Re: Running Show time
- help
- Solver Problem
- How lock cell format, but not lock cell contents?
- Im Scottish Help
- Re: Cells with Formulas
- Re: Help with formula
- More help with Formulas
- Dave Perterson - Are you there?
- Recoding in Excel
- Tally Text
- Re: CHOOSE
- GetNextTemplateNumber()
- Re: negatve numbers not recognized
- Re: POISSON function
- Data Transfer
- Re: Adding Time
- Importing text
- Re: vlookup, lookup, isna
- Deleting Duplicates in Column
- Re: vlookup, lookup, isna
- 3 Excel Questions...
- Re: How to use "Print" or "Write" function to ...
- negative numbers
- Re: Adding numbers after text.
- Recording the date and time when a record is modified
- Re: Adding numbers after text.
- Re: IF function
- Re: "calculate"
- Adding numbers after text.
- Missing a test condition...
- Time Dif in Excel 2k
- Re: vlookup, lookup, isna
- Re: Highlighting the entire row
- Min function but ignore zero values
- Re: Highlighting the entire row
- date function
- Re: circular reference
- average
- FUNCTION to calculate START of Month
- Mailing Labels
- splitting a cell
- Worksheet tab
- trimmed mean function and if bold function
- Re: Assigning then retrieving value from Option Buttons
- Partial locking
- Statistic
- Formulas
- Count how many cells have values that meet multiple criteria
- Add new text file in excel using VBA
- autofill feature
- Ignore blank cells in formulas & in average
- Re: Adding Amounts Based on a Condition
- Hiding Columns causes "Cannot shft objects off sheet" message.
- Formula error
- Date Reference a cell
- Protecting Worksheets
- Sheet name link to cell
- Hedged portfolio
- Re: how do i change the font color / button unavailable.
- Formula total doesn't change
- Functions and Formulas
- How to find values for a group of cells based on another group of cells
- Assigning a macro to a command button
- formula won't calculate
- print macro
- convert decimal into time
- trendlines and their equations
- input mask in excel?
- How do I change font case?
- Formatting cells
- Weighted Average Calculation
- edit text of combined cells
- Converting Dates to Fiscal Year Quarters
- I want to seperate first names from last names...
- Unable to see Control tab for Format Control
- Changing color in IF-THEN statements
- Sum only if all criteria is met
- Tom? Chuck? Additional question...
- Non-printing page break?
- Re: #DIV/0!
- Duplicating Values AND Dates
- Re: Open existing xla in new instance
- Running Averages
- figure vacation time
- Re: vlookup & formatting
- I Want To Use Countif With 2 Conditions
- Saving Embedded Objects
- Re: Trouble with counting formulas based on a secondary condition
- disable right mouse click
- Saving Embedded objects
- Changing the protected sheet tab order
- Activating different Workbooks
- Trouble activating the worksheet
- Re: Data validation question
- Combo dropdown box
- Converting military time minutes to hundreths for accounting
- Re: Data validation question
- Tile the sheets within a workbook
- formula and automatic calculation
- Closed workbook link by formula
- Adding Quantities - 2!
- adding a font
- Control+End in Excel 97
- Calculating Average Speed in Excel
- Dates
- Re: Excel2000: Replace array element with element from another array
- Vlookup from multiple tables
- Re: Conditional Formatting
- IF statement help
- Joining countif conditions
- Re: Range Selection/Automatically Hiding Columns
- 3-d sum across worksheets error
- Re: Conditional Formatting
- Re: Using the Average Function
- Re: Conditional Formatting
- Re: Using the Average Function
- Unable to remove all macros
- Re: SUM with IF
- Re: Tally Unique Numbers?
- single click to deactivate Auto Filters? How?
- Re: Remove lines from group box
- Re: Tally Unique Numbers?
- Re: Worksheet Tool Bar
- DCOUNT Help
- Tally Unique Numbers?
- zip codes
- conditional formatting
- Re: "IF" statement help
- VLOOKUP and #N/A
- Re: CHOOSE
- formula to work out a persons age
- Is it possible to make the function not start until i press the OK button?
- vlookup & formatting
- Re: printing formulas
- Re: Conditional Formatting
- Repeat Header Row on Each Page
- using macro with data analysis sampling function
- OT: Product Support Services - Microsoft Security Bulletin - MS03-039
- Adding with multiple conditions
- Manual line break
- Re: IF functions
- Pivot Table or Table Summary Help Please!!
- Fixed Declining Balance
- SUMIF ?
- Re: Tally Unique Numbers?
- Re: Excel2000: Replace array element with element from another array
- Recalculating in Excel XP
- Macros
- Re: pasting hidden columns
- Re: "IF" statement help
- Re: inserting values
- MS Excel - How can I summarize a table? Will Pivot Table Reports do this for me?
- Re: increment a cell in different worksheets
- Covert Excel 2000 .xls to .rtf
- Re: Drop down menu for individual cells in Excel
- Excel worksheet
- Re: Pivot Table Question
- Data Validation for Lists
- autofit a checkbox to the appropriate cell
- Format Pivot Table Titles
- Re: #N/A
- Sorting problem with referenced cells
- Re: #N/A
- Use formating to display cents as dollars and cents ?
- Interpolation Visual Basic Macro!!!!
- Sorting Problem
- Merging
- UPPER and LOWER Case
- graphics do not appear after printing
- Re: IF Statement Help
- military time conversion hundredths
- Use of And(Cond1,Cond2) in Contol Array Entered Formulas
- SUMPRODUCT and COUNTIF combination?
- Day and date display
- Row Limit
- Problem of having more than 7 IF statement
- Re: How do I extract specific data out of a cell to another cell
- Re: How do I extract specific data out of a cell to another cell
- Excel 2000 Premium
- time card formula problem
- Splitting address ie. #, Street , & other identifiers in a cell
- SUMIF
- Re: Activate workbook using the absolute path!!!
- Template Wizard not creating a record
- Re: SUMIF
- title formatting
- what is 'syntax'
- Re: SUMIF
- Digit grouping
- Function : Sum Incorrectly from other worksheet !
- Re: Sending worksheet via email and it's not working.....
- Re: Sending worksheet via email and it's not working.....
- "getpivotdata" Help Required Please
- Modulised mean
- Re: Troubleshoot - Drawing Line
- formula for automatic calculation
- formula for automatic calculation
- sorting number with "-"signs...
- Get Pivot data
- modulised mean
- Changing positive to negative over a range
- Data validation
- Look-up
- Excel Page Setup
- Adding Time in Excel
- Format Calculation
- Re: Opening Excel files
- Re: CHECK MARK
- Re: CHECK MARK
- Copying from Access into Excel template
- Re: protecting cells within a worksheet
- Find Square Inch Of A Cell
- worksheet function
- Re: protecting cells within a worksheet
- Re: comma delimited
- "If" and "then" formula's
- Copy Pasting formula's
- Re: CHECK MARK
- convert 123 macro to visual basic in excel 2000
- scientific notation
- SUMIF with AND criteria
- Re: code beginner
- combining fields to make a date
- Saving embedded objects
- Re: sumif worksheet function
- day/date correlation
- Re: Named Ranges
- Sorting within a web frame
- Re: Adding variables - can it be done
- some worksheets have no 'splitbox'
- Re: translate numbers ni to text in wxcel worksheet
- Re: #VALUE! is driving me nuts!!!
- Re: Help in Formula
- Re: Auto numbering
- Re: Count and Sub-total
- pop-up cell text box
- Re: Eliminating an external link
- Re: Printing in columns
- Re: Percentages calculated incorrectly
- Countif / and
- missing values
- Re: code beginner
- Re: function for duplicate entries
- sorting
- Eliminating an external link
- Re: duplicate entries
- Re: Index & Match
- ROUND function
- blank lines
- import multiple text files in to multiple sheets automatically
- Using IF, AND, and IF together
- Nested Countif?
- Formatting within Text Boxes
- Mergingg worksheets; Possible?
- COUNTIF / not SUM
- sorting
- Drop Down Boxes & Posting Linked Workbook on Internet
- Date calculation?
- Re: What is wrong with this?
- Saving a wab page with inbedded <META> tags
- Re: What is wrong with this?
- Autofit for Rows Does Not Work
- Creating VBA button to send an email
- Retaining initial cell contents after calculations
- Calculating diff in hours between 2 dates
- calculating time intervals in excel
- Locating cell with linked formulas
- "Warning: Excel converter page limit of 50 exceeded.
- Tab Name (Only) in a Cell
- Using if statements
- Re: Attaching a hyperlink to a button
- Re: How to do?
- Reference Values from Multiple Workbooks/Files
- How to do?
- Re: How to do?
- Please help
- Sync one worksheet on workbook with another sheet on another workbook
- Can Excel 2000 be minimized (multi-tasked) ??
- Formulas with relative and absolute dont copy correctly. Signs and cell referenc
- Re: Table Formula
- Formula for Filling Columns based on dates
- calculating an annual rate
- Sub-Totalling
- $a$1
- If statement
- opening saved files
- Conversion of cells to .002 etc
- Re: Complicated lookup question
- Formula Referencing the Result of an IRR Calc
- Re: What is wrong with this?
- Is there an alpha SUMIF?
- IF Statement help???
- Re: CD Track time calculator in Excel?
- Sort row 4 in alphabetical order
- Tool for getting data
- Error #VALUE with TEXT(A1;"[HH]:mm") when changing regional settings
- excel function
- Data controlling Excel
- Cell format
- Pivot Table - formatting
- Re: How to do?
- Sum across workbooks
- No value less than 0
- How can I add to a created Field List of a pivot table
- How can I add to a created Field List of a pivot table
- How can I add to a created Field List of a pivot table
- How can I add to a created Field List of a pivot table
- How can I add to a created Field List of a pivot table
- How can I add to a created Field List of a pivot table
- How can I add to a created Field List of a pivot table
- control box return content of cell indexed
- Seperate data in a cell
- Formula Converston to German
- Inverting a column of data
- Re: Aeronautical calculations
- Using a pick list
- How to Compare two files
- conditional statements
- Constant Function
- converting data from rows to colomns.
- Re: How to get the domainname out of an emailadress?
- I need to create a new global function
- using spell check on a protected sheet
- Re: macro for editing fields
- LINK CELLS/WORKSHEET
- Saving Trace precedent trace dependent arrows
- Lookup and compare
- Re: VLookup
- Spaces between names
- GETPIVOTDATA- should it update with the pivot table ?
- Count on colors
- macros - inserting a list box
- VLookup
- Re: merging cells in a mailing list
- merging cells in a mailing list
- Formula's
- Re: Formula's
- Need help with this rankings
- Resizing Converted Page
- Merging cells in XL
- Re: scroll bar on bottom of worksheet
- Formatting Cells
- Inserting Worksheet name in a cell
- Re: Excel / Lotus
- "Too many different cell formats" error
- Password Protecting Excel
- lookup function help (1 column over & 1 row down)
- How many sheets can one book have?
- converting number to letters
- sorting with autoshape objects
- autoformat
- Formula help, CELL Function help needed.
- Excel 97 workbooks copied to Excel 2000
- Go To Last Cell +1 Macro
- DCOUNT function
- PROPER function in a colum
- Inserting Worksheet name in a cell HELP!
- Re: Nesting IF
- Exel 97
- Extract Function
- conditional summing
- FIND or SEARCH Function
- Form Control
- Linking to a Pivot Table
- Sum across different worksheets
- Re: referencing cell contents from rows that change
- Combining email information into an excel spread sheet
- Get value from another sheet
- Web query from a secure (https) website
- MODE function is wrong
- Re: Removing Blank Cell
- Obtain Current Cell Address
- Removing Blank Cell
- changing email properties
- printing gridlines on spreadsheets
- Re: Custom Views in Excel 97
- email from excel - change sender?
- VBA Function
- Date troubles
- quattro pro seems better
- Sync workbook
- Re: Time Sheet round off help
- Re: Time Sheet round off help
- Macro for opening "Save As" dialogue box
- Re: Time Sheet round off help
- Conditional Formulas
- Formula
- Tabs
- Strange problem with reference to another workbook
- Countif using Criteria "<>""" ?
- Re: Time Sheet round off help
- Cell color updates - VBA instead of Conditional Formatting
- Re: automatic totals on each page of a worksheet
- Re: Removal of Toolbar from Excel 2000 work sheet
- Toggle button
- Formulas in a calculated field of Pivot Table
- every thing
- can i convert text to time format ??????
- Test Message
- Re: Multiple paragraphs in same cell
- Re: Background Color No.
- Re: Background Color No.
- Re: Background Color No.
- Re: Maximum Values
- Quickly insert today's date?
- Re: Bizarre VLOOKUP situation- at least to me
- Decimal Places
- Re: Concatenate question
- Printing problems after XP upgrade
- Writing formula for cell differences based off a rank
- Re: Maximum Values
- Re: Time Sheet round off help - Thanks Dan,Mike, Ron and Peo
- Re: Concatenate question
- Re: Time Sheet round off help - Thanks Dan,Mike, Ron and Peo
- Linked worksheet problem - extra worksheet linked
- Re: Concatenate question
- converting to access
- Re: sorting calculated fields
- Re: Concatenate question
- Timer
- Help - Excel Summary sheet
- Concatenate question
- Re: Time Sheet Round off help - Thanks Daniel M.
- Re: Recording Macros
- Re: Recording Macros
- Using a Macro in a Function
- need to transpose or something ...
- Wrap text in a cell
- Getting a percentage
- Important!!! Need Info on creating a percentage.
- Inserting Worksheet name in a cell HELP!
- Goal Seek Command
- Re: almost DSUM, but is there another database - criteria funcion?
- Time-of-day Average
- Possible to automate absolute?
- Freq.Dist table...can it be done?
- Re: Constructing a frequency distribution chart
- Constructing a frequency distribution chart
- Re: Macro - Copy without open the source workbook.
- Average of bottom 10 values in a range
- Copied formulas paste as text and paste special does not work
- Continual date countdown/reminder (Help!)
- Adding negative and positive times
- Numbering rows for sorting
- Change topic - Macro Search Workbook...
- almost DSUM, but is there another database - criteria funcion?
- CommandBar
- Re: excel custom menu
- Re: excel custom menu
- Re: adding pictures into cells
- Fields - Tabbing to the next
- ISERR vs ISERROR
- Select the Name of the Worksheet with InputBox
- Re: MS.Excel vs Works Spreadsheet
- Comment boxes
- select the worksheet
- Don't show Zeros
- Trim function limitations
- Re: Bolding specific text in a formula
- Excel "IF" function problem
- sumif function
- Re: MS.Excel vs Works Spreadsheet
- Notes
- split worksheet
- Combo Box & Linked Workbooks
- Formula
- E-Mail Hyperlinks in Excel
- Excel column headings
- Excel Conditional Formatting?
- changed microsoft query not updated
- Compare 2 Worksheets & Find Matches
- Re: VLOOKUP problem
- Comparing ranges
- Extract a number from a cell of text
- Selecting from a list
- Re: excel.exe program error
- Formatting Column with all Caps
- Upper case to lower case
- pivot chart formatting?
- Change Case
- Re: Networkdays calculations
- How to prevent function range auto-modification ?
- filtered list
- IPMT and ISPMT
- NETWORKDAYS
- Re: Possible to set Zoom on worksheets via Macro?
- Starving Trolls
- Re: Calander
- attaching website links to excel file
- Calculating Duration
- Date List
- concatenating cells
- Re: Vlookup or Offset question
- combining formulas
- Rounding to nearest $
- Re: Possible to set Zoom on worksheets via Macro?
- Sumif of cells less than a system date
- Re: Bolding specific text in a formula
- Line spacing
- Balanced Scorecards
- How to pass array variables in sub procedure
- vlookup Sorry if it's confusing..
- formatting 'Checkbox' function within a cell
- Comments that aren't Comments
- Pivot table update
- Re: reversing lastname, firstname
- emailing excel single sheet as attachment
- Re: Possible to set Zoom on worksheets via Macro?
- vlookup does not always work
- How to multiply a text function by a dollar ammount
- Merge 2 Worksheets like Word Mail Merge???
- generating random numbers
- Re: import data from one worksheet to another
- Re: formulas
- Re: Printing group symbols on report
- Visual Basics code
- Creating new Option buttons
- Running Total of Column
- changing a button color
- angled column headers
- Preserve Today's date
- formulas
- Column Data to Rows
- histograms with normal distributions
- template wizard
- Negative Numbers
- Splitting cells / diagonally displaying cell data
- remove link
- Solve for X
- Specs for Random Number Generator
- formula
- Time intervals?
- Excel 2002 does not recalculate existing formulas
- help with SumIF
- Re: If value is greater than, then....
- Re: If value is greater than, then....
- Re: If value is greater than, then....
- Empty Cells, COUNTBLANK, and ISBLANK
- Subtotaling in Excel Using Different Types of Calculations
- Re: calculating with displayed values
- Re: How to Copy/Paste Only the Subtotal Rows in Excel?
- Need help: I want to display the last save date and saved by in the footer
- Re: calculating with displayed values
- Impossible Matrix
- Calculating Time
- crore formatting
- Personal.xls
- macro question
- Re: calculating with displayed values
- Excel(XP) File size "bloating"?
- worksheet protection/macro
- IF cell contents = ?????
- Looks like kind of lookup but...
- Re: calculating with displayed values
- Pivot table - formatting
- Excel Spreadsheet
- Re: Lookup question
- Pop up function ???
- Newbee show cell address
- Entering numbers
- Sorting by cell or text format
- Re: Totals in Days, Hrs and Minutes
- Re: Totals in Days, Hrs and Minutes
- Need to schedule with variables
- spreadsheet question
- match formula
- Excel text converted to Number or other
- Choice and effect
- Problem with Excel File after Upgrading to Office 2000
- Worksheet updates
- Re: calculating with displayed values
- histogram
- Macro to add cell value to refering cells formula
- Comparing Repeating Cells
- global changes to hyperlinks?
- Change in time where text is involved
- View problems
- date f(x)
- automatically add a numerical unit on a daily basis begining with a date specifi
- Bullet Points
- cell references
- average f(x)
- Formulas not automatic
- Formatting (General to Number)
- Re: Excel formulas
- Fonts of Drop Down Forms
- Custom Template Worksheet Location
- RE: "If" or "Sumif"
- getpivotdata
- Re: Exposant
- Column names and deletions
- Re: lotus 2.4 macro
- Average function
- average function
- Re: Vlookup or Match/Index to return value 2 rows down
- Re: Vlookup or Match/Index to return value 2 rows down
- Sharing Workbooks
- lookup for double column
- LOOKUP function
- watermark
- drop down
- Re: sum minus the smalles cell
- calculating number of days between two dates
- sum minus the smalles cell
- Solving for Coefficients of a polynomial
- Pivot Table Using Multiple sources
- lookup formulas
- Pooled regression and dummy variables
- Re: ROUND function or custom format
- Re: LOOKUP Formula
- Do I need a macro?
- trendline equations are incorrect
- Date Function: How to determine number of Saturdays in a date range
- Macro
- AutoFill On Inserted Rows
- Dates parameters/logic
- Re: vlookup
- Compare 2 columns in a worksheet.
- Autofill formulas b/t various worksheets
- Re: finding Specific day in a named range
- Re: Creating Formula (Date)
- Re: all today's work gone :(
- Re: Compare adjacent numbers Within Cells
- Re: Excel 2000 255 character limit
- Date Value & Date Format
- macro - hide rows
- Re: links to cells/unlocking hyperlinks
- matching values
- Re: all today's work gone :(
- Re: printing grid lines
- Duplicate info by columns
- Problem with Date
- Opening Excel sheet with macro's on XP machines gives error
- sumproduct variables
- Date Format problem
- sumproduct variables
- Automate Access Via Excel VBA
- last value in a row
- Writing Todays Date to an Excel Worksheet
- combined cell
- multiple AND conditions with IF's
- nested functions
- LOOKUP or Offeset
- Re: sequential counter
- Re: Macros in XP vs 2000
- Excel query
- Using Sheet Name In Cells
- Importing Large Text File
- AutoSum strange
- Using Sheet Name In Cells
- concatenate question
- Counting Rows
- Re: multiple field returns
- Multi level calculations
- getting max value of unique dates in a range
- time logging
- Re: DATE
- Re: last day of month
- autosum changing
- barcoding
- Sum Dates
- Query refresh
- Re: Moving from textbox1 to textbox3
- Re: Remove Spaces
- Merging
- Re: text referencing
- LINKS IN EXCEL 2000
- Re: graphng distributions
- extracting data
- Changing A1 to $A$1.....
- Date Format
- Reminder/Alarm for a cell
- copying worksheets to other workbooks
- automatic links
- filter
- How to count comments?
- If then formula
- Re: sumproduct variables
- MONTHLY PAYMENT FUNCTION - DAYS TO 1ST PAYMENT
- Turn off From: Cc: options under Office
- Re: Using multiple IF statements
- Deleting Excess Pages
- Formula Help
- Re: return in excel
- Re: return in excel
- TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES
- Using multiple IF statements
- Formula Help
- Finding and deleting data automatically
- Re: return in excel
- Pivot Table Display
- Multi worksheet data look up
- MouseClick as Counter
- import data
- Re: sequential counter
- sumproduct variables
- Re: emailing protected Excel worksheets
- Spherical Coordinates
- Deletion of non-existent links
- This directed to John Wilson/or anyone else
- unhiding Column A - help!
- Calculating age from date of birth
- Re: testing
- Spreadsheet play file then close
- Array Countif formula driving me NUTS!
- Re: Excel database query
- Changing date formats
- Linking
- Random Numbers
- Worksheets
- Tan Graph
- Hyper Linking
- revision number of excel worksheet..
- sumproduct formula
- referencing a cell pointer in AVERAGE
- Split Combined Name
- Formula Help
- excel data hidden
- Re: Counting
- Re: AutoSum Limitation?
- Excel expression that would always show the Sunday date of the current week
- First Name Last Name in a colum. how2 divide them into two colums
- Re: Compare adjacent numbers Within Cells
- Excel 2000 - PivotTable Sort and Top 10
- formula
- Excel 97 - finding No. of Months between 2 date ranges
- return in excel
- Dropdown Menu to Select Worksheet
- Macro to hide rows
- Re: Two Problems Adding Hours
- COUNTIF help: single column yet variable text location
- Directory starting witht the Current Directory