- date functions
- linking headers and footers to multilple worksheets
- Finding and extracting
- coping and paste
- Array / fill down question
- delayed calculation
- Using VLookup to Import Data from Access to Excel
- delayed calculation
- SumProduct
- Eastings & Northings
- Date with Day of Week
- countif function possibility?
- Vlookup Issue
- A comparison function
- Formatting results =0 to dashes
- Auto enclosing a value in brackets
- IF function driving me insane - HELP
- Data Validation: two conditions
- Problem with Formulas
- Excel Templates
- Error Msg: Extract Range has a missing or Illegal field Name
- vlookup hassles...
- SUMPRODUCT
- Hours and minutes question
- Edit many hyperlinks
- importing data from quickbooks
- Deleting Range Names
- Find last value within a range of formulas...via a formula...
- vlookup formula appearing as formula
- Same thing
- please help
- How to calculate someones age from today?
- XNPV Function for office 2004 for mac
- Autocomplete on part of a sheet
- Ration
- clarification on countif
- VBA macro auto run by time help
- Help, Help Help
- hlookup within a conditional function
- Sort order in Excel
- Birthday
- newbie question
- Macro Recorder
- Ratio's
- Automatically entering sheet names into a range of cells on one sheet
- Summing in a sentance...
- Can't open columns
- Calculate hours
- Forumals within a sentance...
- SUMPRODUCT Worksheet Function
- adding a text prefix to an entire column
- Re: Macro Problem
- HLOOKUP as used ina formula for invoices
- combining like data
- random variable with normal distribution
- Formula question with Text
- macro problem
- Counting unique entries
- formula question
- sum total
- Re: Max Formula
- Excel data from Column to Row
- RE: Max Formula
- Re: NETWORK DAY Formula
- Task pane for copy
- filling series problem
- Pre-Loaded Cells using Drop Down Menus
- specifying and summing across a range
- percentage
- Limit text length to the 4th decimal place
- Current Date in Cell
- Difference
- RE: delayed calculation
- Total time duration formula help;
- filling a series down the column
- Add leading spaces to text
- Price List & Model # Build Up
- Formula Please
- Graphing In Excel
- conditional format and rounding error
- locate and highlight formulae
- Re: PLASE HELP!!
- get the location of a maximum in a row
- Overlaping Hours
- I dont want to copy hidden rows
- Referencing cells
- Reference formula identified as Zero
- Summing excel spread sheets
- entering data into a cell
- Move between sheets & keep a running total
- vlookup
- Macro to delete Macros?
- to format cells with colors
- Formula for mahing this calendar
- Sorting rows and including data below it
- Filling a series
- Removing Spaces
- Text using the French and/or Portuguese alphabet
- Cannot introduce function referencing to cells in different sheets
- Pivot table reset
- formula based on another cell's formula
- problem when drawing textbox in excel using macro
- PV function
- Splitting data?
- function and formula required
- averages
- Comparison Function, Help Please.
- Help updating other cell
- Help with linking???
- MACRO HELP
- Linking HELP!!!!!!!!!!
- Variables in Macros
- Vlookup error - overtype text
- filling a series down a column
- Timestamps
- Fill Series Command
- Re: How to find the last occurence of a character
- Re: How to find the last occurence of a character
- Need a REFERENCE as an output
- Re: How to find the last occurence of a character
- Have I got a blank cell
- Counting in excel
- Average
- Condition Function
- "delete" function
- How can I make a Hyperlink relative?
- Concatenate with carriage returns
- If statement to compare months in a date
- summing values in one column that are referenced to values in another
- If/Then formula?
- cell functions
- Autofilter: Save a custom sort?
- Excel Table Lookup
- making certain text values go colour red
- calculating (correctly) the weeks and days between dates
- summing back to a changing but 'set' #
- Converting Equations
- Multiple Qualifiers
- Conditional formatting times with VBA
- Re: Copying data from a number of sheets into one sheet
- Specify length, affix to prefix
- Re: HIdden Sheet where is it
- Using functions to count date format data
- COUNTIF Fuction in Excel
- Calculating the difference between dates
- Delete Left Character
- How to open a file by pressing a button ???
- Cubic roots
- VLookup with multiple matches - need to combine
- HIdden Sheet where is it
- SUMIF
- Min value but not 0
- source file links
- adding up limited items, formula needed
- Message Prompt
- delete all text to the left of...
- Data Validation
- ISNA/Vlookup function
- Sort one list acording to another
- Leap Year
- Drop Down Menus
- RANDBETWEEN() Function problem
- Changing color of font in IF statement?
- Urgent!!! Need Your Help!!!
- macro
- formula errors driving me insane
- Round Up Numbers to Nearest 500
- Thanks Julie D. (summing excel spreed sheets)
- Calendar Formula
- Week to Date Sales
- Summation Formula Help / Data Validation Question(s)
- Summation Formula Help / Data Validation Question(s)
- Adding #s relating to an entry
- There must be a better way?
- select column base on criteria
- Last cell in range
- english - french dictionary for functions
- Alt 0178
- count time
- Count frequencies; Pareto of nonumeric values
- displaying results of minverse
- Formulas dont uppdate automaticly?
- exclude highlighted numbers from calculations?
- Missing XLODBC.XLA for Excel 2003
- if functions with positive and negative numbers
- sport tables
- Average excluding zero-value cells
- Duplicate Part of a cell
- summing question
- adding back leading zero's in a zip code
- Listing of data from database
- Converting a Value
- Help
- Random Sample
- Hyperlinking rows labels with column labels between 2 sheets in same workbook
- sumproduct
- Hlookup or vlookup help
- multiple conditions for sum if function
- Sorting by hightlighted cell
- Count Cell w/ Any text
- Formula is sending me over the edge
- Do not show 0 (Zero)
- remove a zero value
- Invoice Template, Incrementing Number
- simplest Array formula needed
- List of Worksheet Name in a Workbook
- Remove Spaces from String
- When Overtime is given, reduce night hours
- Deleting duplicate rows.....there's more
- MACRO VALUE
- Formatting Cells
- File copy bar.
- Re: I need a formula to assign a number valu to text!(new user)
- Can you sort by color?
- Linking Workbooks in Excel
- how to convert number 20000321 into date 03/21/2000
- Trigger a specific macro to run
- MACRO VALUE CLARIFICATION
- Making relative references absolute
- Re: Making relative references absolute
- Default format for "comments"
- finding the next non-empty cell
- percentage help
- collating team/game scores
- Help with Inbedded If statement
- Pick a number/test from a list
- Flipping data from columns to rows
- Linked source file mystery
- Excel Time Question
- Drop down reference
- Juan ,your the greatest...but...!!!
- Advanced Filter not using formula value in criteria
- Juan, I wanted to open a .doc file (my mistake)
- stock indicators
- military time
- Hard-Returns within a cell...
- table formula needed??
- Copying
- a better way than multiple if conditions
- multiple criteria formula help
- IF function
- Blank Cell
- Importing csv data that is time based
- If statement
- Need help with percentages in Excel2000, Please!
- Counts and Percentages
- log 'e' function problem
- Excel displaying American date format on imported data
- functions & formulaes
- Traffic Lights
- Divide by Time - ?
- easy formula
- Reference a tab???? Can it be done???
- conditional formatting
- Easy question, I hope
- Delete numeric part of a string
- Linking Excel to word
- Convert text to numbers
- Showing Invalid data
- Text & Numbers in Cell
- Removing Hyperlinks
- copy formula down to end of worksheet
- Autofill alphabet series not possible in Excel?
- Copy down to end of data
- Re: Copy all values in worksheet....
- linking source document cells to corresponding worksheets
- Re: like watermark in word
- Simple Code Help
- Simple Code Help
- Excel date and time calculation
- Reference in a text
- OR statement inside a COUNTIF statement
- Combo of forumals
- External reference
- Question re: Sum formula
- Data Validation
- refering to checkboxes in formulae
- Password protect
- Re: Is there a way to hide a '#N/A' result?
- Re: Is there a way to hide a '#N/A' result?
- lookup
- looking up prices from 1 worksheet to another
- VLOOKUP problems
- Changing numbers
- Lookup the first in a series of numbers.
- Conditional Median calculation from a database
- Re: Text to Columns -
- error
- vlookup
- Date question
- Excel programming
- Time Question
- Adding a coma to the text data in every row of a column
- Eliminating duplicate records in consecutive rows of a column
- Re: Combination of Numbers
- pull down menus
- If statement
- Cut and Paste is messing up my functions!!!!
- RE: Counting a 'picked' range of cells where a < value is in the middl
- try again, maybe 3rd time lucky,,collating game scores
- link to sheet
- 3 Formula Questions
- Is this a legal formula?
- testing please ignore
- Formula help req'd
- start excel and decimal point
- EXCEL FOOTER: Last Modified Date
- Can Excel fiind Deteminants of a matrix?
- Drop down field
- Need help on opening file through input once more !
- merging data between two tables
- Pick out items in repeated list
- help
- Please help!!! - Counting if 2 conditions are met in 2 different ranges....
- reverse pivot / transpossing
- Merging Data from other tabbed pages onto one sheet
- if then statement
- Delete Rows and Parse Data
- Importing workbooks as sheets
- if/then again
- Held with YTD formula
- if then for a third time
- PRINT PREVIEW
- Excel formula bar
- Can I add this to a Macro
- Nested Function Calls
- Need formula to negate
- Is this a bug in excel???
- DSUM between criteria
- Formula Syntax - What it means?
- Column width change in large spreadsheet
- Decrementing a text string
- Rounding in spreadsheet
- Percentage Formulas
- Help with INDEX Formula
- A Date Stamp function that executes itself?
- Formula
- copy results of formula to another cell
- sumproduct
- what if formula
- F7 wipes cell contents
- Sumproduct
- Drop Downs
- commentary on drop down list
- Microsoft Excel 2000
- Microsoft Excel 2000 function help
- solution to reference closed workbook
- Determin Cell Contents (Text) using VBA
- Formula
- Create Date
- Hyperlink Question
- Help with data ranges
- Re: Count maximum consecutive positive numbers
- Forumla Help!!!
- Pasting Links, Preserving Formatting
- Sum.if()
- Cycling or just nothing doing
- renaming cell
- Re: Combination of Numbers
- Formula Help - Sum 2 lowest values in a list
- Code Help
- data lookup and data fill-in ?
- Formula arithmetic
- time arithmetics
- Splitting cells to columns
- Wildcards
- VLOOKUP #REF
- Re: Function to return font style
- Average fonction!!
- Help with Eval function
- cell contents
- Cell backgrounds
- help please
- text formula needed
- concatenate 30+ cells
- Re: White Check Box.
- How do i display contents of one cell in another?
- Help With Linking Worksheets
- function to divide data in one cell, into two cells
- Variable Commission Schedule
- Code for "Do Not Save" Book1 in visualbasic macro
- linked worksheet
- hyperlink in drop down list
- conditional formating
- drill downs
- Type Mismatch Error
- Function not Recognized
- Create function to round all numbers in a column
- Pick List
- Formatting Account Number
- Excel Macro
- Problems after installation of 2002
- Excel2000 - Worksheet_change does not fire on insert
- IF Function
- Sum the results of a lookup
- Which formula to separate data in one cell to two cells?
- 2 Dimensional LOOKUP
- Record sorting
- LOOKUP Correction!
- Creation Date
- Replicate a business model by starting at the beginning...
- Indenifying Text in a formula.
- Calculating duration between two months
- Countif extension
- Alphabetical autolists
- VBA or Function?
- Greyed out
- Formula
- Using IF statement with AND?
- Normal distribution
- Input cell also is a calculation cell
- Need help creating FILTER
- Identify Blank Rows
- Re: how can i add up the total of name cells?
- how can i add up the total of name cells?
- Subtotal function with mixed calculations
- Lookup function
- counting w/subtotals
- Code Help
- Re: Date setting on Header
- Whats Wrong with this Formula?
- taking noise out of data
- Sumbycolor of visible cells
- Subtotal (109,..)
- Cell pointing to Variable directories
- Remove border line of a few cells
- Date sort before 1900
- Need help summing sheets based on a variable
- Divisible by 3
- Lowercase in entire worksheet
- conditional formatting based on values
- Y N & N/A HOW TO TURN A SERIES OF THESE INTO A FINAL SCORE. Please Help :o)
- Format in worksheet function.
- Nested IF statement
- IF statement
- Removing digits
- Network Hyperlink
- Re: Change two letter code to full word
- same range name, multiple sheets
- easy way to do a find and replace in a column?
- Array (Control Shift Enter)
- Change two letter code to full word
- finding hidden answers
- numbering copies
- Re Array
- Sumproduct Function
- Pls help with if statement
- Lookup in Excel
- VLOOKUP - Need Reverse?
- 4digit numbers rolling using "SUM"
- IF statements in a VLOOKUP function
- Excel Header
- Minimum value based on a range
- Countif for two conditions
- Returning values in a table
- removing part of field
- Accidental save
- Spreadsheet printing
- if statement limit??
- FORMAT-CELL-ALIGNMENT
- How do you nest VLOOKUP in multiple IF functions?
- Using IF function to Sum up Variable Commission Earnings
- Convert Date to text - (Very Urgent)
- Excel Auto-Convert my text to date
- Countif
- Vlookup multiple results
- date and time with if statement
- Printing Hidden Columns?
- Changing default Paper Size for printing
- Maximum of 30+ values
- Duplicate numbers in column
- Is there such a formula?
- NETWORKDAYS but counting the hours not the days...
- Advanced Filter: what are the
- Advanced Filter: what are the
- Lookup and Bold Values
- Re: Clear content in the cells with same format in Excel
- MAXIMUM VALUE PROBLEM
- Extracting Parts Of A Cell
- Finding 2nd, 3rd, 4th and 5th Maximums.
- Excel saving as Tab Delimited
- Re: "OR" operator to evaluate multiple conditions
- Re: "OR" operator to evaluate multiple conditions
- Counting duplicates\Frequency of duplicates
- adding a percentage
- Protect Worksheet Name
- Re: How do you set up a series of dates in order
- Re: How do you set up a series of dates in order
- Excel Macros including Outlook
- Chart Examples
- wildcard is not working?
- Help with VLOOKUP searching blank cells
- Conditional Auto-Population
- Formatting text in a data validation drop-down
- Displaying Cells on a Different Worksheet based on Criteria
- Synchronised combo boxes
- PDF files
- weighted average
- perform search through all worksheets with one formula
- underlining
- Sorting Worksheets
- Removing Part of an Array
- Formatting a cell w/"@"
- Formula Problem
- Date Picker Control
- Rate function problem
- COUNTIF help
- Calculating age
- Whats the best way ?
- Re: How do you set up a series of dates in order
- Count of File Opening
- Re: How do you set up a series of dates in order
- UN-concatenate
- Re: How do you set up a series of dates in order
- Format 200000 as currency within concatenate statement
- Sum of data base on current date
- highlighting
- Re: adding worksheets
- Re: How do you set up a series of dates in order
- Return Empty Cell/Blank
- Re: How do you set up a series of dates in order
- averaging of unique data
- IF Formula Returng a FALSE value
- Using criteria in an Array
- DSUM, Here it is.. attack!! -:))
- Add space between columns
- Filtering
- Help with a function
- Counter
- Count with multi criteria
- Formula Help
- Sorting and linked data
- Vlookup Formula to Macro
- Re: How do you set up a series of dates in order
- Calculating a change
- Excel query not picking up new data
- Counting with multiple criteria
- Sorting
- Time Formula Explanation Please
- Counting based on multiple criteria
- help with countif function
- Re: automatic counter
- Adding hours
- IF problem
- how to find paired values in one column
- Problem opening a sheet with macros
- Possible to shorten a sumproduct formula?
- Add Sum of 2 Range Names
- Bullet marks in Excel
- How to find paired values in one column
- Duplicates
- Date formulas
- dropping number
- Pivot Table ??
- Regarding copying
- Re: Validating first letter?
- Validating first letter?
- Absolute reference within a formula not really absolute
- Protecting a Calculation Cell
- Formulas
- Undeliverable message when sending to Routing Recipients
- creating a general input form
- Function is suppress #VALUE! ?
- last value in a column
- engineering exponents
- Conditional Formula
- Re: how to create a general input form?
- Using names from "insert name paste" in formulae
- Specifying color to different text
- Help - How to make worksheet recalculate for chart
- Re: Inserting rows
- Re: create a general input form
- Re: Using List Boxes in Excel 2003
- SUMPRODUCT() worked then broke
- Concatenate
- SUMIF vs SUM(IF(..)) vs SUMPRODUCT
- Re: FUNCTION "DATE" & "AND"
- Re: FUNCTION "DATE" & "AND"
- Automation? Database?
- SUM Problem
- Sum Problem
- cell shows unwanted default date
- Last Modified Date
- MCONCAT
- Change cells containing links to files to Hyperlinksl
- Sum Values on a condition
- Re: Sum Values on a condition
- Set a header/footer as default
- How to read/copy PageSetup properties of a sheet?
- Referencing Ranges on Multiple Sheets
- Formatting cells as text
- Autofit Columns during Data Upload to Excel
- VLOOKUP OR OTHER
- Finding Average Times
- Change date to text
- Excel VBA - get worksheet name
- Pivot Table Resizing
- sumif
- Countif Cell Contains A Portion Of Text
- Combining Worksheets with inconsistent data
- dsum? or sumproduct? how?
- What function would I use.
- cell function
- lookup
- Moving Cells
- Re: "OR" operator to evaluate multiple conditions
- Too many cells selecting
- Rename worksheet
- A Fun Formula
- Whats wrong with this code?
- Comment Box
- Time and Hour Calculations- Help Me Fast!! Please!!
- Re: Time and Hour Calculations- Help Me Fast!! Please!!
- IF Statements
- Need Help Please
- Colors Changed on Scroll Bar
- How do I round Up to the nearest hundred?
- Formula HELP!!!
- Nesting formulas
- blank cell reference in formula
- Further Help
- Choosing a Text Value from a String
- Merging Col A and Col B in Col C including blank cells
- SumProduct & Index functions
- Shift+Ctrl+End
- sum a constant value..
- Count of different items in a range
- String Dates
- hexadecmial to binary conversion
- Countif question
- Re: 'do without loop' error
- Re: vlookup, two worksheets
- numeric conversion
- SUM every other row in a column
- Copy / Paste without changing column width
- Worksheet Help
- ***Number "1" appears when finding "=networkdays(xx,xx)" of the same date
- sum of hours
- worksheet changes
- If, Round down help
- deleting macros
- Re: extract last 3 digits of a number for calculation in EXCEL
- macro help
- Re: character specified problems
- tough one ...combining cells in a unique way
- Excel Lookup Question
- COUNTIF cell contains CONT'D
- #VALUE! error when I get MSN MoneyCentral Stock Quotes
- Finidng vlaues in a table.
- Drop-down box for name and address?
- Re: Indirect formula definition
- Re: Indirect formula definition
- is there a way....
- Hidden column password protected
- Subtotal: Min / Max Offset on Filtered Visible Cells?
- DSUM OR SUMPRODUCT?
- Excel Macro
- I need to Sum multiple columns by referencing one formula.
- Saving Excel Workbook as WebPage thru VBScript
- Data validation input message
- obtaining age from dates
- Macro with sound ability
- ...Concatenate, but more
- calendar to 12 month calendar
- formula to find if range contains a particular value
- Function Help
- Go to column heading on start where column heading matches Today()
- Go to column heading on start (retyped)
- drag a cell down in a column
- Deleting blank rows
- gather criteria from multiple workbooks into 1 workbook
- Excell rejects my formula, how do I fix this one?
- Sum and rank with condition
- Need help- OFFSET MATCH syntax problem
- validation list output
- formatting cells to show negative numbers
- SUMPRODUCT
- Formula for next month
- Excel Function Challenge
- update a worksheet thru a link
- Countif with 2 or more data ranges in same column
- find the first Monday in June
- Marrying to Formulas
- SUMPRODUCT Minus Minus
- Look up problem
- Cell Value by Result
- if function
- Subtotal by rate within class
- How to display the first and last dates in series of dates?
- loosing formula from excel to pocket excel
- Converting paragraphs to seperate columns
- sheet help
- separating firstname & lastname & turn all to capital letters
- 15 day moving average doesn't update.
- Set Cell Value by Result
- Re: sumproduct?
- Re: sumproduct?
- Nesting with Sumif?
- Calculating hours
- Old Excel Naming
- Help on If-Statement
- Help with .RANGE(Cell syntax problem
- multivariable regression (t-stat)
- Shading rows for easy reading of large reports
- Random hexadecimal number generator
- Do an array operation if it doesn't result in an error
- Re find the first Monday in June
- conditional formating
- update combobox with sheet names
- too many cell formats
- Selecting/deleting empty cells
- how to find a merged cell in a worksheet?
- IF Function
- Re: Random hexadecimal number generator
- Re: Random hexadecimal number generator
- Excel comments - possible with relative cell reference?
- Excluding more than one top rows from filtering and sorting
- replacing #NA with 0
- Counting Cells by Thier Month
- Data Validation drop down arrows Excel 2002
- How do I format
- Page not available for help file
- Frequency FormulaArray Syntax
- Formula Syntax?
- Deleting a Link
- Definition of function on one place?
- Recalculation
- Excel column data representation problem
- Hidden rows not included in formula
- Nth Position of Occurrence in a List
- Subtotals
- Adding a column in Excel
- smallest numbers
- Changing and saving values on a Pricelist
- Cut spreadsheet
- Separating a list
- Separating a list
- A Blank in a formula
- Conditional Formatting
- Counting Workdays & Sundays with Holidays
- Excel-Sharing contact data with Outlook
- 28 day reporting
- XML Files
- Downloading Credit Card Statement
- SUMIF with multiple conditions
- comparing list of names
- Microsoft Tutorial on Excel
- urgent! how to compare values in two columns...
- formula error triangles
- date format in IF statement