Microsoft Excel Worksheet Functions

Space between decimal numbers
convert number to text in Spanish Language
How to Sort Protected Worksheet
Counting a list
How do I Concatenate these Dynamic Rows
Consecutive Cells
how to delete/clean out the row list in pivot table
IF function to blank without getting #value in sum function
Can series tool change formulas over time when used to copy them
What is the Formula to Convert Imperial to Metric Measurements
How can I use black scholes formula in Excel?
Identification of "<" character at beginning of cell
IF function Between
Multiple lookup in a single formula ..
Age-distribution graph
Removing blank rows in a worksheet
entering data to table
Microsoft Excel - Grouping and Sorting Cells
VBA data Capture in a Form
Need excel formula to sum 1+2+3...+N given a number N
Print when check box checked
Finding a match in several columns
Re: VLookup with concatinated named range
Difference between 2 times and dates
Re: Finding a match in several columns
Using a single cell in multiple formulas
Re: vlookup, sumif, if, countif, help
Detecting Blanks and Non Text Characters.
change 5523.44 to 552344 no decimals
Conditional Sum and multiple conditions across different sheets
Excel should let me use formulas that refer to other cells w/ form
Can solver be used to make a cell equal to another cell
SUMIF
VLOOKUP to search multiple values?
pivot tables - calculated fields
VLOOKUP with more than 7 levels of IF
How do I remove a list created in a spreadsheet
Re: How do I sum an array with multiple condition??
Cannot copy or move array entered formulas ... shared workbk
Re: Calculation conditional on yes no
Conditional Format Feature
Re: Conditional Format Feature
RE: Conditional Format Feature
Cell Value
Conditional formatting applicable to entire column
Un - Concatenate ?
Custom Cell Formatting and Calucations
Force entry to one of three cells
Need to read formulas
Changing an excel spreadsheet into a text delimited file
Re: Conditional formatting applicable to entire column
Numbers Converted to Text - Last Digit Replaced by Zero
Easiest Way to have access functionality in Excel or vice-versa?
AVERAGE and STDEV functions with logic
Re: Cell Value
Excel "Forgets" text-box text-direction
What function gives the Sheet name in Excel ?
how do I add a calendar function to excel as a drop down?
Button sizing handles do not appear
syntax to refer to a range as an array?
Re: Help with Aging Report
Auto-Insert Last Date Edited
Finding Value Conditional
Nesting IF Statements Based on Same Cell Value
How to delete rows when List toolbar's "delete" isnt highlighted?
Understanding a formula
Data Validation (in a range of cells)
URGENT!!! shared workbooks
Can I have a running total which begins again at 0 when dte chgs?
splitting my header into two lines
RE: splitting my header into two lines
FORMULA CONCEPTS
Countif for specific cells rather than a range ????
Marking Duplicates
Understanding a formula
Dates
finding what numbers are in a string (Day 2)
excell 2000
please give me an example of vlookup
SUMPRODUCT issue
Macro to cut/paste to last cell
How do I set up a time sheet using the 7/8 rounding rule?
Macro to email multiple worksheets
lookup
Save Prompt
Comparing text fields
Print Worksheets function needed.
How do I change font attributes in a Concatenate statement?
How to add data in two columns in to one column
Re: Excel Cell Restrictions
Count values ...
RE: concatenate problem
Curency Conversion Dilemma
Function to remove a space from text in cell WITHOUT macro??
how do i calculate pay from given hours and pay rates?
Problem with data from Access
Copying the Editing in one file to Another opened XLS file
when copying formulae from one cell to another it does not work
Conditional Formating Feature in Excel
Formula for This?
Cell Formatting
When subtotaling can Excel also calculate percentages
Construct cell reference for use in formula
Help please!!!
Filtering
Moving Decimal Places Up
How can I determine the century of a date in Excel?
HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10
How do I apply conditional formatting to a text box
Paste link does not work properly
Using a ComboBox for Data Entry into a Cell
Comparing two columns in two different worksheets
#Num Error with Rate Function
Insert Hebrew Date
If Statement Question
File Pahtway in Cell
Re: concatenate problem
Macro help
Calculating total amount of sales for each salesman
RE: If Statements and Arrays
RE: Remove text leading zero in text string
If Statements and Arrays
Remove text leading zero in text string
Counting Textual Answers
Sum if type question?
Ranking of cells from 1 to 20 with ties
How can I erase all but every 87th row in Excell?
Compound Rate Function
Numbers used for Ranking
Defining Ranges
=mid function
How do I hide columns using a button that slides back and forth
External link
what's the closest think to an "average if" function?
How to Calculate an unknown number?
Reference the worksheet from a multiple worksheet range function (
How to pull data out of an excell file with multiple tabs
Combinging two spreadsheets
Functions
How to od a combined IF and AND in a matrix formula
RE: concatenate problem
countif max value help!!!
calculate min in col B subject to text in col A
Max limit of 7 nested loops
Cobining more than 30 columns of data with concatenate.
How to cancel number rounding?
Lookup function returning reference, not value
Prefill cust info from drop list into other cells
Just $19.95 to start -HOME BUSINESS
How do I apply the ROUNDUP formula to a range of calculated data
can I name an excel worksheet tab by linking to worksheet data?
I am having trouble adding a row in Excel. What am i doing wrong?
find replace
Construct address as a reference not "text"
Problems with Sum Function
update info on 2 sheets @ same time
How do create a formula to evalute a # to return 1 of 4 conditions
How to combine dat from 4 fields into one field
concatenating "00"&"00"&"01" without losing the zero values
Decimal Question
COUNTIF and Nested Functions?
RE: concatenate problem
RE: concatenate problem
How do I get a spreadsheet to print to actaul size of page?
if statement module use please help
help with forumla needed... getting a yes/no answer to ??
Constant growth
Dynamic Formula
Need a formula that would make life easier
same formula giving diff resutls
converting hours to days,hours,minutes
validation combo boxes not working
How do I sort a horizontal worksheet to create a vertical table
Bilingual workbook problem
Login Logout Date Problem
Help need with formula
ACTIVATE CELLS
random numbers from a data of numbers?
IF AND question
IF AND question corrected
IF statement to check cell contents
Excel should let me imbed documents and programs within its-self
Help with function to add percentage to cell based on checkbox.
autonumbering
Re: How to assign a marco to a command button
pair single column to multiple column
Extracting data without using database functions
combining numbers into combinations
Command
re:Any Ideas?
Rank Question
Activate List of Email Hyperlinks
Re: Inserting rows
Lookup worksheet agony
Excel Calculation
#N/A resutls in Vlookup when there is a match
Why am I prompted for the workbook password for each worksheet?
Summing up time
adding a formula in a cell but when cell = 0 cell is blank
How do I count the number of alpha occurences in a range?
How to change a visible formula into a value? (Quickbooks download
deleted w/sheet. How do I recover
Sorting a sheet
I'm Lost, Need Help
excel compatibility
Can I count cells with specific format (e.g., yellow field?)
Excel takes along time to calculate
Insert excel data source into word doc using currency symbols
Combining specific ranges from multiple worksheets into one
How to find method to cut steel coil by using excel.
transferring checkbook template to excel
A way to refresh a certain cell everytime wroksheet changes
Fonts
Even and Odd Numbers
How select an item in a list box
renaming problem
sumif with 3 conditions
How do I perform a contains function for a specific cell?
Hyperlinking
Re: Hyperlinking
preventing one part of a formula from iterating
Ticks or Crosses
add cell across all worksheets
normalizing data -- a twist
NETWORKDAYS gives #NAME even though Analysis Toolpak is installed
Re: Autofill date based on date in another cell
Access Rights & Reports
Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
RE: Sumif Fucntion
RE: nesting functions
HOw do I set up Standard Error in a spreadsheet?
Volume and pricing calculations
RE: COUNTIF or SUMPRODUCT counting multiple criteria
RE: Macro - formula for end of last row
Column number of last column containing a number
Only do Sum function if not "0", IF"0" then return "0"
RE: Lookup Value is Between Range 1 and Range 2
RE: COUNTIF across all sheets of a workbook
nesting functions
making a number be text
Formulas in Excel
How do I put more than one criterion in a SUMIF function?
Opening Excel out of explorer or outlook attachment
Recogniziting Dates in an IF function?
Count the number of specific values in a cell
RE: SUMIF using a multiple-column range
ISERROR VLOOKUP
Putting Sheet Names in a range and renaming it?
Macro - formula for end of last row
COUNTIF across all sheets of a workbook
Empty cell control
Product development requirements tracking
Lookup Value is Between Range 1 and Range 2
Count if not 0 or return value of 0
COUNTIF or SUMPRODUCT counting multiple criteria
Is there a function that allows me to list the names of excluded d
SUMIF using a multiple-column range
Sumif Fucntion
How do I have a formula check if a value occurs within a range?
Determine the location of an external source of pivot table?
Sumif and autofill
Linking from several cells of 1 spreadsheet to fewer of another?
need to program my lists to automatically alphabetize when new ent
How do i make a formula reference the last entry of a column
Help with an if statement
Web Services function call and data refreshing
delete rows from multiple worksheets
more conditional format conditions
How do I calculate the area under the curve using Excel?
subtracting hours and minutes
the best prediction formula?URgent!
hidden names in active workbook
Converting 100 cents to 1 dollar
calculate predicted sales value
Filtering data to another sheet
calculate interest between two dates
a search function
emailing
How do I use 2 worksheets in 1 page
Re: Do I need a sumif or sum of a vlookup formula?
What is the use of {} before any formula?
Troubles with the OFFSET function
Array formulas
Trying to email a spreadsheet
Formula for next day based on clock
daverage problems
Re: can lookup a number to a 10x10 table?
how do u remove default setting?
VLOOKUP WITH ALPHA NUMERIC
Averge time
Search and Get Function Help
Is there way to restart page numbering for each tab in worksheet
My copy function won't work - I get error "cannot empty clipboard
Re: Search and Get Function Help
help needed with text to column
Date Formula
Length of employment
warning or message before saving spreadsheet
Opening Multiple Worksheets
Re: Time Date Formula Problem
Displaying only digits after the decimal point
how to make cell address reference increment?
Conditional Formatting Multiple cells based on 2 cells
DECIMAL PLACES IN FORMULAS
Re: Time Date Formula Problem
counting unique instances of text in a list
if statement in worksheet
Excel to Access
Formula for # of sales days in a month?
Optimize simple macro
using a slave worksheet
Reference to another worksheet
maximum of rolling totals - aka Rmax
Re: Reference to another worksheet
Gridlines into excel spreadsheet after changing background color
How do I use Office 2000 & Office 2003 on a network?
Hyperlinks change when Excel file is saved to a different director
Return range of values on an "IF" statement
vlookup
How do I get rid of infinite numbers past the decimal place?
Merge Worksheets
help!!
Why do my dates change when I copy them between Excel worksheets?
Random Numbers
working with IF statements
No showing of cellnumbers used in formular with colour
List
Automatically inserting rows
"COUNTU" function in Excel to count unique entries in a range
Excel Statistical Functions and Routines
calculate the value of a mortgage purchased at a discount
Past Due - Due Dates
List
Separating Numbers
Can I add a Warning Meassage to a Macros Designed to Delete a Row
Unexpected result
How do I move or copy more then one sheet at a time
16th digit changes?? Problem,16th digit changes to a zero....
=B<value of A>
comparing a value in a cell to see if it is higher than a number
the cell currently being evaluated contains a constant
SUMIF??
Returning an answer in an if fuction between two values
Match/Lookup Statements
Format Excel column to notify with a reminder
Excel function problems
Excel % Variance Formula........
Re: How to Calculate Time
Re: How to Calculate Time
Pocket Excel/Workday Function
Wildcards in other workbook cell refrence?
Dependent lists
Formula on nth row
look up same values in coumn1 and calculate values in 2nd column
stop automatically changing fomula ...
Multi-layer excel spreadsheets
if coum 2 has vale then populate colum1
Complex If Then formulas
How do I get a row to show up on every page
The ExcelTip forums update this forum
Logical Function
Time Value of Money
Is Datedif Outdated ?
SumIF Formula
Anagrams
automatically filter out blanks in multiple columns
in excel I want to set up a drop down & link that to another cell
Options Button
name list
I cannot get Excel to put negative amounts in brackets. Help !
Counting capacity based on technician schedule
macro used to change colors
Still need help
SumIF
Name list
How do I count how many times a code appears in a column?
cells functioning odd
Advanced use of IF
Use formula to hide/delete cell?
Syntax for 2 AND conditions within an OR function.
subrow names must appear in consolidating by category as tab name
need function to sum top ranking items in list
Data Valadation -
SUMIF With Multiple Categories
Sorting data in a master sheet
2 files, mass update comments between files
Cell Height formula?
Data Manipulation FUNCTION
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
Conditonal Format Formula
vertical text
Re: Formula checking multiple worksheets
Exclude data from summary totals when hidden
How do I create a numbering format in excel?
sequential numbering in non adjacent cells
column changed from alpha to numeric
conditional value required on basis of column a
Search in 2 kolumns and 1 row
Further Question about Transpose
Pivot Tables
Please help with formula
Help Userforms / Excel SUMIF
HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)?
Average of filtered data
Re: extracting text data in a cell
Conditional formatting in relation to other cells
MARK EVERY FOURTH ROW
SUMPRODUCT vs CSE
Decimal points not needed
Pivot Table - Extracting specific data
Pivot Table - Extracting specific data
Conditional Formatting with two Spreadsheets
alternate blank row
problem with SUMMEWENN
How do I shade cells during selection?
Nested Countif
"Sumif" and "DropDown" in palm
move column headings from row to column
How can I locate the second to last value in a range?
monitoring a changing range of cells
Can I use cell contents as part of a formula?
Re: How to Calculate Time
find and replace links in Excel 2003
"Drop the lowest" in computing average
Calculating recurring date in following month, calculating # days in that period
VLOOKUP works sometimes
Delete columns or rows
Excel Statistical Functions and Routines
jump to hyperlink, extract value at specific destination in file
Vlookup through entire column
Font size
Last Value in Column
Counting Unique Cells When Spread Sheet is Filtered
Sort of format Question
Re: Formula checking multiple worksheets
Excel should allow calendar based spreadsheet linking.
If Formula suggestion
nested function to add columns
MS Dialog 5.0 sheets - Accessing data elements of objects
Is is possible for a cell to reference it's "sheet name"?
CountIf first column range = "Word" and second column range <> 0
Produtivity Formula
Can anyone show me how to set up Excel for feet and inches?
helpfull links
how to get the rounding function off
SUMPRODUCT using and INDEX function doesn't total
Assign vaiable to a cell - gold
Why do we start the formula with + or -
Autofill/Reference Confusion
Is there a way to pick the cells to add using sum?
How to do more then one vlookup?
How to print the column # where the max row value is located?
Automatically enter today's date as a static entry
excel
excel
Re: IF Function
Re: Formula checking multiple worksheets
Re: IF Function
copying content of cell automatically to multiple cells
If Statements - how to do is like '%value%'
check if reference exists, then return its value or return 0
How does the Database Function work in Excel
Lookup Question
No Subject
No Subject
Return Consecutive Values
Re: Formula checking multiple worksheets
AUTOTEXT Feature of Word in Excel
VB script help..please !!
How do I specify cells to return a result in a quadratic?
COUNTIF Q
Returning with cell on right/left of a reference
Copy 1 Sheet to Another
SORTING DATA
using wizard and conditional sum
I know what I need but dont know how to do it
No Subject
No Subject
No Subject
No Subject
No Subject
No Subject
is there a 'format painter' hotkey?
sort data in cells in a row
Calculating Profit and Loss in one column
index random questions
Re: If function that returns value in a cell.
Re: random number results
How can I return a thank you note
Cannot save external links?
how to subtract time cards in minutes in excel
How do I do a conditional format for numbers
How do I subtract 1 hour from one cell and input it another?
lookup more than one cell
MAX formula with Associated DATE
Recurring annual events using a specific date as a trigger date
chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005
Filtering ?
Search and replace
If statement using multiple conditions
Worksheet Name
vlook up and if formula
Excel help
Unhiding worksheets
MIN Function w/ variable address reference
Conditional Formatting
Macro Filldown
Formatting a cell
How do I set up a workbook so changing Sheet1 changes all sheets?
Insert comment in protected worksheet
Frequently used file suddenly becomes 'not a valid file name'
VBA Conditional Formatting has mind of it's own!
Columns creation
Auto Calculating Time Sheet
Re: Formula checking multiple worksheets
Statistically Confident
Drop down list with an if statement
I wish to have multiple column widths for a the same column.
Re: VlLOOKUP function with MATCH
Re: VlLOOKUP function with MATCH
Assign a color to a cell
Adding By Color
formula
how do i set up an expiry date in an Excel worksheet
Using sumproduct to count number by date
Formula preceded by + sign
Sum of ranks
Sort ignoring negatives and positives
SUNPRODUCT and COUNTIF
Sumproduct with Date column
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES
Formula help!
how do I remove empty spaces trailing a text string?
Time scheduling
Re: Problem with XIRR function returning #NUM!
SUMPRODUCT
VLookup
How do I refer a Range to a Cell
What worksheet function will formatlessly copy cell contents?
sumif Q
Autocalculate does not work
search through workbooks
How to reference a cell in MS Excel that already has a SUM value?
Adding up Sums
Split PN and Price
Lost password
Cut links between worksheets in same workbook
Calculate the CAGR
Average Array Formula
how to set up Bowls league 12 teams points and shot difference
"if" formula to sum several cells...
how do i get "DGET" to take the first data meeting the criteria?
Stoping users pasting formulas into cells
save multiple page setups in Excel
Creating a macro to find and replace text
3D Ranges
Count data in cells
minimize problem
using SUBTOTAL() on rows that have been hidden
REMOTE CELL FUNCTION
Can you Link 3 cells into 1 in Excel 2003
yearly invoice
Array Formula
Problem with Excel SUM function
time sheet calc by time in and out
Formula HELP!
making one workbook out of two
using offset with array formulas
How to sum lowest lanking numbers?
3D Named Ranges
Fibonacci function/command in excel?...tia sal
Fibonacci function/command in excel?...tia sal
Formulas
Control for Worksheet static
How do I use the MOD formula to do the same action to a column?
minutes between
Need listing of links in a worksheet
How do I calculate running pace?
Formula Help Combing two AND statements
Using SUM function with #N/A in some cells
RE: Making a bar and a line graph together
Summing a range using INDIRECT & ADDRESS
Function to del rows based on cell value
How can I sort SSNs in Terminal Digit Order using Excel?
Custom Date formula needed
Function to search a row of data.
We're sorry - We're unable to service your request
Possible Lookup Table
if logical test true, then hlookup, if false then difference betwe
show what % bottom # is of top # in excel
Help with function to sum values in a worksheet depending on account number
How can I print two sided documents in Excel?
Binomial Proportions: Two-Sample Test
Formula that recognizes duplicates
Create formula for detecting duplicates
Assign values to text within a cell
How I use IF function
duplicate formula
A good book on Excel XP functions
Count bold text values
LOOKUP & RETURN CELL ADDRESS
If-Then Statements
reccuring date on spread sheet
rolling year in excel
Array Function Question
Need to use IF formula with a Date cell
get characters from a string in excel
progressive select
Count With Date Problem
Trying to count occurences if 2 conditions are met
Advanced Filtering
[Shift] + [Arrow] key usage with chart ranges
Display the last value of an array
Display the last value of an array
how do i change 20050614 within in a cell to a recognised date
HOW TO SAVE FILE NAMES IN COLOUR OR DIFFERENT FONTS
Alternate to Lookup?
set checkbox to enter date when checked and NOT recalculate
Display rows of data - vlookup?
copy combobox - cell link to change automatically
How do I separate words in one cell into two cells?
sumproduct by date
How can I replace 2 of 5 characters within an cell in MS Excel?
opening text files that have more rows than 65536
Time in data validation?
LINEST bug in Excel 2003
Linking Workbooks
How do I make it change colour
3rd friday in month
Search string for alpha or numeric
insert field from Word into Excel
I need an Excel formula
How can I allow an outline to be collapsed on a protected sheet?
IF a number then....
referencing cols in functions - NPV
Excell: count occurance of letters in a column
trim
How do I convert every cell in a spreadsheet to round to millions
Ignoring letters behind numbers
Can you make a cell blink?
Need Formula
Form with submit button
Disjoint range for DSUM criteria
how can I use shading as criteria in a formula?
Can't get a formula to work in each row of an Excel sheet.
How to create excel templates
deleting 100's of pictures, keep data
deleting 100's of pictures, keep data
How to resize Data Form dialog window?
currency # to full text equivilant
edit out ascii char 09
RE: currency # to full text equivilant
Reapeting Numbers From A Formula
Correlation Question
VLookup problem
Can you format a whole column of numbers to round?
function execution
Challenging Duplicate Question...
how do I add rows to a very large spreadsheet
Merge Worksheets
How do I use countif across non-adjacent cells?
Function Help
Date
Can't open files
Decimal to 24 hour clock please.
How to set up weekly time sheet with flexi time.
Get the sum of figures in red or a colorin spreadsheet
Count Unique Values
how to count occurence of numbers separated by , in a single cell
Extract Part of String
empty columns
write a function to determine if cells have names
error message when editing a large spreadsheet
How do I put multiple references in the same cell?
How do I delete multiple cells with decimal, not whole, numbers?
Problem with opening an Excel - File
Is lookup the key?
Auto average function
complicated sumproduct.
Assigning macro to a hyperlink
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?
SUMIF
Database Functions - question using formulas as criteria
Find and Replace Formula Links
Find duplicate numbers in large Excel Spreadsheet
MATCHING OF DATA
Age band formula
Re: How to run code to change Excel comment font
Conditional Formatting a Schedule
Can a vlookup value be more than one cell?
I am looking for help on a formula
Extract number in middle of cell
Compare and display multiple rows
Conditional list without blank rows
Number of Week Days _including_ Holidays
Vlookup
Selecting the top 4 largest value cells??
function execution
Help with Formula Function
Conditional formula
How do I turn off the automatic hyperlink function in Excel?
Taking data from 3 different cells and adding the components toget
Count # of times value "x" appear across multiple worksheets
Re: rate function formula??
Printing??
Cell errors
Paste values
DSUM
Need worksheet formula
center text in a formula result
Number Formatting
cell links
cell links
Excel auto calculation formula question.
Compare 2 cells values with one IF statement
Show trial solution
I need Counting Help
Why doesn't nesting subtotals work in 2003 version?
radians
Conditional Filtering
rolling time period
How do I remove the 1st 4 characters of a field in Excel?
A Function for Counting Since Last Time
how are random numbers determined
vlookup & wildcards
NETWORKDAYS FORMULA
From Target to Source
can i get excel to choose every 10th entry in a spreadsheet
XNPV function
Is there an APR formula for excel?
summation y years
How do I ignore cells in Excel?
pivot tables & queries
Re: Is there a function to change a number to text?
sumif on multiple pages?---not just one page
Copy drop down boxes and associate to cells dynamically in excel
Re: Is there a function to change a number to text?
Reference multiple cells in if statement
multiple items in database
Background
Printing Macro
Re: Wildcards in Functions
Need number of Saturdays and number of Sundays between 2 dates
assigning macros to buttons or autoshapes
Copying Formulas
Hyperlink changing row
best program to do purchasing analysis for multiple locations?
Any Samples???
excel 2002
Formula to find cell with data on a row