View Full Version : Worksheet Functions
- Subtracting cell contents - I can't believe it's not working!
- #REF! help
- need assistance with merging cells
- Customizing MSOffice 2K Format toolbar.
- how do I add minutes and seconds together in excel
- Conform a total to a list of results?
- Conversion of Cell Contents into a Functional Worksheet name ?
- cell format limits
- Naming Worksheets
- Modify A Formula To Include AND
- Lookup Function Problems
- Formula to lookup Multiple Column Text and then Count Result
- Convert numbers into its equivalent in words?(12 to Twelve)
- use only the first 3 letters of cell data
- How do I calculated total hours per week
- Moving data in financial forecast
- Help using the 'If' function to automatically fill in other cells
- I need help
- pivot tables reports - altering display of (blank) cells
- Countif based on 2 criteria
- what exactly are relational operators in Excel? All math symbol?
- this may be simple, sumif question
- Is it possible to place a stopwatch in Excel
- Conditional Average
- Help with IF function
- creating a rate schedule
- Excel formula help?
- How to insert picture and automatically size to cell?
- Referencing data in different worksheet based on month name
- Help with VLookup function
- Sum of comma seperated values in cell(Reposting)
- unbalanced data in ANOVA
- #N/A! to be blank please.
- Age with mont in decimal
- Help! Formula between the sheets
- Splitting a Target Figure
- Weeknum Function
- Large function
- Convert Text (letter) To Number Excel
- Next Row
- Workbook formulas
- Lookup and return multiple Values
- Automatically Sort By Reference Amount?
- Selecting Rows
- Recalculating a Regression Output in Data Analysis
- Copy Formula - EXACTLY
- Date Range and calculation
- I'm Having Problems with EOMONTH
- Max number of IF statements
- I want to use the same function as SUMIF, but for two criterias
- counting date entries by month & year
- Generalised version of LINEST using QR Decomposition
- Editing countif formulae
- custom cell number
- If Statement Using Wild Cards
- merging sheet1 to sheet2
- move one row to another in excel (worksheet)
- Check to see if cell data is within a range
- VLookup and HLookup at the same time
- IF is not carrying out the FALSE part
- formulas using text
- Can I modify Excel 2003 color palette to accept Pantone colors?
- Make an =if show - instead of 0
- Create a print macro that would automatically select print area?
- I need to insert a drop down menu in a cell?
- Logic Tree, MS help = useless
- How do I calculate operating expense
- Selecting a Worksheet Range
- sumproduct w/horizontal range not working
- Nested IF AND OR function Inexplicable error
- How do I calculate operating expense
- Automatic Date Entry
- drop down lists/validation tables
- How can perform a summation?
- Target.Address syntax
- Need insert a dash in between last 4 digits in text string
- IF - Nesting... almost got it - need a bit of help
- Update of cell values after insert row?
- Need a help with the IF/ IFCOUNT function
- Find certain text in a column and return statement
- How do I do this?
- counting filtered items
- How can I get fonts bigger on my dropdown list?
- Question about Emailing
- How to get pivot table Time field to appear correctly
- Is there a way to reverse the layout of your colums?
- No Match
- Function Help Please ....
- Help with IF & Average Functions
- importing data into a workbook
- Formula for Calculating a Floating Date
- Numbers converted into amount in words in English?
- Worksheet VBA function - not recognized
- how to convert numerical figure into text
- Struggling Again With A VLOOKUP
- How do I calculate time
- how to change colour of text in true or false formula
- cover #s to text
- CREATE A SUM BASED ON DATES
- Could you help me to calculate overtime
- How can I merge and link workbooks into one summary workbook?
- randomly select value WITHOUT changing
- coutif with 3 criteria including brackets
- Not including blank fields in pivot tables
- Best 8
- How do I delete the same item from all pages of a workbook?
- Countif using dates
- Editing Array Formula
- Counting Blanks
- page numbering
- Range Changes with the Months
- Identifying bottom of list
- excel, printing data in columns
- Function to return the active sheet name
- How do I total amounts on various sheets in excel?
- minimum along rows
- School assignment: Excel worksheets.
- Pivot Tables - Named Range
- use replace to edit a formula with wildcards
- how do you count checkboxes in excel2003
- Cell reference
- Payment formula Question
- create a multivariable regression in excel without using array
- Help with formula...please
- display Calendar for Excel field entry?
- Lookup function help
- Excel for inventory aging?
- Help with a formula
- IF statements/formula problem
- formula with changing cell ranges
- moving the formula "average" over one column in a macro
- Create a master worksheet based on 2 different worksheets
- Re: working with sub-totaled data without the detail
- Is it possible to split a cell within a cell?
- combine date one column, with time another column into third?
- formula to identify weekend dates
- Counting Match Pairs In Rows
- Exclude non-numeric data from calculation
- Formula Problem
- create default cell value
- Date Function
- Drop - Down Box
- Do Loop
- Vlookup then OFFSET over and down
- Drop Down List Autofill
- how do I write the date in an if statement
- How to transfer info from PDF file to excel (lists)????????
- Results in a column
- column to column conditional formatting won't work, need formula
- Caculating a "staircase" discount
- Product formula help
- inserting a VISIO drawing into a worksheet
- IF Statement??
- How do you format a cell for % varience for multiple answers
- Lookup - Pro-rate formula
- Cleaning up data from Crystal Report
- how can I blank out columns that are not being used
- Newbe Help with count/countif function
- Matching a sampling # to it's row #number
- convert a PDF file on the Web to Excel
- working with dates
- Using Sheet names in formulas
- backing sales tax out of a total including sales tax
- Calculating the right formula
- How do I set up an automatic running average in Excel
- print bottom row repeat on every page
- plz help
- Sumproduct / Max array formula problem
- Error using "IF" in Microsoft Excel
- Simple Copy from Worksheet to Worksheet
- LookupV
- Autosum returns an incorrect zero value on the selected cells
- IF STATEMENT in multiple workbooks.
- How do i make a range of cells change colour
- moving cell
- I want to convert 10,000 to "Ten Thousand" using Excel Function
- Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17
- SUMIF Returns a #VALUE error when external source is closed
- Reading data in onther Excel document
- COMPARE DATA FOR CHANGES
- Copy Formula to Different Workbook
- pivot table to sheets
- lookup function bringing in wrong info
- Average of the minimum+50 in a row
- Excel Worksheet crashes when changes are made.
- Nesting Problem
- Array Formula help pls.
- date shows 1/1/1900
- Nested If with And
- Data entry for two worksheets
- copying formulas to another cell
- Sort defaults
- Opening excel spreadsheets via excel.application object w/o prompts
- Automatic Sort with VLOOKUP/LARGE Functions
- How to autofill data from one sheet into another
- Excel - open a new workbook with "own" macro
- ISERROR
- IF - need to insert a cell value
- Formatting Cells - color based
- Nested functions HELP!
- Combo Box
- subtact between times
- DATA > TABLE -- 2 variable data tables?
- How do I input zeroes in a zip code for a mail merge?
- Excel finds a value that is not in the lookup range
- errors and printing
- Lookup and return
- Quick and easy
- vlookup, but ignore errors if #n/a
- formula stays same in cell when new row is inserted
- puzzled
- Source Data in Pivot Tables
- IF statement
- VB Error, combining rows if...
- Carying Forward data with specific information
- How do I separate a text value with dashes?
- International Equivalents
- Can an IF formula result in a color filled cell in Excel?
- can not enable macros
- Check if cell contains certain text
- ATTN: Mr. Bob Phillips
- Conditional formating help needed
- Formulas requiring a time stamp
- do I have to manually change PER to amortize a loan out 40 years?
- "BLANK" - need to delete
- do I have to manually change PER to amortize a loan out 40 years?
- Ability for Excel to find and replace graphic objects (like Word)
- assigning ranks to number ranges
- fill a series of dates excluding holidays
- Refreshing drop down cell values...
- cell custom format
- Changing a Link Mid-way Across Worksheets
- Duplicates
- Entering same data, two worksheets
- When using SUMIF won't worj with crieria = cell referrence
- IF Function or Countif
- Help with Excel formula
- Change color to red when fraction is negative
- Another Reason to Hate Insurance Companies (as if you needed one)
- Data Validation dependant and unique
- Searching Excel for a value
- How can I match data about countries drawn from two database queries?
- How do I add time (in mm:ss) from multiple worksheets?
- Real Value of .UsedRange.Rows.Count
- SUMIF for Dates / Months ?
- trying to add text
- How to print detailed instructions for all functions in Excel?
- Automatically insert row and copy formula
- Return Single Instance of Numeric Values from a Column
- mass cell data editing
vBulletin® v3.6.4, Copyright ©2000-2010, Jelsoft Enterprises Ltd.