- Setting the Values Property of the Series Class
- Include error checking
- changing the background color on a single column
- Help with IF/AND function
- Re: Edit Custom Functions
- Duplicate searching through multiple columns, rows
- weekly top 50 titles _newbie,please help!!!
- Search entire workbook for cell and return whole row.
- new question on FALSE
- JIS worksheet function
- footers
- Re: Date/time modified - without macros
- Nested IF question
- how to change extension of unopened file
- Count Functions across multiple worksheets
- more help - Formula to check values
- 100% eliminate the "Save before quitting?" message
- Looking for "StDEVIF", if it exists
- searching for a cell val & returning all vals in col B of all rows the cell is found
- Relative file address
- Re: Edit Custom Functions
- Help please, going mad !!!
- find on multiple worksheets
- Formula Assistance Needed
- Thanks all, sanity returns !!
- Help with Indexing and/or Matching???
- direction of the cursor in Excel 2000
- UserForms and ComboBoxs
- Cut & Paste
- Epoch Date From Remedy
- protect / unprotect multiple sheets
- default print setup
- functions that allow text and formula
- IF and VLOOKUP - Any good reference webpages?
- Average ignore values of 0
- Help with countif function
- Formula for using results from one chart to organize data in second chart?
- Something so simple, yet so tricky... (last request for help :-)
- If This - If That
- Possible Concantenate
- making easy money
- Concatenate text with a carriage-return
- Distinct Counts in OLAP
- How might I do this
- Help! Splitting Text And Numbers In The Same Cell
- Function not evaluated
- Nested logic arguments- internal reference?
- trying to modify formula for worksheet
- countif function
- How to search for a number
- filling dates
- Excel file loading issue
- Excel # of Comlumns Extension
- Conditional Format almost what I want
- Patterns
- Problems using Average
- Enter 1 but appears as 0.01
- newbie's bumb question
- Dates in excel
- vlookup help
- arrow keys to nav cell to cell
- Date Function Problem
- Help with rankings / finding the second occurence of same value in a list
- Compare cell between wkshts - not working
- Pop-up Reminder
- Hiding 2 columns
- Drop Down Lists
- comparing data column in other worksheets and returning certain data fields
- format
- sorting
- CountIF (tricky one)
- anoyance with mouse
- Adding (creating) worksheet
- vlookup not working
- Office 2000 SR-1 Excel - performing no calc if adjacent cell is xxxx
- Matrix Reverse with row identification to reverse bas
- forgotten
- Changing Multiple Cells from Relative to Absolute Functions
- Excel Functions-Forms
- Unwanted results from formula
- Running average
- 2000 Office SR-1 Excel - IF function
- Excel
- Excel footnotes?
- Using cell content as reference in formula
- Auto Sort
- Subtracting Time Zone for Universal Time and Date
- Counting "," in a cell
- Need Help WIth a Function
- Adding Time
- Number with leading zeros
- Extract values from drop-down boxes
- calculate cells between two values
- Macros
- For Arvi Laanemets
- F2 Enter to make Formula Work
- F2 Enter to make Formula Work
- logical/arithmetic functions w. Excel
- Workbook.XLS worked fine. Now I installed workbook.XLT and both open very slowly in XL97
- Desperate Lookup Help Required
- make a function that add number 1 in another number
- Need Lookup Help Urgently
- OFFSET Function
- Concatenate Formula
- exporting/linking data from a row on one sheet into another sheet
- Add automatically a number to a cell each time the week changes
- Alternate to A1&B1&c1...&n1
- Conditional Formatting
- linking data from a row on one sheet
- Conditional Formatting
- What is going on with my Excel 2000 spreadsheet?
- date ranges
- Faster Lookup Help
- Count TRUE only
- Adding months
- Re: Having Excel say numbers so I can check them
- Re: Having Excel say numbers so I can check them
- Fuctions across multiple identical sheets
- Filtering
- USER
- To Frank Kabel or anyone who knows how
- Excel binders
- Countif function for years
- date formula not working
- SUBTOTAL
- Sum problem
- VLOOKUP problem
- Rounding
- Pivot Tables: Omitting Zero Values
- SumProduct Function
- Formula needed for first blank row
- Offset Hlookup result
- linking data in sheets
- Auto Filter?
- Compare and creat a result
- Looking for a new formula
- Sum amount with dates
- URGENT! Help Needed with Lookup Formula
- Excel IF and LOOKUP Statements
- How to find and sum top n from each columns?
- Conditional Function
- How to #VALUE! = 0
- Filter
- vLookup
- Lookup and Offset (Excel 2000)
- concatenate vs and
- Sharing a workbook - I lose some functions & Pivot Tables
- Hyperlink removal
- graphs
- Need macro to create Text Box
- font color in formulae
- <xml> becomes %3cxml%3e Help!
- Automatic numbering
- How to retain sub-totals after refresh
- Sorting Text Range with Formula
- Matching blank cell with MATCH function
- formula help
- Create entire year in column.
- How do I reference cells in multiple tabs via a formula
- Date/Time entry difference formula
- Time Function help
- One more hopefully simple
- Multiple Conditional Formatting or IF Functions
- Copying Functions.
- Formula Help
- Need help with Protection
- Inset new row in Shared Workbook & keep formatting & Validation?
- multiple countif question
- Excel Files Grows Huge
- lookup using multiple criteria
- Calculating compount interest from a table of dates/interest rates
- date computation
- Vlookup in a Sum formula
- Inventory help
- formula please
- if function
- Making a button to open a work book
- Split words in one cell
- Malfunction in cell references
- How Do I create a Timing Tool
- Excel XP and File Links
- SUM of PRODUCTS function?
- pagebreak
- Having Excel print a cell location
- Function to copy lines
- Printing Odd Pages
- DMax criteria is not working
- Finding/ adding/ ranking question
- need help with equation
- macro
- How Do I Create Accumulative Totals That Do Not Reverse
- Viewing a Hyperlink in another cell
- Unable to Open Crystal Rpt Downloads
- Excel File Grows Huge
- formula for distribution of charges
- SaveCopyAs function
- Formula Needed
- Help With Summing PTD Totals
- Advanced number formatting of decimal points
- Summary Sheet
- Rounding a number to the nearest nickel
- Drop Down List in a cell
- VLOOKUP - table_array filed.
- How to just protect formulas in cells?
- unhide sheets
- Many Matches
- Pivot Table - Format of Date Field
- seperating one cell content into 2
- VLOOKUP and links to another workbook\tab
- Run-time error 1004
- How Do I POST to a server?
- Multiple IF AND statement function
- Different alignment for Text & Numbers
- formula needed
- SUMIF multiple columns
- Excel function for tables
- Add a number of work days to a date
- Sum IF
- Date Dependent Formula
- Multi-tier Commission Calculations
- Inverting a matrix
- Right, Len & Substitute Functions
- I need help with an equation.
- Networkdays
- Optical Character Recognition
- How to do a multiple expression if statement???
- please check this formula
- changing the pagebreak
- changing the pagebreak
- Capitalization
- Data entry date
- advanced data stripping
- Function Correction Help
- =LARGE and =INDEX with a filter or drop down box
- Button - Save Location
- AVERAGEIF ??
- Formula needed - looking up values
- Problem with file Size
- Convert likert scale numbers to percentages
- Automated aging report
- Problem with AVERAGE(IF
- Calculating next due date
- CHANGE DATES
- Extracting spaces from a string of numbers
- CHANGE DATES
- Sumproduct for 23000 records?
- SUMIF with dates
- Time: Change format
- Conditional Format
- MODE Function
- Nested Ifs - need a better way
- Adding 2 0's to an existing number in a cell
- LOOKUP looking down
- Multiplying Time Values (eg. hh:mm) by currency (eg $20 perhour)
- Quotient How to?
- Changing Collumnar fields to row fields
- cell protection
- Calculate SIMPLE interest??
- time calculations
- Conditional formatting
- Draw down analysis
- Automatic numbering in a macro!!
- Counting with Critera
- days between dates calculation
- Problem with COUNTIF
- countif
- Text and number
- runiing makros on open
- Data Validation - Alternative Lists
- Assigning Macro to Menu Option
- Can new column entries in linked worksheets be entered in the source worksheet?
- Between Function
- Adding up hours and minutes
- finding a column by searching
- Sumproduct
- SUMPRODUCT help
- To run a code in current directory
- Question about an equation
- Totaling varying cell ranges
- rounding
- Combining Functions
- Function Error result elimination
- Using countif with an and function
- Sorting cells that have numbers and then letters by the numbers?
- Advanced Filter function/method
- seperating a cell that contains 'Title' 'First Name' 'Last Name' into 3 cells
- Input Masks
- Variables in Cell References
- How to extract data from multiple Access databases to create a Pivot table
- Multiple Conditions and Multiple Solutions
- replacing character with carriage return
- Path in Excel footer
- Which Function? Show data from another cell
- Military time
- Re: Multple Conditions, Multiple Solutions
- Summary Sheet
- Deleting Duplicates in spreadsheet
- Passing parameters from excel sheet to microsoft query?
- Need help on creating a formula
- Formula Question
- Sorting Worksheet tabs
- worksheet sorting
- Vlookup
- CALCULATE FUTURE DATES
- Lookup function problem
- Cell arrangement question
- Breaking a file in different files
- Solution to "sum if used with a vlookup "??????
- NEED!! help reorganizing data...
- Nest "IF" statement
- adding text at the end of a formula
- Calculating Payroll Hours
- How to Unhide and Use Columns to the right of the worksheet
- Selectively averaging a column
- locking cells
- Variables within SQL.REQUEST
- Normal Distribution
- Please Help.... desperate
- coping Subtotal
- saving
- dual conditional sums
- Displaying hidden characters in a cell
- Re: In Excel 98 and in Office 2000 How to concatenate two separate cells into one
- Re: In Excel 98 and in Office 2000 How to concatenate two separate cells into one
- create list of files & folders
- Re: In Excel 98 and in Office 2000 How to concatenate two separate cells into one
- In Excel 98 and in Office 2000 How to concatenate two separate cells into one
- Weekdays in a month
- Linking charts from WORD to Excel
- naming
- Drawdown Analysis
- Formula Property - Referencing Strings Inside Formula Property Value
- turn $12 to $12,000
- Data sort
- rounding to the nearest quarter
- Automatic numbering
- Count the no. of weekdays in a month
- Transfering data into protected spreadsheet
- Try this one. See if you are good!
- formula....
- IF statement
- Get exact duplicate of text from another cell (Bold on and off etc.)
- changing font/style of sheet names
- Help with format/mark cell reference/dependers
- Enter key
- Excel School Grading Template
- Making Workshet Flexible
- Microsoft Loan Amortization templates - help please
- Locking cell references
- Formula help required please.
- Too many arguments
- How to apply changes to multiple sheets
- RE: In Excel 98 and in Office 2000 How to concatenate two separate cells into one
- goal seek question
- navigation
- Formulas not copyingh/calculating correctly
- Re: Add formula that excludes certain cells in the range
- SUM(INDEX()) Combo
- Date format
- calculating the average of formula results
- Conditional sum dependant on VLOOKUP
- Vlookup + CHOOSE functions
- Need a function to remove COUNTIF data
- Excel WeekNum value doesn't match PDAs for 2005
- Using Array Formulas in Named Ranges...
- mail merge from excel doc to another excel doc
- Change Default worksheet
- String Compare Between 2 Lists or Reference
- Can this be changed to VB code?
- Help with a formula
- euroconversion
- Help with a formula
- nested if help with DIV/O error
- Splitting a Cell into Var's
- Sort on a subtotal column
- Excel "MATCH" function
- Re: Returning multiple values from user worksheet function
- change background color of row until condition is met
- finding a bond coupon rate
- Can an "IF" function include a macro
- Locking a cell
- Re: Returning multiple values from user worksheet function
- Weighted Average
- Button Error - Save at location
- Protection and Macros
- Re: sorting
- Can a "LOOKUP" function be used this way?
- blank cells
- Rounding results
- Cannot change orientation to landscape
- Date controlled formula
- naming
- Lotus to Excel
- Help with Formula
- Re: Negative time values
- Make a number negative
- rounding formula
- Re: Negative time values
- how to select every fourth name from a list of voters
- Re: PRINTING AND SORTING PROBLEM
- Re: PRINTING AND SORTING PROBLEM
- cut & paste
- Making a cell = 1 if the cell => 1
- Help with Function
- Inserting a character in a field globally
- Macros in combo box
- Counting cells
- Re: Negative time values
- demand/supply curves
- Conditional Average
- COUNT command
- Date Math Excluding Weekends
- worksheet references
- Sum of 4 sheets
- SUMPRODUCT problem
- Performing a Lookup with Unsorted Data
- help with keyword/text sort?
- dissappearing tabs
- how to use replace function in excel 97
- email2
- How to Obtain information from other workbooks
- Average count of cells
- Formulas in linked sheets
- Formatting background color issues. HELP!!!
- Auto Filter
- Lookup Tables
- Re: Conditional formatting
- Navigation
- HELP
- Format a portion of cell only
- Record Referencing (linking) in other sheets
- Erase all data in an Excelsheet
- Editing Year
- SUMIF
- Conditional Formatting based on Colors
- Values not formula paste
- Sorting on Multiples Lists Greater than three
- Counting conditional format
- Calculating Time over 2 days
- Values in tables
- Sheet names as list
- Formula for Minimum Purchase Qtys
- Array Forumula Using SUM
- Feed data to different sheet
- Excel functions help
- problem with vlookup
- Unprotect Macro
- IF Function
- Quick Formula Question (optimism)
- lookup functions
- Excell Formula help
- Lookup part of a cell in Range
- IF & Lookup Functions
- averaging rows based on a cell = "value"???
- Followhyperlink - How Can I Post Over 1000 Characters?
- RE: Conditional formatting
- If statements
- Excel
- vlookup table array
- count entries between specific dates
- Conditional formatting?
- "Contains" in conditional formatting
- Operating on 'blocks' of data
- Lookup
- using TIME with decimal seconds?
- Counting occurrences of <x> in column <a> where condition <y> occurs in column <
- Button help
- Excel VBA - Coding
- Renaming data in a new column
- Cells not updating automatically
- linking worksheets
- Eliminate blanks at the end of a description
- Recognizing the Length of a Text Value
- Numerical wildcard in formula
- Formulas in a Time Study
- Digitaly sign a cell/password protect a cell
- changing calculations in a cell
- sport schedule
- Pivot Table: Multi Consolodation Ranges
- Save in location button
- Counting cells between 2 values
- Delete every other row
- Lookups with different original sources of data
- non blanks
- Auto Filter
- Random numbers with a bias
- Pivot Table: Ranking Items of a Field
- normal random variable
- time
- Using FREQUENCY - No results
- IF function
- Compare ranges
- unhide sheet macro
- Rounding to nearest 1/8
- If then else?
- Fill Cells With Specify Values
- Keeping cells clear with no data input
- Which Formula????
- Auto Hide Row/Column
- Insertng Blank row below subtotal
- vlookup
- BUTTON LINKING AND GRABING INFO
- Excel WorkAlikes
- "Formula omits adjacent cells" Error.
- Remove Green symbol on formatted TEXT cells
- How to add days/dates to a worksheet
- subtracting columns in a macro
- What if the last value is zero?
- linking rows to columns? and changing colours?
- Day of week in date
- akumar61
- Look up alternate columns
- formulas
- restore WksSS.exe. file
- how to reinstall WksSS.exe. program
- Count coloured cells?
- List of funtions......
- dependent combo box
- Cell references
- Macro Error
- Excel'97 Macro with functions Problem
- Query Formula
- Cell Row - Last Cell Entry Reference
- Concantinate Cells
- protection of Macro
- formula help
- Microsoft Excel Help
- MSNStockQuote Function in Excel 2003
- Need cell to show the largest value
- address of SMALL function result
- calling functions
- sorting
- Array Functions
- First occurrence in a series
- The only way I know to ask this - with an example -- Counting & Inserting (Easy)
- Excel
- Keeping Records
- How to Remove Extraneous Spaces From a .doc Roster Rile & Paste Into Excel 2002/XP
- Excel Formula
- formulas
- Multiple lookup
- sort multiple rows left to right
- Microsoft XP Pro Excel spreadsheet
- formulas...still trying
- CONDITIONAL FORMATTING
- Macros in Excel
- formulas
- Removing blank characters in a cell
- Extracting values from strings function
- entering text in 2 cells at same time
- Sorting Date
- Adding data in rows
- Binding Data sheets
- if my If is FALSE, do nothing an leave the current value at whatever it is...
- How to Convert a Numeric Value into English Words
- RE: deduping using Lastname,firstname,address fields
- How to return the sheet name of the cell that = max?
- Indirect range not changing
- subtracting multi-valued times in one cell
- Data Validation Lists
- Opening a file to certain sheet
- =NOW()
- Removing a hidden link to an extern worksheet
- Putting Printdate in header/Footer
- Time Functions
- Char() for Unicode characters?
- formula help
- Cascading pages in excel
- How to define "empty cell" in a formula?
- Conditional Formating and Dates
- Excel Convert Text to Formula
- Index & match vs vlookup
- Spanish row = L vs. English row = R
- Formula to find last monday (tue, wedn, thu or friday) for a given month
- formula help
- Section Breaks
- Excel formula help...please
- error macro run-time 1004
- Concatenating or Appending Text Files
- sheetname
- please help sorting
- Removing symbols from Numbers
- Using cell value as index to another cell
- Creating a date from multiple cells
- iserror help
- Excel on two screens
- Conditional Formatting with text
- Re: Ranges
- Re: Ranges
- Re: Ranges
- Re: Ranges
- excel opening multiples sheets
- Adding formatting to a formula
- Print setup: Repeat rows at bottom
- Analysis ToolPak add in
- Need formula to give whole number
- Updating second worksheet
- Referencing a cell that returns "N/A"
- sum, match, offset help
- VLookUp / INDEX MATCH "" / Null / 0 values
- Sending e-mails from excel database.
- removing empty cells
- Re: removing empty cells
- Matching in arrays (with a directional specific component)
- Total number of entries
- Printing Row cells
- Semi-Advanced Function Help
- Alignment
- lookup cell locations
- index v lookup
- Index / Match vLookUp functions question
- Unhide multiple worksheets
- lookup cell location
- Make cell bold if true
- Complex IF Statment
- How to add weekly numbers related to a date.
- Turning off Auto Number Formatting
- Pivot Table new items as bold
- what function copies data from an excel form to excel table
- formulas for YTD
- Need to know how
- excel 2003 report manager
- Cell formatting using VLOOKUP
- Use of Time when cycling machines
- I want my calculated date to exclude Sat and Sun
- How to color characters REG, GREEN, YELLOW in the same cell?
- Excell Invoice Template - Mac 1998; change cell value
- Bias in random numbers
- Re: Date/Time Format
- Question on conditional formulas with text
- Incremental numbering
- Worksheet Name
- percentages
- Consolidating values
- Insert Symbol
- Excel Function - SUMIF cells with specific formats
- Solver
- MID Formula
- How to calculate YTD totals
- adding cell locations
- Worksheet Tabs
- Help needed with isnumber multiple search array formula
- Holidays and Networkdays
- charts blanked out!
- Problem selecting samples
- Re: Default comment font
- Filtering data
- Conditional Formatting
- Multiply values with labels
- Integration function?
- inserting randomly generated numbers into a table
- Find Formulas
- Calculating range names for sum() function
- Conditional Formatting
- date time average
- Macro
- Works spreadsheet conversion
- Right-click to copy in Excel
- retriving data from list
- wildcards with vlookup
- Forms in Excel
- Calculate cooking time
- Retrieving Data from another workbook?
- linking across worksheets/tabs
- Find/Count Text
- Calculating data using references from multiple worksheets
- Right Click disabled?
- continuously adding numbers day to day
- Ye olde blank cell question.. maybe
- VBA code required
- Templates
- Counting deleted rows
- Need help with adjusting width of VBA-created toolbars
- Draft
- Consecutive Days
- Linking worksheets
- COUNTIF based on 2 criteria
- Include error checking
- What's happened to TRIM?
- automatically fill colour
- Problem with array
- Include error checking
- date time format
- Still need help with locking text in place??
- !!! okay. copying formulas!!
- IF statements not working
- Expressing a number in words
- looking for NOTRIGHT() equivalent
- comparing values
- unselecting cells
- Save Location - Date Format
- DEGREE SYMBOL
- Cannot Freeze pane (Top Row)
- ISERROR in formula
- Changing Existing Text Format
- Changing values
- Can you select pictures from drop-down lists?
- Minutes and Seconds
- conditional formatting
- Ack
- Worksheet Name
- a new VLOOKUP ?
- Auto input?
- Amortizing Term on a loan
- Daily To Weekly Formulations Down Columns
- Sum of total time in arange of cells
- Auto size row
- Extract Text Outside of Brackets
- Excluding a cell from the print area
- EXCEL REPORT SAVED FROM ACCESS
- Adding numbers continously in multiple cells
- display cell name or label as formula result
- Using "newspaper"-type columns - can it be done?
- A way to not refresh data on screen?
- Question: About using COUNTIF in a filtered list
- Excel worksheet - transferring totals to new worksheet
- Excel Formula
- Wanted to show formula result, not formula. How???
- Ranking & Sorting, but complex
- display file modify date in cell
- transfer data to next available cell?
- Auto date every Friday
- Pull First Name
- Autobackup location changing
- Read & set a start date on schedule and add weeks for monthly totals
- Search, Sum, Display?
- Mailing Label Help
- MATCH a Web Query
- Hour and Minute Differences
- Macro4
- Array Formula - Use of OFFSET function with array argument
- where to get list of names and parameters of all functions in Excel?
- Link an item to a worksheet
- Excel Solution that I don't understand
- information on combin please
- Excel indicator for when a future date is reached!
- Using Conditional Formatting with Dates
- A variation on DATEVALUE
- Sources and Uses
- Formula
- search on an excel sheet
- Problem using IF to create ranges
- =if help please!
- sheet selection macro
- Count/Counta HELP!
- Dates
- =IF problem and function help
- best way to sum or count based on certain information
- Rounding