Microsoft Excel Worksheet Functions

Conditional Formatting
Calendar conversions
How do I nest a ROUND within a IF in Excel?
calculate best 4 out of 6 columns
in need of a formula
Month end calculation
importing rows to cols
Copying with a macro
How do I copy text using a formula between worksheets in Excel?
Removing Menu Bar
Help in formating cells
Combine data from 2 worksheets using unique identifier
cell formatting
worksheet protect
cell formatting
Can a cell be linked to display the name of the worksheet tab?
Template changes to existing workbooks
Conditional Formatting
Grouping Data
Grouping Data
Getting count
Date conversion formular
Remove first few characters
Sum of column C where results in column A match
Using the wotksheet name in a cell
Date Counting problem
Posting a charge at the first of the month
formula for returning the largest letter in a series of letters
linking a cell with a specific letter value to a cell with a formu
Registration Opens for UK Excel User Conference - July 19-21
What if
Count/Sum data with date entries.
Combination of Validation List and VLOOKUP Problem
Excel:I have15 #'s that total $65,000...which #'s make up $44,000
Lookup mulitple values and return one
Dynamic subtotals and eliminate dupes
Excel 2003, which formula will count the cells that meet 2 conditi
hi - Two columns
wanted help about text functions
Electrical Bill
timesheets
Conditional formatting for lowest number in a string
Can OR be used within MATCH
Lookup Values in Table
search for help? it sucks
Cell Reference with Range Name
how do I expand a cell without expanding column
Select only colored cells
Comments in a HTML format
how do i open up a spreadsheet in microsoft office
If Then formula
How do I add an angled tab to the top of each column?
Grouping rows together
find the same entries and calculate sum
Why I am getting Error Message: "Cannot shift objects off sheet"??
Running Same macro in 250 Worksheets in Same Workbook
Converting list of IP Addresses to list of Hostname
Can I make a graph using several tabs in an excel spreadsheet
No value returned in if statement
Excel 2003, need formula that meets two conditions then divides sums of numbers
Count Unless??
Another Basic formula I should know (but Don't)
Changing the formula to the number shown
refer indirectly to Name
where do I find the the action icon in regards to a meeting?
How do you enlarge the check box itself in excel?
sort source workbook data, maintain formulas in destination workb.
Seperating Numbers from Letters in Excel
Copy Worksheets from one Workbook to Another
How do I convert a number in Excel to text?
Date Comparison with VLookup
How to list Alphabeticaly
post positive sum as a negative? help!
How do I correct this calculation?
Function for 3 date columns
Conditional Formatting
How to make mtd and wtd totals on dates
Copying format when using "+'s" between worksheets
Filtering out weekday dead time
have a name change cells between sheets
hiding charts w/o data
Codes
cell reference to another file
Should be possible using built-in functions...
referencing data from a table
Using information from one worksheet, to rename inserted worksheet
Re: Avoiding Errors When Attempting To Retrieve Data From A Non-existant Worksheet
Re: Avoiding Errors When Attempting To Retrieve Data From A Non-existant Worksheet
3-way lookup help
Text or Number
COUNTIF not working
How do I scan a excel print into excel
How do I correct this formula?
I need current value of one worksheet into another cell?
Return multiple records matching multiple criteria
Offset Type Lookup
Serial number of Date
Link Tab Name to Cell
Microsoft Visual Basic: Compile error: Sum or Function not defined
how to identically size merged cells for filtering use
Round amount to nearest $10 after other formula calc. in same cell
Cell Formula
Cell Reference Change
Help with TREND function
subtraction formula
Select a range but only sum the cells in a certain colour?
Selecting rows based on cell entries
Cancelling automatic links
Can the sheet tabs be color coded?
Automating text in a cell
help! printing locks up excel
Re: Copu worksheet ranges from One Workbook to another from
Copy worksheet ranges from One Workbook to another from
Exceptions to =Countblank function
Removing protection from excel worksheets
Macro to Unprotect sheet!?
copying with a Macro
Matching Text
special case of sumif
Gitter
Help with Date formula
Hot key for time?
TODAY function question...
Formatting imported data
Auto Change in Cell Color
use cell reference,whose contents= a table array name for Vlookup
Excel sum, conditional, if??
How can "data validation" be enforced in calculated cells
Multiple Pastes Between workbooks
russian excel vlookup
auto fill sequence...
Is there a way to create a toolbar icon for 'page setup'?
Tracking changes
How do I take cell data and automatically put it in an email?
Copy and Paste in certain format
Counting Function
Clear Cell Without Removing Formula
How do I compare cells and if FALSE compare to next cell in EXCEL
Number to be like in colum A, if number in colum B and C are like
special case of sumproduct
copying sheet references that refer to a cell in the preceding she
Excel Math problem
multiple rows with some dups where I need result on one line
Display Rows From Sheet1 In Sheet2 (Import)
Two People Using Same File
RE: Auto fill dates
Worksheet tab name
Auto fill dates
comparing two lists and returning value from different column
iserror
Can Excel list order according to Total scores?
gains/losses formulas
Sorting affecting my data ranges
Formula help
Countinuation of Formulae in new array
Re: Complicated Conditional Sum
Dont prompt for passwrds when open files
Re: Complicated Conditional Sum
Quick formatting for negative numbers
Protect Formulas
Lookup problem?
Auto-Numbering
Help With If And Or
How Do I Get This Formula Result???
Question re best practice
Formula to find average of field for all rows that contain another field
sum wrt substrings!
looking for a way
N/A mine is returning with 1
user defined function based on contents of cell
Multiple hyperlinks
dcount with vba
dcount vba
lookup and autonumber
Split contents of a cell
Copying a calculations answer and not the calculation
Copy Problem (progression in formulas)
error analysis
getting the sum of variabel ranges
Conditional sum
Advanced lookup
Square root with a remainder
nested if statment - needs if(isna
Data Selction
decimal to 16 bits binary conversion in Excel?
multiply time and currency
Extracting using seperators
Conditional data
RE: Summing a range with conditions
RE: Extracting using seperators
RE: is number between values
Detecting patters in data
RE: how do I get a spreedsheet to print an 8x11 size
RE: Help with CountIf < and > time formula please
RE: repeat an entry on spread sheet
RE: how to consolidate data in different excel sheets
RE: countif
Combine 2 spreadsheets w/1 common column of data, text and number
RE: VLOOKUP USING 2 LOOK UP VALUES
Conditional Formating
how can i get a cell to flash or blink
RE: sumif or count between zero and 3
Sum up a particlar cell in multiple Excel worksheets within same b
Conditional If statement
RE: Conditional data
RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
lookingup a value in a table
Summing a range with conditions
AND array
RE: VLOOKUP USING 2 LOOK UP VALUES
RE: Font selection within formula
RE: Problem using IF function for a gradebook
RE: using the countif function
RE: Auto Numbering
Problem using IF function for a gradebook
Returning contents of a cell
Sorting Formulas with "Empty" Results
RE: an excel formula for specific conditions
Getting a case sensitive match?
dechex
RE: an excel formula for specific conditions
CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES
Re: Conditional data
sort data rows "greater than or equal" criteria in another cell
RE: Getting a case sensitive match?
countif
Auto Numbering
Tabbing through Unlocked cells
Insert Row & Copy Formula
How do I set up a euchre rotation schedule
RE: Date and Time
repeat an entry on spread sheet
RE: HTH
maximum entries
Validation rule - custom 5 digits w/ leading zeroes
RE: how to create refrence using first and last words of any supplier
RE: Excel formulas
How can you get a macro to work in transfer data from AS/400?
how to create refrence using first and last words of any supplier
RE: VLOOKUP USING 2 LOOK UP VALUES
an excel formula for specific conditions
How do I differentiate between duplicate ranks?
RE: formula in one cell or another
Excel formulas
RE: How do I set up a formula to count only unique items in a column?
Amortization template for uneven monthly payments
How do I set up a formula to count only unique items in a column?
holding a value after first calcuation
using the countif function
Scroll bars: how can they be rotated?
RE: Font selection within formula
RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
VLOOKUP USING 2 LOOK UP VALUES
sumif or count between zero and 3
how do I get a spreedsheet to print an 8x11 size
Verify spelling in a vlookup formula
HTH
Help with CountIf < and > time formula please
is number between values
Font selection within formula
RE: how to consolidate data in different excel sheets
create a list box in one cell of state abbreviations
how to consolidate data in different excel sheets
RE: formula in one cell or another
RE: is number between values
Lookup and conditional formating
'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
validation rule - force text entries to appear as Proper
copying part of a cell's contents (formatted as dd:hh:mm)
how can i make dual label cells?
formula in one cell or another
replace blanks using formula
When I insert rows in Excel the pagination gives me unwanted page.
Date and Time
Prohibit entry of special characters
conditional formatting with dates
worksheets xlSheetVeryHidden and show them once password-app
Vlookup in pivot tables
show fridays
I want to count *'s that i have put in my sheet ?
Making Cell Blank
Vlookup and SUM
London Excel User Conference
How do I create a formula by percentage within a formula?
add time greater than 9999:56
Formula Help
xirr prorated?
Averaging data
Who can I make a Cumulative calculation in Excel sheet?
= selected cell?
Hyperlinks within worksheets
crazy discount !!
conditional formatting in excel
SUM ERROR
highest value
Delete empty rows from print in Excel
sumif statements
Option Button
Matrix info
Can i print non-contiguous areas on one page
HELP: text keeps on displaying ##############
how do i make one part of my formula bold and the other normal?
How to creat summery file form many xl files?
Loop time seems dependent on unrelated workbook - Why?
How can I create an AutoFormat row color change for a value in a c
Calculating time between values (tricky Problem)
Using the IF formula
Update Links
conditional fomatting
Text To Column
VLOOKUP in large Data sets of more than 16384 rows
How do I do this, can it be done?
Combine many exel files to one
How do I "lock" a graphic to a particular cell in Excel?
Data Ranges
automatic address and phone cell entry
Nested if in Array
Conditional Format - 2 lists of names to find matching cells.
Simple? Formula for "for the week starting Monday May Xxth"
intersections of rows and colums in calculations
How do I format spreadsheet w/o changing font size?
Run Macro from a Cell
How to 'Automatic Post' Accounting?
Is it possible to automatically change color of cell by keying off the date?
Excel - need an serial # to update everytime sheet is printed.
XIRR & -ve answers
individually time stamp a row when a change is made to that row
How can I get TreePlan for excell?
Re: how to get a total to add up a range
Matching Combinations
LIst Problem
Create folders in Window Explorer from tab or csv files export
Color Code Rows
How do you link multiple cells in a worksheet?
Formula for top n
Convert WeekNum to Sunday's date
rowwise total!
formula for lenght of employment based on hire date
ADD Macro - xlup plus xlto right
Counting the occurences
Min Max Editing
How do I do multiple IF statemnets in one cell in Excel?
Data Entry Using Pulldown
Links error if referenced file not opened
=networkdays formula was working, but not in upgrade to 2003
how do I set up if an answer is No then following row is hidden
Macro to help oepn the file without prompting fopr passwords
Macro to help oepn the file without prompting fopr passwords
Date Calc in hours
Large Function returning top values
Target directory & Path
Average time for a race in minutes seconds & tenths
How do I create a conditional formula that hides a complete row o.
Data tracking and auto sequential numbering
Lookup 2 directions
rolling sheet references
solving a formula
DropDown Menu
Need to look up value in another Sheet based on criteria in first sheet.
Creating a formula that will SUM with 2 Variables
how to extract input data?
Replacing missing values?
Average a part of a on going column
How to feed dynamic information to a drop down List (Validation Feature)?
Printing
copy 40 tabs into 1 tab automatcially??
Data Table Input Limits
Suppress duplicate data
Copy/Paste Help Please
copy data between sheets, but not the formula
Extract Certain Characters and Numbers
Checking data range in Pivot
Printing Multiple Data Validation Lists
Return Blank
reverse mapping for LOOKUP table?
How can I get an expired date to automatically be highlighted?
Nested "if" for price list
Remove the "False" from Statement
Conditional Formatting Formula
How to exclude data that has already been imported?
If Vlookup returns error enter 0
Conditional Formating a cell .. to Show Nothing .. if True
Hide an entire tab.
Date Function
=if with multiple choices
Excluding Zero's from Average (SumIF / CountIF)
Formula to look up a column and paste results in another column
Comparing and copying information from one cell to another
Date Format
Ranking - Excel 2003
Function displays as text, doesn't return result or error
List Validation Improvement Suggestions
convert lats and longs to decimals
Round current time
How to insert text in one column and populate numbers in another
calculate a formula instead of returning text
How do you truncate a text string?
How do I compare lists in Excel?
Excel kept on asking to save file every time I jump from one sheet to another!
Restore an Excel spreadsheet
lookup help!
Need a formula
how do i add text to Excel worksheet ?
Can a workbook be locked against change to cells containing references to other files?
how do I round hours worked to the next half hour with a 24hr shif
String parsing with variable lenght strings
SUMIF with multiple criteria, by columns
lookup across multiple columns
Calculating a Percentage
cell sizes
How do include Dates in a formula?
Dynamic fill of columns
need help
Calculate Ebay Insertion Fees
change letter to number add number
change letter to number add number
How to replace a text with another
lookup
Sum IF
Control Display of Drop Down List in Validation
Excel - Changing value of a date by a number of calendar months
calculate days
Graph
Calculations not changing in cells
to make cell absolute
Mail Merge from Excel file
I can't sort my miscrosoft excel worksheet anymore, what happened?
Can I create an If Statement that will replace text
How to set cell 00/1-20/000 to move to another cell
Problem writing formula
Create button on worksheet to restore woksheets orignal values
Finding Cells
macro or worksheet function?
Using a calander for date select in cell
UK Excel User Conference - July 19-21
sort data by criteria other than ascending or decending
How do I keep cell color formats separate from text during A-Z sor
where is spell check on excel 2007
Highlighting a whole column
How to seperate data in a cell which is split by a comma
Re: How to seperate data in a cell which is split by a comma
How to find a row in a sheet and compare the complete row /w origi
Rounding
Use worksheet name
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
Lock a file so it can't be altered unless saved as another file
Unprotect sheet button!??
I need =SPELL()>True/False function in Excel
How do I count differert items in a column only if the date in an.
Unique numbers from data validation list
Copying Cells
Working Hours (formula & graph) - any elegant solution?
Please Help
UK Excel User Conference - July 19-21
Re: Loop time seems dependent on unrelated workbook - Why?
Automatic colouring of cells
Conditional Format as a MACRO
Function for upper and lower control limits?
Countif, Match or Sumif Formula
control limit
if statements, and statements
To Protect Excel documents and allowing only few cells to edit
NETWORKDAYS FUNCTION, Help please
NETWORKDAYS FUNCTION, Help please
Help with Countif
How do you make information from one worksheet feed to another?
How can I count conditional blank cells?
Emailing Macro
formula help: calculate length of employment
#DIV/0! Errors
Convert Lats and longs to decimals
Apply a formula as a pivot table calc or suggestion
Automate Copy / PasteSpecial
Why does my formula in Excell return a #N/A?
Different ranges in formula
saveto or Submit Form functionality in Excel
when using find I want the box in excel to be highlighted
Sum/average numbers in column A dependant on value in column B
Easy question for you, but hard for me.
a text array formula
How do I make an IF statement change cell shading
Conditional Rounding
cell references
Re: Formulae for Tolerence
Receive #VALUE! when I mix text with dates using SUMPRODUCT
importing multiple .dat files!
Flagging constants
Standard deviation - confidence intervals
Conditional Formatting for a range situation
N/A return
Re: Custom Function not updating
How to apply a formula to all cells in a column
Custom Function not updating
Auto sort
dollars/cents multiplied by hours/minutes or tenths
group counter in excell
formulas in worksheets/workbooks
remove conditional format
How do I sum text cells with number cells?
Rehide Sheet in macro.
Leave existing data in a cell alone
updating separate spreadsheets
Need help with concatenate formula
change the case of all the text in a coloumn
How do I get rid of FALSE, #VALUE!, ###, in cells?
reverse principle calculation
Need help with concatenate formula
adding digits of a number
Returning Cell Value if someone deletes the contents of a cell
List of data available for each cell within a coulmn
average data from diff sheets
Problem with paste
Counting Words
How do I make items repeat on a pivot table?
How do I get an excel field to 'prompt' me to add a number to mul.
Count Formula Problem
Conditional Formatting: Formula is
NORMDIST function
Sports Comp Ladder tabulating help needed
Variable Determines Number of Cell in Formula Range
1900 not a leap year
please help how to combine IF function with Countif function
Using IF function
find largest value cell acrss worksheets
Excel 2003 Simply Stopped Working
How do I hide and unhide the same columns without reselecting
Keep text filter away numbers
RE: Formulae for Tolerence
Validation - clear blanks from drop down
Converting cost price to retail in vast array
Conditional formatting - Find common material
formula accross cells..when inserting a row..
hlookup function
FOrgot Password
How to get time to update automatically and continuos
do I need array formula or sumproduct for counting?
how do i slide months of data under my first column?
validation and further
Transposing + Absolute Reference + Multiple Worksheets = my headache
Hyperlink failed
how can I perform trig. functions usings grads 400deg per circle
Comments/Warning fields
How do i cross reference two excel spreadsheets?
How do i cross reference two excel spreadsheets?
ADDRESS
Combining IF AND & FIND Functions
In Cell Layout
Help with a formula
Identifying Duplicates in Columns
How to recursivley test cells for numbers and write results to a table (0/1)
Re: Hlookup, how di I get it to return more than one cell
need help accessing other cells within a function
Import a word document
How do I make all columns in a range in a worksheet the same width
Function for an object
Don't print a specific cell
sum sub levels.
Offset VLookup
Excel 2003 index function does not calculate
RE: Help with a blank cell warning
If statement with Vlookup
Password\Backup
Need to use if statement with drop down lists has this been done
FLOWCHARTS
Sort a Spreasheet by Color Highlights?
merge text from 2 columns into 1 then delete the old 2 columns
Combining Text from 2 Columns into 1 then Deleting the 2 Columns
Conditional formatting of text in a shared workbook.
how to do a wookbook with sheets and subsheets?
How do I print my excel contact sheet into avery labels
Use array to return array of values
How do I calculate grades from excell
How do I assign a unique ID number to an invoice sheet I created?
Data overflow to second worksheet
Automatic Saved Date
If the cell contains..., do something (2)
RE: Advanced Lookup (lookup for 2 values)
use data in a cell in a formula
Formulas that refer to other colums for arguments?
Calculating Per Diem Rates
WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?
Auto-delete Unbolded Cells
How do I print 1/3 cut Folder Labels from Excel
Vlookup? help.
Extracting text from text string
Changing Cell References To a Different Worksheet in the Same Cell
How to reference a worksheet name
VBA Help
get the last number from the row
Need help with a dynamic lookup and logical formula
Convert excel spreadsheet into crystal report
#VALUE Help
Drop-down list Populated by a Subset of a larger list
rather complex logic statement
Score a list of numbers
data entry problems
Entering a hyphen into a cell
Sorting Parent Child
place text in one cell
Lookup based on range of dates
SUM of a variable range of fields
how do i do this - increment month by 1
combining multiple rows of data into one single row of data
Updating formulas
How to use lookup to retrieve next LARGEST value?
Formulas for Time Sheets
Clearing associated dropdown fields
Cannot do calculations with numbers?
Lookup problem
count only visible cells
Help creating formula
Finding Text To Copy To Another Worksheet
Transposing Data using Offset function
How do I sum values returned from functions?
charts
problem with checkbox control
Help writing an IF statement
How to have Excel Fill In Data in Column based on another columns
Illegal Immigration, the Non-Issue of the Week??????????????
Excel not calculating formulas
Will illegal immigrants get deported?.........Of course not.....................
Amnesty for illegal immigrants will not happen this time.....................
>@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
EOMONTH error
Keeping pictures with data
<%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
How do I extract data from every other cell in a colomn?
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")
sumif from activeX control
Upper case to Lower case
Crazy discount ！！！
Format Numbers
How do i add to information to microsoft exel worksheet
How to Calculate ANTILOG in EXCEL SHEET?
Text Time Conversion Calculation
Please explain
"workinghours"
Using IF function for inbetween cell values
Empty Cells
inventory comparison formula??
<><><><><><><>The Net's #1 Joke e-Book!<><><><><><><><>
Counting text in multiple cells.
Changing file default
>@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
copy/Paste references other worksheet
OFFSET to include blank cells
combining 2 dates into 1 cell
<%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
Deleting contents of cells in non contiguous ranges
formula using up 2 10 cells of $ 2 seperate & = $ amt
Matching Subtotals
Add decimal years to a date
Combining functions
Concantenate Help
RE: If statement to find NA()
how do i create a drop down list of items from a different file
Copy/Paste Drop Down List
Replacing Colored Items with Tags
If statement to find NA()
Remove green mark upper left several cells Excel?
VLOOKUP should compare numbers stored as text to plain numbers.
delete unused columns and grey out the rest area
CF ROWS
Can a formula ignore empty cells?
Where is the link???
HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA
Using Cell Variables to Specify Cell Range
How to COUNTIF blank cells?
How do you make an graph containing an algerbrica formula?
Grouping Similar items
Delete every other row.
Formulas that refer to (several) other columns for arguments...
Converting a GIF or JPG into Excel
not sure how to proceed
Is there a way to return records?
IF statement including BETWEEN
How do I sum a date specific range of cells?
Date (hours and still counting)
Truning 0 vaules red
Turning 0.000 values red
Matching Text with With Certain Criteria
Display a "0" when #N/A appears in formula
Find & Replace woes
New text added to cell AFTER current text in same cell
maturity schedule fixed inc securities by month, quarter and year
present value function
Count Unique Values with Multiple Criteria
excel-How many macros can one spread sheet have
Count dates falling in a certain range
freezing formulas
freezing formulas
Function Encyclopedia??
eMoovie - a new company - we need sponsors
HELP with dreaded formulas...
Countif, Maxa or other function?
How do change entire worksheet to uppercase letters and lock it
Sponsor Tree
sorting data by a certain attribute
Formula that will test text conditions in a single cell
How do I "Sum sales figure for a finacial month to currenct week"?
retrieving values from a specified sheet
formula to workout equal to or greater than
Re: searching multiple worksheets
Check if Equally Divisible
Sumif function
Is it possible to convert a number into hours and minutes
How to enter pre-decimal pounds shillings pence in Excel workshee
IF and MAX statements
Re: searching multiple worksheets
Validation Q
add 1
VLOOKUP
Referencing a range of columns and rows with the IF function
dates
Working out wagees
I am trying to "mirror" a row in excel, help??
Summing every nth row value based upon variable
If And Or
rate of return
Why would a pasted formula not calculate the new cell refs?
Summarizing totals of all worksheets to one worksheet?
Identify number of items with characterisitics from two columns
How can I use the "TODAY ()" Function in an "IF/THEN" calculation
condition formating
How do I delete <br> or <b> that appears in text?
Date entries
how do i add numbers in nonadjacent cells?
Vlookup problem
problem with blank cell
number formats
how to substitute a value for calculation with a column of values
Deducting a %
Status Changes
Return an Alpha based on number position in a word
Have column of nums, need qty of each?
Calculate from time formatted cell
Help Requested on Formula
check marks in excel cells using your mouse
change cell value greater than another cell value using formulas
Searching Columns and Rows
Fill cells with times
How do I set cell colors based on if query
Array sum for negative match
How many decimal places can a cell display?
Input range and link a cell
Updating LINKS when opening a workbook
LARGE and INDEX functions
Re: No duplicate names in a range (A2:A200)
Re: No duplicate names in a range (A2:A200)
Updates Problem