- New rows at the end of a worksheet don't sort with the worksheet
- calculating years/months with YEARFRAC?
- YEARFRAC formula question
- Excel: can I refer to cell reference in page setup header
- Calculate Start Dates based on Need-By Date?
- Links in multiple worksheet.
- Perform calculation from drop down list
- Vlookup Question
- AVERAGEIF AND SUMIF AND COUNTIF
- Commas in indian style
- how do i format inserted cells in protected worksheet?
- view page breaks
- Gray vs Black Lines
- dynamic print area
- Excel should allow exchange between cells
- Formatting to separate dates
- Adding A "Timer" to a Macro
- Selecting Specific Data within a Table
- Text Error Message
- search string command to answer simple Yes or No
- Countif
- Delete unwanted page breaks.
- How validation dropdown list open when cell is picked?.
- Sort data into order of product
- Umh !
- 2 columns
- compare date to column data
- compare date ranges to set up eq
- sumproduct help
- Counting Dates
- How to use miles per hour and mileage to estimate travel time
- How do I write the word "sample" across a sheet?
- Year and Date Funtions
- Excel Link Updates
- multiple entries-sums to different cells
- calculate time periods
- Excluding in Excel
- Manual Transpose
- Custom Footer for each page
- Dropdown menu
- [excel2003] Compare two rows
- [excel 2003] Delete empty rows
- how do I Divide "/" a row of cells by another row of cells?
- macros
- calculating sheets
- Print header
- how array functions work mmult,minverse etc
- How to protect cells from getting deleted or resized?
- How can I create a worksheet using Macro
- Excel Functions Correl and Pearson are identical
- hlp with sumproduct!
- Subtotalling
- track balance based on payments in Excel
- Dividing a time span into shifts - overlapping days
- formula in excel to track times between two different dates ?
- Column of Text is same as Column of Values
- Copying an Array
- Can you put two functions in one cell?
- unlock hidden rows when 'unhide' is greyed out?
- Returning value next to the nth occurrence of a particular number.
- LOOKUP FUNCTION
- Cell Ref. in Formula changes automatically
- How do I set up Reminders in an excel spreadsheet?
- SUMIF with AND
- HOW TO UPDATE 1 WORKSHEET FROM 2 DIFRENT USERS
- How do I merge cells without losing cell values?
- Rnage Finder
- How do I use a formula to make certain text a different color?
- Excel Formula?--> if A1=11am, then D5=A1; if A1=12pm, then D10=A1
- how do i get day, date year 1-31 on excel, day=mon
- how do i get the sum of data from specific dates
- Quote Matrix
- ISERROR - #NAME?
- Can a formula change a cells colour after a given length of time?
- Averaging data that meets a criteria
- IF ColumnA = ltr Add Column B
- Remove all spaces in a cell...
- How do I create a cell reference from a value within a cell?
- Just upgraded to excel 2003 and protection is a problem
- & help with date format
- EXCEL Sheet
- How do I create a summary worksheet that references data in other sheets?
- Pick from a drop-down list
- Time Cell help
- FORMULA HELP
- What do I call a blank cell?
- Pivot table-How to exclude zero values from it.
- Auto Save????
- Data Entry Form
- GETPIVOTDATA returns #REF error
- Excel Links Updates in 2003
- how do I round 3.30 to the nearest quarter. 3.30=3.25
- Formula not converting
- How do I display category
- Calculating dates - complex scheduling problem
- how to split address blocks across multiple cells
- settings not saved w/custom view
- Combining Digits
- Is there a way to save a color palette??
- How do I link mulitple drop down boxes together?
- pick date from calendar in excel
- Aggregate Data from a column in a cell
- using list box to edit or select data
- countif & and
- Iserror question
- cells and sheets, names
- Basic formula help
- Activesync and excel functions
- working exemples
- How do I replace "#N/A" error, to continue my formula w/o error?
- Mofiying the protect option.
- Functions
- Overcoming "Formula too long"
- Excel 2002 worksheet
- Urgent - how to set a formula in excel spreadsheet
- writing figures in words
- How do I use the Color Index to format my cells which requires mo.
- Date Formula - in Years
- Function fails to calculate
- lookup macro??
- Random Number
- Adding 3 variable formula to a cell
- How do I color only half of shape?
- Retrieving data from the web - help !
- Nested If function?
- format a cell if the formula is removed
- column addition question
- i made a list box but i need to link data to it
- Command Button
- Code crashes after clearing comments
- Pritning 2 selected areas of a sheet
- How to determine total value of business for sale
- easy way to Consolidate Data within workbook's various worksheets
- I am trying to add notes to a drop down list
- easy way to Consolidate Data within one workbook's various workshe
- Comparing values between columns only when there are values in bot
- How do I use a countif function according to two other countif fu.
- excel
- text in a function
- stop rounding up in a colum that contains decimals in excel
- Counta and rows..
- rank
- is there freeware for administration of my home office?
- Extract Date
- Display row & column number in cell
- Array formula and #N/A
- Define Name reference
- why can't i send my excel spreadsheet?
- If than Else Trouble
- How to eliminate xero values from pivot table and list top 10 only
- need formula help
- Military time trouble
- update prices in inventory based on downloaded price list??
- cell value based on null/not null in another cell
- PLEASE HELP - Data Sort
- Intercept and Indirect
- Percentage function help
- Unique Values Only
- Many Columns to Many Rows
- Selecting Last Sheet
- Formatting when referencing?
- Can't Copy and Paste
- Keeping the format when referencing cells?
- How do I setup a drop down box for using addresses
- Cell Reference in Function
- Macro problem
- SPELLNUMBER
- I want to create a templete.
- Working with first and last names
- copy email addresses from excel to yahoo
- Formula hijacks cell below.
- Data Transfer?????
- In Excel, how do I insert a formula to find the 5th root of a no.
- Formula Syntax
- percentage
- Pivot table formula
- Getting Difference between two cells
- IF Statement (Nested IF's??)
- < or > question
- color help
- Need formula that will sum cells in a column bases on criteria in other cells.
- Text Wrapping
- trying to print at 100%
- Protect a worksheet, but allow ONLY specific users to change info
- Summation Formula Needed
- Summing Up Data Based on Codes
- INTRATE
- Moving up blank cells
- Used Quick Lanch and no shortcut Bar for Excel came up What now
- Sumproduct doesn't work with columns... alternatives?
- merge two excel documents
- Button/Script to create a new workbook from a current one.
- Rounding to Nearest 250
- is it possible for a cell to change a date every 7 days ??
- Vlookup Across 2 AND down two rows
- Excel formula series
- LookUp with multiple criteria
- converting date to number
- Calculating volume and number.
- Time Calculation
- Returning a cell reference with a formula?
- rolling 12 month average
- Changing values but not formulas
- #DIV/0 error
- Displaying formula from one workbook in another
- display last cell in a column as the sheet is updated
- TEXT INTO COLUMNS
- Excel Pagination ?
- Inventory Age
- How to Create VLookup for a range of specified grades?
- static time in formula
- Rolling Information
- Capturing First Change In A Cell
- Shrink and expand a number of columns/rows
- Lookup from Static List/Array
- Creating a Custom Excel Function to Calculate Gini Coefficients
- Workbook searches
- IF function HELP!
- remove error value when formula exists for empty cells
- Excel formulas, comparing numbers
- continuing formula when cells are empty
- how can i de-dupe email lists using excel?
- Can Excel automatically change the font color of an expired date?
- change all at the same time
- Copy entire ranges
- How do I convert an Excel Document into an address book for Outloo
- Formula Needed to Omit Characters
- vlookup
- Eliminate Overlapping Entries
- Time Field Formatting
- How do I create a dynamic series of months in excel?
- working out ages from date of birth
- Formatting Cell To Display Value Instead Of Formula
- Calculating revenue per month by aggregating dates
- Averaging Indirect Cells
- ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
- SumProduct with criteria list
- What does error #AD? mean in Turkish Excel version?
- PivotTable-% of total
- How can I sort data in sequence by odd/even numbers
- Value of cell to determine range in MAX Function
- Comparing two Worksheets
- working excel files keeping on desktop
- Microsoft Excel 2003 - Advanced Filters
- Lookup/multiple
- VLookup or Index Match or ???
- How do I count wildcard text meeting certain criteria in EXCEL?
- "formula for tracking days off "
- Hide and PW protect multiple worksheets
- Convert feet/inches to decimal
- Round hh:mm:ss to whole hh:mm
- inserting an additional line of text within same cell
- Troubleshooting comments: when box resizes and moves location
- how do i elarge a printout of worksheet to cover printer paper
- Condition Sum
- Concatenate Text & Numbers Keeping zeros..
- editing a cell that has a formula in it
- Concatenate and keep preceeding zeros
- "MAXIF" workaround
- Formulas dealing with searching for characters
- Vlookup NA#
- Using macro to un/protect sheet
- Time formatting:data 1:30:20 entered reads in 1:30:20 pm
- Macros-creating new sheets
- IF + COUNT IF Questions
- Excel how do I add a flat 10.00 in a column with 10 entries
- averages
- add option in pivot tables to remove subtotals for fields
- update cell only if now() falls in a given date range
- Comparing columns in 2 different worksheets, IF Function
- replacing #N/A values with zero values
- copy array formula
- format date time
- Function To Dynamically Display File Size
- deleting duplicate names
- vlookup help with two of the same lookups
- Calculating Sum with Multiple Field Criteria
- Formula to identify decimals??
- Sort : how can I use a variable in a VB sort function?
- What are colums to the left of Column A for?
- Attendance spreadsheet
- printing 1st column on all pages
- Counting Unique Values
- drop down list help
- Copy Formula's
- setup a spreadsheet that would enter an "X" when cell is clicked
- Number conversion to Hours
- How do I # my rows in ascending order.
- How do I save a leading 0 in a csv format?
- Rounding decimal
- Need % of Actual over Budgeted. Budgeted 0 actual 160
- Adding "fixed" data to variable length data
- Some cells in my spreadsheet are not printing.
- Function/ formula to output a cell reference
- % calculations
- date conversion after pasting
- auto load data from one workbook to another
- Sum product
- NEED FORMULA TO EXTRACT DATA
- Can someone give me more examples of DSUM?
- how do i get Data from another sheet
- My formulas will not pick up pasted values
- If date = x, then capture data on row and move to new sheet
- Format change 203.00 to 203-00
- when i open a workbook, i cant type in it?
- sumproduct
- Capturing The First Change in a Formula
- insert sheet tab name on the spreadsheet, not in the header
- Returning a cell's formula in a different cell
- how do I total a column with hours and minutes? SUM doesnt work
- How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel
- Spreadsheet
- combining multiple columns into one column - enhancements
- Looking for a Function which counts the repeatition of text in a column
- How can i get a IF formula to skip to the next reference box
- Data Randomization
- Sum of previous offset number of cells not to exceed certain value
- OLAP Pivot table - How to show items with no data ?
- help!
- How do I enter the PV function to determine the ending balance of
- Excel formula: how to write >$32 AND >65% = "Corporate Gold"
- inserting a conditional "go to" command on a excel "if" function
- Wrap text in mege cells
- Adding sales in same column?
- SUMPRODUCT - Help
- How can I calculate a value using time duration in mins & secs
- copying the same cells from many sheets
- How do I multiply an hourly cost by hours expressed in minutes?
- double click insert date
- moving cells
- Same colum different row?
- functions are not displaying the results
- Calculation help from average total
- Viewing Multi-worksheets in same work-book
- EXcel Formula
- Custom format cells - how to make it say < number
- How do I offset a row of cells a defined number of columes?
- Excel displaying formulae as constant and not calculating formula
- cell "if"
- How do I copy a date in a worksheet cell to another worksheet?
- row number question in an array
- Help with vehicle sales forecasting with Excel
- Modulas
- Default Font
- daily interest
- calculation a average dependated of values in seperate column
- Help with Formula, Should I be using Max?
- Excel custom function dialog
- Altering VLookup Formula
- Prefil Color Pattern in Excel
- How can I print my excel worksheet showing formulas in the cells?
- formuls results won't update automatically (auto is turned on)
- Named Ranges
- Is there a function like "Data Table" for multiple Inputs
- finding cells with data within a row...
- Making A Code
- NEED TO CREATE A CONDITIONAL FORMULA
- How can I print page 1 portrait and subsequent pages landscape?
- Autofilling information
- Counting only values
- How do you avoid duplicates when using the randbetween function?
- calculating
- cell contents
- CSE formulas?
- Filter Assembler Level
- how to auto increment cell location within formula
- While Function Without Using VB
- Tough Concatenate Problem
- production frontier
- 3 1/2 diskette wont open?
- Excel User Conference - Few hours left - Early Bird pricing
- Index and Match Array formula
- FileExists Example:
- Excel Protection Issue
- OR function
- Take 3 columns, one per sheet and turn it into one on 4th sheet
- excel and statistics functions
- how to link worksheets
- Macro problem
- Adding/Subtracting Time Help...
- Incrementing by 1 when doc is opened
- Vacation/Sick accrual
- Use Validation to force specific entry of first 3 characters in st
- Need to add a goal threshold
- illedgible text box test
- Countif With Criteria
- Lookups and References in relations to countA or sumproducts
- How do you formulate an entire column?
- How do I sum column C based on a value in Column A?
- Countif with criteria
- "Absolute" questions when autofilling-dragging down the column not
- When pasting PDF to Excel why does it sometimes past into multico.
- Printing issue from Excel
- Why are german users getting an error with Mround? ATP installed.
- Pivot table drill down formatting
- Formula Assistance (
- Function that Returns address of that cell?
- Change Pivot table text for totals & col headers?
- time
- Today()
- Number removal
- vlookup tables for pictures?
- Returning all data from a list above the nth percentile
- How do I turn off the Auto Date function in Excel
- How do I get the symbols for Unit Trusts for MSN Money Stock Quot
- Linking cells with a diffrent sheet with 2 cells
- Need a short cut for this...
- Forcing english date format
- Multiple worksheets problem
- Data from multiple sheets
- Excel User Conference - Last day - Early Bird pricing
- formula to get values from pivot table
- listing unique entries from the entire worksheet
- Vlookup Tables
- drop-down list
- SUMIF Formuale with 2 variables
- QUERY: Excel's SaveAs so slow..
- VLOOKUP question
- formula/check for doubling in column in Excell sheet
- In excel how do you find the cubic root of a number?
- counting dates
- Lists and sub lists
- Test
- Multiple conditions and multiple return values
- comparing 2 sheets
- Excel control cell display of data with passwords
- How can I restore my toolbar and menu (file, view, etc...)
- Array Formula
- Formula Saves In Cell But Does Not Compute
- How do i filter out data??
- Repeat Section and Auto Fill
- Can I undo a "delete sheet"?
- How else can "*" be used in a formula and Sum vs. Countif
- Calculating monthly budget expenses
- Scenario manager and IRR
- I am looking for a Business Valuation template?
- IF Functions
- Linking Cells from seperate spreadsheets
- How do I set up a workbook that the worksheets update info
- InputBox to select cell locations
- Text Formating
- Advanced Copy/Paste Techniques?
- countif cell pattern =
- Spearmans Rank
- GETPIVOTDATA using a reference for field name
- Price elasticity
- Footer in Excel
- How can I randomize a set of data?
- Find row value from column
- You guys are on the ball in here ...
- Extracting specific word in a cell
- how do I insert "last saved date" in as a field in excel?
- Conditional Formatting
- Referencing a cell dynamically
- Missing Zeros & Concactenate Failure
- Compare two variables across two worksheets
- avedev
- Help me simplify this function....
- Which excel function would work best?
- Where is the permission option in Excel 2003?
- matrix
- Weeknum
- Nonlinear regression
- GetPivotData refer to external cell
- Help With If Formula
- Excel User Conference - Last day for Early Bird Registration
- Why does date change when copying to new sheet?
- Replacing several rows
- Race Pairings
- Is there a template for a Check Payment Voucher
- can anyone tell me what and where the formula bar is and what is
- Sum with Two Conditions
- Copy DSUM Criteria Question
- Auto Update of a field referencing to a field in another workbook
- How to do box and whiskers plot in excel
- sumproduct partial text count
- bring hyperlinked cell to top of page
- Percentage/PERCENTRANK
- Name box...help please
- Find first nonblank cell row # in pivot table using MATCH
- cell properties and cell functions
- Master worksheets?
- formula to select numbers from a range
- Find last occurance of character in text string
- Q: DDE Link - Replace Part of the Formula
- Formula
- Conditional Formatting
- count the # of entries when sum matches the target
- Vlookup formula
- Count number of days between dates BUT IF null to current date
- Date with Time
- Cell Edges in Excel
- Constant cell
- Month (datedif) to 1 decimal
- Combining like worksheets into a single worksheet
- Hyperlink using filename
- Calendar - change of a size of this object
- Multiple or Variable cell references in Solver (Excel 97)
- Few column
- VLOOKUP or...
- How to use this subroutine on multiple cells?
- SUMIF
- Getting to the address
- Adding digits in a single cell
- Can INDIRECT return a range array?
- Automatic page numbers in TOC
- Problems with links to another workbook
- US stock quotes in excel for UK based user
- Transforming pivot table back to the source table
- Hide worksheet
- Column() to return a letter instead of a number?
- Range Name from Another Workbook conflicts with INDEX and INDIRECT
- Simple way to get cell location as text "A2"
- evaluate #¡VALUE! and #!DIV/0! and other errors....
- mdv
- formula for parenthesis round negative money values in excel
- Looking a formula to convert local currency to USD by matching com
- passing arrays to user defined functions
- Enter A/C# on Sht1 Col1, Sht1 Col2,3,etc auto filled in from Sht2
- Complex Formulas
- Auto sort & save
- How to use a range in SUMIF?
- VB Code and Sum with Two Conditions
- Formulas for Parsing Full names
- Embed a countif function in subtotal function?
- Concatenate Custom Dates and Times
- selective autofill with functions
- How do I copy multiple worksheets into a new workbook?
- combining multiple rows into 1 record
- Data Validation and Drop down lists.
- Excel Functions using Tablet
- Formula in a cell instead of its calculated value!!
- #name error
- when I save a file from Excel 2003 to cd it saves as read only
- Date to update after 7 days Please
- How to install Excel Add-Ins without a CD?
- Copy of data automatically
- rounding numbers for match function
- vlookup question
- Custom format rounding
- Excell
- rounding numbers for match function
- TRANSFER AUTOTEXT FROM WORD TO EXCEL?
- Keystroke for Formatting
- conditional formating dates
- Stop calculating on open
- Random Passwords
- IF formula question
- solver
- Build Formula
- Pivot Table - Custom Row Field
- Macro
- Run macro automatically on opening of worksheet
- how to get the number of unique records in a list
- Sumproduct formulas not working after editing
- How do I set a formula to show a difference in sets of data enter
- How do I use wildcard characters in Excel 2003 sumif formula?
- average price of 4 columns of figures but some cells can be blank
- adding a drop down list to an If Statement?
- Using IF function with Dates as parameters
- Italicizing part of a cell
- RE: Sumproduct formulas not working after editing
- Can the "Find and Replace" feature be used in Formulas somehow?
- RE: average price of 4 columns of figures but some cells can be blank
- return based on range of dates
- text to column macro
- Custom Formatting
- RE: Custom Formatting
- Countif question
- If Function Also Using AND eg: If( ... AND ... ,X,Y)
- Function to display day in text format
- Ignore errors when calculation average of multiple ranges
- If function with text
- Intersect operations
- added up none numbers
- How can I ignore an #N/A value in a =SUM() formula?
- Find Maximum date
- Sumif with a range (part II)
- auto calc on, but have to edit (f2) cells to force re-calc..help!
- Radio or option button
- find & replace link
- if function
- Adding Cells across Worksheets
- Comparing data (Before & After)
- Dynamically OCntrolling Rows
- Merging a ton of cells
- How to filter using background colour?
- Return the first visible cell below filter labels
- Filtering Data With Formula
- calculate/convert volume price to monthly average price
- Check for Duplicates
- Sum function question - easy?
- Last days for Early Bird Registration - Excel User Conference
- Using a range of dates to add data in a different column?
- Using a range of dates to add data in a different column?
- Hidden Worksheet
- RE: Depreciation function inconsistencies
- If statement that contains 6+ arguments in excel
- search and sum
- Conditional formatting.... Excel 2002
- Best possible protection of worksheets in excel
- To only get all text after a comma
- to large if formula
- Scenarios limitation
- =if(h180<>0;e180-$j$1;0)
- Re-arranging name fields
- HELP!!! Trouble with IF, AND functions
- Looking for the Formula to find 4 in 77890453
- how can i calculate a three variable if statement in excel
- FORECAST function am I using the right thing?
- Help me I've forgotten the formula and I can't figure it out
- Help me I've forgotten the formula and I can't figure it out
- Can Sumproduct do this?
- I want to use a formula in excel to highlight a cell 30 days prio
- Populating worksheet via a drop down list !
- Formula for reminder of data needing review on dates?
- Transfer cell color
- Conditional concatenation?
- Count cells between a date range
- Format numbers in multiples of 1000
- How do I link the same format when using the "=" command
- Subtotal on the fly
- Concatenating an array??
- Macros editing and exporting
- i need an excel wizard
- Removing "Blank Cells" from a column
- Macros & search /replace
- Keep certain cells visible when scrolling, not just rows or colum
- Can I merge into an envelope from my wookbook?
- ROUNDDOWN Excell function
- sumproduct
- Keep sort settings in Excel
- HELP| populate cell with particular value based on multiple condit
- Continuous flow of information
- Can't find the min of a lookup reference
- Trigonometric Function
- How do I calc. acrued intrest on a monthly investment over 35 yr
- Countif/Sumif
- Countif/Sumif
- linking cells
- finding out the combination of letters!
- 3 criteria
- Old to New Pricing
- How to remove a suffix in excel
- Conditional Formatting with two cells
- if then
- list two columnar values based on conditional formating (text color)
- out of a group of cells, if max, then display this other cell
- A + sign between two cells in a maths workbook
- How do I make the now() static and not change with calculation?
- Count the how many different values in a range
- Help with replacing items within a cell
- how do I use conditional formatting for alternating cell shading?
- saving workbook
- Month to date calculations
- Count function
- Excel hyperlinks to other cells in workbook must be relative
- Want to set print gridlines as a default setting
- Picture in Comment?
- vlookup worksheet match in macro
- How do i put themulti-attribution utility theory (MAUT) worksheet.
- can I bring back an older version of a saved execl spreadsheet
- how to send xls cell info to a word template
- Functions?
- HELP - 5% INCREASE
- Automatic greenbar effect, varied color, corrects with re-format
- Extracting hyperlink from a cell
- finding a field in a table
- Help - combine OR and AND in IF function
- Please Please Help!!!!
- cursed vlook-up
- Removing macro
- Formula is driving me crazy?????
- Improving use of Worksheets
- Formulas quit---
- extracting and adding numbers
- Refreshing Data within a pivot table
- how do i link 3 worhseets to calculate into one
- LOOKUP - Driving me potty!!!
- My sumif formulas containin links to other workbooks do not calcul
- How do I combine lists in multiple worksheets
- lookup function
- Keeping Excel Active Always
- list of all subdirectories in a given directory in excel
- How do I sum a row of array formulas?
- Countif using Wild Card Characters
- LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW
- rounding to the nearest thousand
- Creating a formula in excel
- Sum if
- I am putting in a date 02-10-06 and its coming up as 10-02-06
- NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS
- Include Worksheet
- Setting up a price list
- Running Totals
- SORTING TEXT AND NUMBERS
- How can i find and change a value in a cell place?
- Multiple stipulations within the if
- Multiple "if's"
- Data Cubes and Pivot Tables
- after i save the file my hyperlink does not work in excel 2003
- Copy selected lines
- >> Need help with a simple formula
- Sumif and a range
- using auto fill edit or fill handel
- Training: More on how to use macros in Excel: Recording Macros
- worksheet copying, changing source link
- date function
- Help with a Formula
- numerical data sort
- Excel Randoming Becoming More Efficient
- including current date in formula
- Making column reference in INDIRECT non-static
- Automatically step a formula?
- calculate using last four digits of number in cell
- How do I use a referenced cell's formula instead of formula output?
- Can I use SUMIF and AND together
- IF, AND, OR Function help needed
- Using arrays or range in IF function - HELP PLS
- How do I link a row of cells in wks 1 to update diff cells wks 2
- Extracting Numeric Data from a Delimited Text String
- Why does my color palette automatically change?
- Excel cell properties
- Days360 problem
- Time Fomat
- powers to negative numbers
- Chronolize dates with varying days minus weekends
- Combining 4 lists of data
- formula
- IF ARRAY LOOKUP ??? Help Please
- How do you compute partial year depreciation using DDB, SYD, SLN,V
- Data filter total
- SUM IF Formuale
- Divide Problems
- Format cell to show duration of phone calls
- Decimal Places - Settings for Auto Rounding Up/Down
- Time Formula?????
- repost: Min/Max help needed with a SumProduct
- Dates Formats in Pivot Table Help
- Decimal Formual
- Count Duplicates Order numbers for one Customer
- OS language and Office language conflicts
- =HYPERLINK function and Excel 2003 problem.
- Import a Code to a paragraph using a formula or macro!
- How do I SUM several worksheet to a final worksheet?
- Enhancement request for showing the selection of rows in MS Excel
- Excel sort application should work with Project WBS
- Using Lookup on an expanding list
- Count Function help required
- ???Refer to a specifc cell in a named range
- convert $ to £ or £ to $ function how?
- How do i Print Multiple Names on the same Timesheet?
- Find the earliest date in a range of dates?
- How to show all the possible combination of a set of numbers?
- Excel formula to increment the month by 2?
- generate a chart with asp.net
- stuck
- highlighting duplicate values
- multiple worksheet help
- To find duplicated values in a range
- filter ?
- would like to know how to convert 2 hours and 30 minutes into 2.5
- Array formula expertise needed
- Nesting VLOOKUP & HLOOKUP
- Excel User Conference - Registration Drawing
- Min/Max help needed with a SumProduct
- Copy # fm one list to matching id in list 2?
- when I use Ctrl+D to copy a formula, it does not compute right.
- Time Increments
- how to use * wildcard in a sum(if((cond),range)) array formula
- How do I change the ROW HEIGHT in one column?
- convert decimal numbers to a fraction of an hour for payroll hour
- Using COUNTIF to find how many times 2004 occurs
- File Open Box Suddenly Maximized
- Speedy way to create IF Function
- shortcut for transfering info from one worksheet to another?
- Text String - Specific Characters
- Calculate the difference between two times
- Calculate the difference between two times
- Help with IF statement on taxes
- Can I use character masks within a function?
- how to create my own functions??
- Column Values Re-Order Bottom to Top
- SUM Arrays needing an "OR" statment (but no duplicates)
- Sumproduct with two criteria
- Calculation Problem
- automatically filter for unique records... or other suggestions
- Shared workbooks
- How 2 sum the abs values of several cells w 1 func in XL.
- How 2 sum the abs values of several cells w 1 func in XL.
- Complex countif of array elements
- Can you replace "TRUE" with " " in an exact formula?
- How do I keep the color fonts in my cells when I use drop down?
- How do you hide column and row headings in Excel?
- stoke market accounting buy brokrej amount sell brokrej amount
- Merge =( formula should retain fraction type numbers after merge.
- Lookup when values located in a row across bottom of table of data
- How do I link 'tab names' to a cell in Excell spreadsheets
- Inserting an image or line
- conditional formatting when entering a date
- count it
- converting a number to time formatted as minutes
- RE: QUERY & HELP: so slow executing VBA code... :S
- Rank in Pivot Table
- Copy If Ability for Excel Data
- Generating numbers & submitting details from one sheet to another
- How can I copy a custom toolbar & put it on another pc?
- Countif - refer to another sheet
- Page Setup Across Multiple Worksheets
- Small help with vlookup and sum
- time calculations
- VLOOKUP in a dynamic setting
- adding specific cells based on a corresponding date
- Worksheet function for range of numbers
- nesting issue in functions
- How can find a value using two different matching criteria?
- Summary formula help
- Can I convert hh:mm to mm in Excel
- How can I get inserted lines to automatically appear in a linked .
- using solver to complete a table
- form/subform with buttons
- Can some one help me with a formula please?
- Pull latest date data - ignore the rest
- How do I limit sorting a column to the column?
- how to keep previous months' data
- Multiple conditions data analysis
- Macro buttons disappeared
- Greater Than Less Than Question
- how do I write a formula to copy text from one cell to another?
- How can I sort multiple times
- Mail Merge
- median excluding 0's
- finding unmatched data
- find text
- SUMIF with two contraints?
- Entering the same data on more than one worksheet
- Array Formula
- Macro Msg. when file has no macros
- SUMIF Function
- Sumproduct Problem
- How to change the default 000 to indian standards in 00,00,000?
- IF Function
- LOOK UP INFORMATION
- Drop down menu and two dimensional lookup in Excel 2003
- Simple problem?
- apply arithmetic functions on special multiple cells
- what is perequi function?
- data changes to date format
- conditional formating colours to stay when numbers are deleted?
- List of items appeared in range
- Excel
- How do u emulate nesting seven IF functions in a cell?
- How do you make it so you can see Your table in word?
- time trouble
- How do i subtract cells in an IF function?
- Filtering External Data
- Cells populate on specific dates
- cumulative totals in a workbook
- IF VLOOKUP
- Formula if a number is between 2 amount than answer will be x
- IF(AND) function?
- Vlookup using variable path name for range value
- Nesting more than 7 conditions?
- Merging data
- How do i hide a solution until data is entered
- code for showing a sheet has been printed
- Copy & paste special
- How to read CSV lines into different Worksheets depending on a date field?
- Can this be done....?
- use lotus 1-2-3 commands in excel 2003
- Gridlines
- Find when a value in a column changes
- Workbook Popup note
- Smart Tags
- Tab-naming macro only works once :-(
- Excel comment box should stay in same position
- Copying values but skipping empty cells
- adding comments to unprotected cell/range in protected worksheet
- keyboard shortcut question
- Counting distinct entries based on meeting month & year criteria
- Is there a function for this?
- cell lock does not work ?!
- Can I return multiple columns from a vlookup?
- Adding a period to the "=LEFT()" function.
- FIND and REPLACE characters needed
- =MAX-Return Cell info
- "Format" function in Excel
- Rolling Average
- Have 2 Vlookup
- "unique" forumla in excel
- Formula automatically changing cell references
- Conditional formating based on text
- If Formula Question
- Subtracting 2 Now() Cells
- Need help with a formula
- Data count with two worksheets
- Advanced Lookup problem
- looking for a value in a collumn
- How to increase font size in drop downs within workbook
- DSUM returns #VALUE!
- Hyperlink to a CD
- copy entire excel book
- Need help with automating the updating of a function in worksheet
- If Statement based on blank fields
- How do I use my excel program to total up columns ex. e3 to e155
- finding out missing entries!
- Looking at several columns with Indirect
- HLOOKUP with multiple conditions
- What formula can I use
- Changing a value to a letter
- Need help with formula
- Excel's Undo Function
- Having to key the equal sign to start a formula
- Analysis Toolpak Add-In?
- If formula with score total
- keeping a sum array static
- Replacing ascii characters
- need help with count formula..
- Column list search
- I would like to see a few new features in Excel
- Check for duplicate data
- =SUMPRODUCT not working
- search list for values
- Advanced Filter
- Hard returns in a formula?
- Help on Pivot Table Format
- How do i delete duplicate rows in an Excel Spread Sheet
- excel data automation to/from jsp page
- Split field based on number of characters and space
- How to put pictures into an excel document for merging in Word?
- Unique RANDOM NUMBERS within specified range
- Worksheet Tab Name
- HELP, I'VE FORGOTTEN
- MIN to find specific lowest value
- Conditional formatting is unavaiable in worksheet, what can I do?
- math formula with upper and lower limits on data but also ranges
- Problem with spaces
- Formula displays result in formula box but not in cell
- Workseet Colaberation
- Adding values for selected years
- Lookup Postage Price [min & max weight]
- How to 'freeze' the output generated by RAND()?
- Auto time freezed
- excel charts, simple question
- DATE FORMAT issue
- arrange excel worksheets Alphabetically
- grouping field in pivot table!
- ?? Auto go to link source
- Dynamic Data Distribution
- simplify procedure to get rid of 0 error values in a spreadsheet
- Use the only the last value in a column in a formula
- Date question
- SUMIF Question Re:Criteria
- How to do TI83 2-SampTTest (hypothesis testing)?
- Matching/merging data from two worksheets
- Formula = Today's date + 1 month
- How do I search a text string in many excel worksheets (files)?
- How can I change what is in the "name box" in Excel?
- Mysterious formatting - cannot fix
- Which Function to Use?
- Cell function required
- Colour recognition by master sheet
- Hyperlink to an image in other worksheet, displaying entire image.
- sliding hours payment
- I need an autosum for each box where employees use x's of 1's
- Eurotrip?
- Extending a nested IF function.
- Any way to get calculations over a range of two sheets?
- How do I save printing option for all in a shared Excel workbook?
- Automatically running code
- =DSUM(DIVOH,$CX$1,$DG$2:$DG$20)
- Average Function that Counts
- Updating Excel Worksheet
- Subtract times and let result go negative
- Formula Bar
- Advanced Lookup w/Dates
- sumproduct vs dsum
- Run a macro if a certain value is entered in a cell
- How can I invoke running a macro from within an "IF" function.
- Help finding dates July thru June
- Help finding dates July thru June
- Search Help
- Increment Page Numbers for multiple tabs in Excel
- Convert units should include USFt (39.37/12)
- combination of functions?
- Non-Static table/sheet referencing
- How can I create a fill that increments based on worksheet numbers
- how do you select multiple minima in Excel
- Hyperlink ? - forgot to add it's a chart
- Calculate employee hours for employee evaluation?
- Some tabs not visible in Hyperlink list
- Look Up Function
- Replace a long list of abbreviations with full words in Excel
- Background on Worksheet
- Rounding up results to meet minimum order quantities.
- Formula that 'contains' a specific word
- Histogram from multi-page info
- COUNT IF BETWEEN DATES
- How do I set up a calculation to exclude weekends?
- I would like to copy & "paste special" an entire book