- Avg every other column IF a value
- Macro forr Worksheet names
- Conditional formatting to change colour based on part of a cell
- Need Help with automating Excel
- Excel macro !!
- Help with date time function
- Peo Sjoblom: multi lookup
- Caculation difficulties using linked sheets
- Data Summary in new sheet
- Protecting Individual Cells
- 2 Criteria Count and Sum
- inserting rows with same data
- Is there anyway to permanently disabel
- Averaging with #div/0! function
- Sorting in numerical order when numbers and alphas are used
- Comma after City
- Placing the "&" symbol in an excel header
- Inputbox in Excel 2000
- excel and email (try again)
- Need help with Text Functions
- Excel Borders
- Tri
- Re: Data Summary in New Sheet
- Calculating highest Consectuive years out of 10
- Array to produce sum
- In IRR period in data flow compared to period in result percentage
- SOS-Needing help in performing a what if analysis
- combo forumla help
- filling formulas down a lot of rows
- SUMIF with AND and OR
- Two Sheets on One
- Phantom Links
- Adding an alert/flag
- SUMIF times 3
- Changing characters into numbers
- Fill across several sheets in a workbook
- Sum if
- SUMIF Equations
- Worksheet function "contains"
- troubles with time
- Formula Calculations
- Drop Down Box
- Linerar equation woes
- Strip Character from Right
- External Data refresh query
- Calculation on cells formatted hh:mm
- How to get PROPER to maje exceoptions
- mail VBA/macro
- If Statement
- From HTML open a specific worksheet within a excel file
- How to get PROPER to make exceptions
- I need to activate a cell within a macro and am having difficulty
- Help with Advanced Filter Comparison Criteria
- troubles with my Poker Tracker
- Text not fitting in a cell
- How can I keep "#N/A" values from appearing in VLOOKUP results?
- Named Ranges
- max formula
- Rank function returns '0'
- summing number of date entries in current week
- drag of vlookup function does not work any more - arrg
- "File" menu item disappeared from "Worksheet Menu Bar"
- Microsoft Excel 2000
- ç (c-cedile)
- Conditional formatting
- computing numeric with text
- Function Evaluation not what I want
- Won't divide
- How can I avoid typing the (:) when typing in the time
- =If(text)=1,0) - approximate format required that works
- build a temp for payroll with different pay for different job
- TEXT=1 formula needed
- sort distances in feet and inches
- Extract Multi-Sheet Values into a Summary-Sheet
- need function help
- Trying to get a new formula
- Can't work formulas in sheets copied from the web
- Simple Macro Question !
- Problems using Excel 97 worksheet in Excel 2002
- time difference between 2 different time values
- Dividing function: can you define the decimal place?
- Can't work formulas in sheets copied from the net
- Fitting long text
- Making CurrentRow a lot 'clearer'
- How I can multiply between text and number?
- Combining IF with AND
- how to do conditional formating for a row
- Systematic Sampling - Data Analysis
- sound activation
- Excel Formula's
- Excel-lookup and go to next line
- Prevent access to macro's if sheet is password protected
- AVERAGE of row gives no result
- microsoft excel version 6
- Rank
- Help, Formula Problem
- Problem with NOW() function
- problem with formula
- SumProduct with AND inside....deos not work
- using IF & AND functions in conjunction
- Trying to count the number or customers of type x for subsequent time intervals
- total worked hours for a week
- Cond format a range - minimum value
- Jessica, Payroll Template
- sum of values in an entire workbook
- Index & Match versus V & H lookups
- Mutiple line display in cells that contain formulae
- Formulas not working
- Copying automatically to the next free cell
- Get rid of Duplicates
- blank cells
- correct formula
- lookup?
- Securing formulas
- Repost - Using SUMIF and COUNTA
- EXCEL and OUTLOOK
- writing my own Function - cell to contain "A" or "B"
- filename in Excel
- Formula help needed.
- Problems with columns, macros and auto filter
- macro to automate procedure
- Lost in Overtime Computations
- A macro to open files, refresh data, and close file in background?
- Protecting multiple worksheets easily
- Re: Help Please
- Decimal Place Problem
- Re: Help Please
- Format cell using Validation rule
- Repeating formulas for an enitre column
- ADDING ROWS TO AUTOSUM
- Can Validations and Hyperlinks Co-Exist?
- Weekday
- Count number of occurances in column
- Margin of Error calculation
- Time Sheet in Excel - Formulas with Breaks
- repeating macro
- PLS;HELP TO RANK STUDENTS POSITION
- Just the month
- Macro to save all worksheet and exit?
- VLOOKUP Date Value
- covariation
- Finding Duplicates
- Merging Workbooks
- formula for balance & over expense amount
- Deleting Macro Buttons
- macro to save as a unique name each time
- Excel AutoFilter
- Macro error at cell:
- Drop Down List
- Bell Curve
- Excel 2002, If Functions Problem
- copying collums of formulas within a worksheet
- macro and insert rows and count
- Removing Macro
- Excel wizard needed here...
- COUNTIF or SUM with nested IF's
- Cond format using MIN
- calculate date difference and use result as condition
- greater than function
- cell=sheet name
- Re: Drop Down List
- sum of values that fall in a month
- find first positive value in a range
- Calculate % of responses
- Extracting numbers only
- Date formatting based on criteria
- download Data Analysis?
- Combo box - spreadsheet for ordering stationary
- Referencing problem
- HTML Links Close Worksheet
- Frank: thanks! and another query..
- Number Conversion
- sheet name
- how to improve this
- Formula Help
- simple formula, excel/VBA
- scrolling problem
- Vlookup not quite what I need.....
- Developing a contents page using the tab headings
- CODES
- No of days in a year..?
- Find last value in a list
- ROUND TIME TO NEAREST QUARTER HOUR
- "Average If Not Blank" Formula
- Concatenation giving #VALUE error?
- COUNTIF help needed!
- Counting Rows with SumProduct
- Constants or How not to increase pointer cell automatically
- Side by Side Worksheet Functions
- Help With Named Lists
- Counting the # of occurances in a column
- exporting Excel to Access
- COUNT Function
- Countif formula
- Table of Contents
- Between
- inverting text
- populate a list based on whats a user picks in a cell????
- Excel Lookup Problem...
- Sort by more than 3 columns
- Find Function
- help with array entered formula
- Cannot shift objects off sheet
- Calculating periods using NPER
- Sorting, HELP!
- Trace precedents (Excel XP)
- Formula for Faxing through Outlook?
- Is this formula correct?
- Sorting More than 8352 Rows
- Re: Need Help with Formula
- Newbie: Counting the number of words in a column
- IF Formula that looks at a list
- SUMIF and dynamically inputing info
- Quarter Date function
- Filling a Formula
- Monthly payment cells
- Re: Need Help with Formula
- How to make a fill-in Cell remain Blank when using Vlookup in a complex formula...
- Searching a list for keywords
- Making control invisible crashes Excel
- Re: Newbie - need to validate an entry in cell
- vlookup
- Microsoft Access
- Access
- 3-d reference formula
- Advanced Filtering Criteria
- Dropping test scores
- OT: Only in Texas could this happen
- Finding characters
- 3D look up. Help
- Adding new rows to a list when Protection is on
- Display alert
- Is LOOKUP the correct function for this
- data to chart
- Excel 2003 can't change cell color
- Please HELP...nervous wreck time calculation
- still #N/A formula doesn't work
- Vlookup ?
- IF Function and the use of Wildcards
- Find highest value in column
- clear contents of copy
- MAX function and "visible cells only"
- Using 'Median' with array formula
- Colours
- Calculate a checksum (e.g. md5) on a group of cells
- Autofill Worksheet Names
- Averaging Only Positive Numbers in a Range
- Re: Display in italics
- Re: Averaging Across a Range - Only positive numbers
- formula assigned to a variable
- Round data to millions
- countif range then "* cell value *"
- Personal.xls
- changing text to text according rules
- Reversing sign of a positive number
- Mulitple COUNTIFs ?
- Workbook settings
- extract last 6 characters in a string
- Formula Question
- Macros
- Change text in worksheet to all caps
- Re: Computing Averages Excluding Blanks
- Re: contents
- Re: Computing Averages Excluding Blanks
- can worksheets be linked to create a workbook
- Hyperlinks between Excel 2000 and 2002
- Merging Workbooks
- Converting worksheet to template
- Drop Down List
- Re: Tab Name in a workseet
- Re: Tab Name in a workseet
- RE: Tab Name in a workseet
- IF Statement Help
- Drop Down List
- Link to PowerPoint from Excel
- combine "if" with "and" function
- Performing conditional calculations based on character strings
- Formula help!!
- formula error
- Vlookup returning a text value
- sum cells in a range that are color index = 3
- capitalising names
- Formula
- Static Date in Formula
- Re: Counting Dates
- Index / Match? Formula Help Please
- cell names
- IF Statement Help Please!!
- Repeating 'SUMIF' formula for entire column
- RE: Counting Dates
- Re: sumif (using two agruments)
- Formula displaying in select cells
- Re: help with time
- Use dropdown list to display more than one record from a table
- Re: Pull down calendar
- Trouble with Check Box(es)
- Character limit
- Workdays (inc Sat) formula
- Ignoring null cells.
- RE: Need Help with Formula
- Multi-Variable tables
- help me
- Re: Text functions
- Re: Text functions
- thanks
- Re: Text functions
- 2 File If Statements
- countif problem
- vlookup not working on bottom cell of column list
- Trying to Auto-Fill Months
- Counting Pattern Occurences in Multiple Rows
- Rounddown
- Linking group of Option Boxes to Drop-down list values
- Advanced Filter List Range from within a Macro
- Re: VBA RATE Function Error
- DATE Functions???
- array Formula for date counting
- Subtracting. From a Sum total
- Data Filter
- Please help!!!!(merge a number of rows)
- Can OR(AND be used for formula in conditional format
- Formula help
- date...
- Absolute reference to column, row
- How to kill screen tips on objects?
- Re: contents (re-post same day)
- checking for certain codes
- Exclude non numbers from list
- Seperating data from one cell to many within one record
- Multiple combo boxes
- Hide zeros in pivottable
- Is a "Kill the Worksheet" command possible?
- Multiplying time
- converting text to custom zero
- How Many Worksheets can a Workbook Contain
- Range Totals?
- Copy Data without Including Hidden Rows/Columns
- Audit Tool
- Excel SUM error
- conditional format across cells with text
- Combining / Merging Excel Reports
- Help Hide Looping Process
- Past increase in value
- Need help with using date as criteria for sum function
- Unabe To Record
- VBA code for current month
- Sumproduct help
- Adding Dates Help
- Need cell to be formatted as a number with a leading zero
- Re: MIN IF & STDEV if
- Re: MIN IF & STDEV if
- #Value in cell
- Addition of positive numbers
- Calcul of the duration
- Count, sum, count if, sum if ...confused
- Second & Third Sunday Of The Month
- character limit
- Copy Rows in Excel XP
- EXCEL HELP!!!!
- Linking worksheets in a workbook
- Average of two sets of dates
- Absolute/Relative paths?
- Re: Sum problem
- Offset
- Handicapping
- Date Validation
- Can multiple items be picked from a "list"?
- Iteration values
- vlookup and multiple columns
- Formula result = Volatile
- Re: Sum problem
- Time Extraction In Minutes
- Formula for percentage increase/decrease problem
- Excel Table into a Word Doc
- Macro to track data
- Inserting a special function
- Copy one sheet mutiple times
- Adding Excel Patters and Symbols for Charting
- merging data from multiple workbooks
- Pivot Table
- Pivot Table "Show All" Check Box missing in Excel 2000
- Cut and paste part of a string in VBA
- Re: count instances of one criteria withing results of another criteria
- auto fill cell -2 Weeks from a static entered Date.
- leading zeroes
- Logical condition
- Re: count instances of one criteria withing results of anothercriteria
- Conditional Formatting
- sumproduct not working
- Pivot table and IF statement
- [2003] Averaging a bunch of cells
- Date Averages
- Re: vlookup not working on bottom cell
- format validation list value
- Re: vlookup not working on bottom cell
- stop other parties to delete a spreadsheet
- formatting columns
- Macro Command
- {=TABLE(,G1)}
- Why does this macro not work?
- excel file linking
- Function palette
- sumproduct with ="abc*" criteria
- formatting cells
- Formula not producing correct result
- Formula works in some cells of a colum but not others?
- getting highest value
- Simple Question
- cell limitations
- re my previous message formatting cells
- Averaging data after using autofilter
- Cell range
- vlookup function-
- Constrain of "Linest" function
- Conditional Formatting, Formula is: =ISNA(A1)
- Counting No of Worksheets
- macro search error stopped macro run
- Partial Lookup/Match
- VLOOKUP - Excel 2002 w/sp-1
- Excel2000: Data validation using values returned by named ranges
- userform and textbox
- Count of occurances within another count
- League table
- find failure stops macro with run time error
- Time Extraction
- Access2000: Copy a range of rows to another range of rows using VBA
- adding months to a date value
- link
- Time Extraction One More Try :)
- Automatic Percentage Insertion
- Sorting By Sub Totals?
- Saving only one worksheet in a multiple sheet workbook
- Summing based on two criteria
- Last updated time for cell
- Lookup Tables
- cursor color
- LOOKUP/IF formula
- "if" function problem
- Conditional Formatting for Dates
- Formula is too long.
- Listing choices on worksheet
- Exponential Moving Average
- formula to copy
- Multiple rows to one column
- How do I reference a cell in another worksheet
- database with hyperlinks
- Excel Column Data
- Summing highlighted cells
- RE: Range Reference in Formula
- Sorting Work Sheets? How?
- Double Lookup
- Variable reference within a formula
- If formula
- Adding data from cells in multiple worksheets
- Calculating differences between two dates with time.
- Chart Question
- Conditional Formating
- Phantom clipboard info
- VLOOKUP with changing hyperlinks
- Column Wrapping???
- Deleting part of a string in VBA
- Lookup And? Need formula help
- Help! changing colour of cell if true
- Formatting colums continued
- Sorting after a Vlookup on a diff page
- VBA that mimics Conditional Formating
- Mode function gives single result
- oops...forgot something
- Tab Color
- Excel Countif
- variable reference in hlookup array
- change height dropdown list box
- Color Index Number
- Offset with a link
- Array Entered formula not working fine
- Formula
- INDIRECT does not seem to work
- Script needed for macro
- List
- Add Tel # area code to column list
- Replace cell identifier in long string formula
- Date Problem
- Drop-down List
- Values in drop down box dynamic
- Problems caused by numbers formatted as percentages
- risk assessment
- Array formulas to calculate the five highest consecutive years
- Challenging Question - Troubleshooting Formula
- How to total cells in a range with data input
- Mail Merge with Excel and Word
- Font progressively moves upward out of row when printing
- Hours worked x hourly salary
- default value
- using VLOOKUP with two table_array
- All UPPER CASE to Upper & Lower Case
- How to eliminate % totals in a Pivot Table
- How to grt excel to count 2 numbers in a range
- Conditional Formatting
- formating a range of cell to have the = function
- HELP PLEASE
- adding hours that exceed 24hr
- hours before midnight
- vlookup returns N/A
- VB help
- Sumproduct as a Pivot table
- date time =now() function
- Filter Question?
- Counting Unique Values
- Ping Max
- Count with three conditions
- formatting columns
- Formula Question
- Excel 97 - Performance Projections
- Multiple use of lookup - Tough one?
- reference a value from a different worksheet
- Windows task bar
- insert data from seperate worksheet into seperate colums depending on list selection
- Formal Function
- Automatically fill in cells?
- lookup & reference
- Task Bar Windows in Excel
- Averaging autofiltered data
- Fill Color in Functions
- Vlookup: 3 columns to 1
- vlookup
- MACRO TO SAVE & EXIT ALL WORKSHEET/WORKBOOKS
- Vlookup Function Help
- RANK FUNCTION
- using countif
- How do I COUNT from 2 different ranges
- Summarising a recurring list
- how to auto change file name ?
- Setting the value of B1 from A1 using a formula?
- Duplicates
- A few things please
- cell reference within a list
- Pagebreak
- Offset help!
- Text
- determine last row in any worksheet
- Cell change colour
- CSV files
- Dropdown Menu
- Sum of cells if contain info
- Filter Area
- determine last row
- Data Validation??
- Row Height problem
- VLOOKUP.... I think
- Text in cell
- Sum of cells if cells contain vlookup function that is returning #N/A
- Paste Link in Excel greyed out
- Refresh A Query
- convert date to month
- VB macros exporting
- Easy one
- Countif's or Array
- Sundays
- golf scores
- Data validation based upon another cell's data
- Concatenate?
- Formulas not behaving?
- Hyperlinks
- Re: Two Hyperlinks
- Highlighting large blocks of data.
- Auto Save
- Email and Excel / Question for Ron DeBruin
- Lookup with wrong result values
- Excel Reports from MS Access
- Excel - Escalator or Appreciation Formula
- Blanks and Zeros
- Counting total registrations....
- Concatenate formating
- Mimicing Conditional Formating
- Re: template save as .xls
- Time calculation kind of.....
- Sum If "Date range"
- two criteria sumif
- determine last row
- Calculations that create "blank" results
- Re: Time calculation kind of.....
- Glacial "Find and Replace"
- jumping cells
- template save as .xls
- Compare Worksheets
- Help using Conditional Formating of entire rows.
- MIN with IF in array
- STDEV with IF
- Compare Worksheets
- sum & vlookup
- Spaces not being recognized be excel as spaces!! Help!
- Excel 2000 worksheet tabs
- Complicated (well to me it is!)
- Importing tables
- parsing text
- Narrow to Broad criteria check
- Copy and Paste functions in Excel 2003
- if positive... print in green, if negative print red
- Efficient Frontier
- Percentage (%) sign in PivotTable... URGENT!!!
- Combining, sorting, and summing similar data
- Stop the #Value! error showing
- count...
- Re: template save as .xls
- very simple question, combining conditions...
- Calculating a sumproduct with AND and <>s
- Using multiple criteria in SUMIF & COUNTIF?
- -Percent in formula
- problem with COUNTIF statements
- Percentage Increase formula needed
- Vlookup only IF condition2 is met, pls help..Desperate Situation!!
- Setting a picture for the background
- File names from DIR /S Output
- Range Names
- function to count cells...
- defining a range to sum
- 5 Conditions
- Counting instances that are not near each other
- Checksum on a group of cells
- Expression to Create a Range Name
- SUMPRODUCT with not equals (<>)
- Excel calander function error??
- Table of Contents
- Reversed of Frequency function
- Table of Contents
- 5 Conditions
- Confused...
- Runtime Generating Formula with VBA Code
- Conditional formatting
- Sorting across multiple worksheets
- how to hide #N/A ?
- if function
- canadian postal codes
- de-concatenate
- excel match help
- SUMPRODUCT syntax/problems
- Help regarding a formula ignoring some cells
- Parsing a string of data
- Excel
- Comparing data in a column
- Help entering Equation in Excel
- Function getting WAY to long and complex!!!! And it still doesn't work!
- Re: Conditional Formatting on a cell that has an IF function
- Linking cell's formatting withing file
- need help in worksheet
- How to break links in Excel 2000
- worksheet split programmatically?
- Find the 5 max values in a column?
- Options Calcu;ator
- How do I get the merge button on the tool bar undimmed?
- How do I make a cell expand when needed???
- excel 2000 email
- Nth Root
- Re: Summing multiple vlookups from another sheet
- Sumproduct (two conditions)
- Re: How d I include a lookup inside a GETPIVOTDATA function?
- Save As VBA
- Excel Time Function
- Macro Button Question
- Make a column read olny
- Time to Value
- double-click in between two rows or two columns
- totaling cells in a workbook.
- Using COUNTIF to count with multiple logical requirements.
- creating an additional sheet with a macro.
- using named ranges and copy with Advanced Filter
- Move date in multiple rows into one row
- default
- IF formula
- array lookup
- Excel Book
- txt to xls via macro
- Can not copy a worksheet
- Re Time Value
- Can I search and replace within the Formula Bar?
- countif function
- Help with Excel 2k3 "insert 2rows if cell contains text" marco
- ActiveSheet.Next.Select
- Hyperlink function - double-click opens cell for edit
- cell contents instead of a file name
- Creating a string of text from several cells
- Splitting info in one column
- Can I make a formula that has the result of "0" remain empty?
- Is there away to make a result of "0" from a formula just leave the cell blank?
- tracking changes in excel
- Please help!
- Double vlookup - lookup into 2 different column
- # of Fridays in a month
- Double vlookup - lookup into 2 different column
- Display tab name only in a cell
- format multible worksheets in a workbook
- What function to use
- Rounding to nearest multiple of five
- Concatenate text cells fails.
- MACRO TO SAVE & EXIT
- Combine written data
- Find a carriage return in a cell
- Adding Custom Property
- Vlookup sums
- Define variable range
- Is there a more efficient formula than this monster?
- Updating dates automaticaly
- vlookup and date values
- SUMPRODUCT & other formulas
- Microsoft Office User Specialist
- Macros - Importing text file within a specific worksheet
- Changing colours using formulae
- Pivot Table
- IF function limit
- macros
- REPOST - Pivot Tables
- jim
- compare tables
- Conditional Formatting Questions
- Need help with a Formula ???
- Macro and the drop-down list.
- Is this possible
- array formula
- Qtr results to annual results
- if(isna(vlookup),vlookup)
- SUMIF date range
- Re: is this possible
- Macro Help
- Average function exluding zeroes
- Hidden Cells
- Separate City, State
- "Check Boxes"
- tab references in formulas
- formulae using blank cells
- Searching and totalling a keyword
- Re: iraq murder video gi head cut off
- Pivot Table Error "repaired due to integrity problems"
- Sumproduct w/varied criteria ranges
- i don't want negative values
- Copy and Paste Formulas
- Excel count cells in range with text
- conditional formatting
- Re: Lookup combined with Sum function
- Re: Lookup combined with Sum function
- HIDE/UNhide Group boxes
- Multiple Regression Function
- Re: Why won't this work
- Trying Again...HELP
- Need help with SMALL and it's sheet reference
- Newbie VBA Programming Trouble
- Re: compairing workbooks
- Importing from Excel to Access
- Excel sort problem
- Zip codes and Excel - Please Help!
- Count Function in Excel